[ZBX-8100] SQL error while mass remove maps on Oracle database Created: 2014 Apr 16  Updated: 2017 May 30  Resolved: 2014 Apr 28

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

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

Issue Links:
Duplicate

 Description   

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 [sysmaps.php:201 ? add_audit_ext() ? DB::insert() ? DB::reserveIds() ? DBfetch() ? oci_fetch_assoc() in /srv/www/htdocs/include/db.inc.php:589]



 Comments   
Comment by Eduards Samersovs (Inactive) [ 2014 Apr 17 ]

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

Comment by Eduards Samersovs (Inactive) [ 2014 Apr 28 ]

Fixed in versions 2.3.0 (trunk) r.44884, 2.2.4rc1 r.44883

Comment by Alexander Vladishev [ 2014 May 06 ]

Similar issue: ZBX-8176

Generated at Thu Mar 28 20:38:58 EET 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.