[ZBX-8176] SQL error while mass update web-scenarios on Oracle database Created: 2014 May 06  Updated: 2017 May 30  Resolved: 2014 May 09

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 2.2.3
Fix Version/s: 2.2.4rc1

Type: Incident report Priority: Trivial
Reporter: Alexey Pustovalov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: oracle, webmonitoring
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate

 Description   

Updated: Web-scenario "***" at "***".
Updated: Web-scenario "*****" at "***".
SQL error [ORA-01002: fetch out of sequence] in [SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid' FOR UPDATE]
oci_fetch_assoc(): ORA-01002: fetch out of sequence [httpconf.php:287 ? add_audit() ? DB::insert() ? DB::reserveIds() ? DBfetch() ? oci_fetch_assoc() in /srv/www/htdocs/include/db.inc.php:589]

 Comments   
Comment by Alexander Vladishev [ 2014 May 06 ]

Similar issue: ZBX-8100

Comment by Krists Krigers (Inactive) [ 2014 May 07 ]

Fixed and committed in r45143, branch svn://svn.zabbix.com/branches/dev/ZBX-8176.

(1) Also did search and added DBStart() / DBEnd() where add_audit() is called in foreach - r45144.

iivs CLOSED.

Comment by Ivo Kurzemnieks [ 2014 May 09 ]

(2) Same problem in screen list configuration.

kristsk RESOLVED in r45235.

iivs CLOSED.

Comment by Ivo Kurzemnieks [ 2014 May 09 ]

(3)

  • Let's use DBstart() instead of DBStart() and DBend() instead of DBEnd().
  • adm.regexps.php: 185 the line is empty. But you can move clearCookies($result) there.
  • maintenance.php: 220 would be good to start tranaction before get_maintenance_by_maintenanceid() so it's more consistent with other DBs and trunk version.
  • usergrps.php: 225 transaction should start inside the if clause at line 227.

When in doubt, see trunk r42749 under ZBX-7749.

kristsk RESOLVED in r45233.

iivs CLOSED.

Comment by Ivo Kurzemnieks [ 2014 May 09 ]

TESTED.

Comment by Krists Krigers (Inactive) [ 2014 May 09 ]

(4) Need to check if this is an issue for trunk as well.

kristsk Checked trunk, no issues found. No need to merge to trunk. CLOSED.

Comment by Krists Krigers (Inactive) [ 2014 May 09 ]

Merged and committed to branch 2.2 in r45252.

Generated at Fri Apr 19 02:57:23 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.