[ZBX-5389] Monitoring->Graph not working after upgrade from 2.0.0 to 2.0.2 on Oracle DB Created: 2012 Jul 31  Updated: 2017 May 30  Resolved: 2012 Aug 09

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 2.0.2
Fix Version/s: 2.0.3rc1, 2.1.0

Type: Incident report Priority: Blocker
Reporter: Olgierd Wolodkiewicz Assignee: Unassigned
Resolution: Fixed Votes: 1
Labels: database, frontend, graphs, oracle
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

RHEL5.6 + Oracle 11.1.0.7.0 + httpd-2.2.19 + php-5.3.13


 Description   

After upgrade (summary) I have message in Frontend:

ociexecute(): ORA-00907: missing right parenthesis [include/db.inc.php:446]
SQL error [ORA-00907: missing right parenthesis] in [SELECT DISTINCT g.* FROM groups g,hosts_groups hg,hosts h WHERE hg.groupid=g.groupid AND h.hostid=hg.hostid AND h.status=0 AND EXISTS (SELECT 1 FROM items i,graphs_items gi WHERE i.hostid=hg.hostid AND i.itemid=gi.itemid ROWNUM <=1) AND g.groupid BETWEEN 000000000000000 AND 099999999999999]
ocifetchinto(): ORA-24374: define not done before fetch or execute and fetch [include/db.inc.php:579]

 Comments   
Comment by Toms (Inactive) [ 2012 Aug 02 ]

Fixed in dev. branch: svn://svn.zabbix.com/branches/dev/ZBX-5389

Comment by Pavels Jelisejevs (Inactive) [ 2012 Aug 03 ]

(1) We can't add "AND" to zbx_limit() because the ROWLIMIT condition is a part of the WHERE clause, and if we don't have any other conditions, we'll end up with something like "WHERE AND ROWLIMIT ...".

<Toms> RESOLVED though at this point we don't have usage for this functionality.

<pavels> Please add the $afterWhere parameter to other zbx_limit() function. Their interfaces must be the same.

<Toms> RESOLVED in r29483

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Aug 09 ]

TESTED.

Comment by Toms (Inactive) [ 2012 Aug 09 ]

Resolved in 2.0.3rc1 r29500 and 2.1.0 r29501

Comment by richlv [ 2012 Aug 29 ]

this was reported against 1.8 as ZBX-5505

Generated at Fri Apr 26 02:02:38 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.