[ZBX-641] History log files failed with Oracle Created: 2009 Jan 01  Updated: 2017 May 30  Resolved: 2009 Oct 16

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Agent (G), Frontend (F), Installation (I), Server (S)
Affects Version/s: 1.6
Fix Version/s: None

Type: Incident report Priority: Major
Reporter: Alexey Pustovalov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Gentoo, Oracle 10g2


 Description   

In history.php page, when you select a few items log file monitoring, there is a mistake:

ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-00904: "ARRAY": invalid identifier[/var/www/zabbix/include/db.inc.php:476]
SQL error [ORA-00904: "ARRAY": invalid identifier] in [SELECT MIN(t.clock) as clock FROM trends t WHERE t.itemid=Array]
ocierror() expects parameter 1 to be resource, boolean given[/var/www/zabbix/include/db.inc.php:403]
SQL error [] in []
ocifetchinto() expects parameter 1 to be resource, boolean given[/var/www/zabbix/include/db.inc.php:525]
ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-00904: "ARRAY": invalid identifier[/var/www/zabbix/include/db.inc.php:476]
SQL error [ORA-00904: "ARRAY": invalid identifier] in [SELECT MIN(t.clock) as clock FROM trends_uint t WHERE t.itemid=Array]
ocierror() expects parameter 1 to be resource, boolean given[/var/www/zabbix/include/db.inc.php:403]
SQL error [] in []

Zabbix 1.6.1 rev 6487

 Comments   
Comment by Artem Suharev (Inactive) [ 2009 Oct 05 ]

Please try latest release of zabbix, and report if problem still exists.

Comment by Alexey Pustovalov [ 2009 Oct 06 ]

Illegal offset type in isset or empty[/var/www/zabbix/php/include/profiles.inc.php:35]
Object of class OCI-Lob could not be converted to string[/var/www/zabbix/php/history.php:434]
Object of class OCI-Lob to string conversion[/var/www/zabbix/php/history.php:434]

in rev 8040 trunk

Comment by Alexey Pustovalov [ 2009 Oct 06 ]

in history.php: 434

  • $row['value'] = trim($row['value'],"\r\n");
    + $row['value'] = trim($row['value']->load(),"\r\n");
Comment by Artem Suharev (Inactive) [ 2009 Oct 16 ]

Fixed in rev. 8102. Please verify

Comment by Alexey Pustovalov [ 2009 Oct 16 ]

working, thanks!

Generated at Tue Apr 16 10:43:57 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.