ORA-24806: LOB form mismatch

[BDiE8VNy]

Hi,

showing the history of an item with values of type 'Text' fails with an error message:

OCI-Lob::load() [<a href='function.OCI-Lob-load'>function.OCI-Lob-load</a>]: ORA-24806: LOB form mismatch[/usr/share/zabbix/include/db.inc.php:626]

for each line / value in the history.
The item's value is taken by a Shell-Command:

UserParameter=openvz.updateubc,/usr/bin/sudo /usr/bin/install -o zabbix -g zabbix -m 440 /proc/user_beancounters /var/log/zabbix/user_beancounters && echo Update succeeded || echo Update failed

In the view of 'Latest data' the column 'Last value' shows the value as expected ('Update succeeded').
I found a closed PHP bug (http://bugs.php.net/35973) which produces the same error message but I'm not sure if the mentioned issue is the same.

Any ideas?

System environment
Server: ZABBIX 1.8.4 (Oracle Call Interface)
Proxy: ZABBIX 1.8.4 (sqlite3)
Agents: ZABBIX 1.8.4 (connection via proxies and directly)
Server Database: Oracle RDBMS 11.2.0.1
OS: CentOS release 5.5
PHP: 5.1.6-27.el5_5.3
PHP OCI8-Module: 5.1.6-27.el5_5.3 with oracle-instantclient11.2-basic-11.2.0.2.0-1

[BDiE8VNy]

I think the mentioned PHP bug is not responsible for this issue.

Our DBA has changed the datatype of the column 'value' in the table 'history_text' from 'NCLOB' to 'CLOB'.
The issue still exists.

-- rename existing NCLOB column
ALTER TABLE history_text RENAME COLUMN value TO value_nclob;

-- add new CLOB column
ALTER TABLE history_text ADD value CLOB DEFAULT '';

-- copy existing NCLOB values into new CLOB column
UPDATE history_text SET value = value_nclob;
COMMIT;

[BDiE8VNy]

https://support.zabbix.com/browse/ZBX-3693