[ZBX-5759] Oracle fetch failure Created: 2012 Oct 29  Updated: 2017 May 30  Resolved: 2012 Nov 16

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: None
Affects Version/s: None
Fix Version/s: 2.0.4rc1, 2.1.0

Type: Incident report Priority: Trivial
Reporter: Alexander Romanov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: debian, frontend, oracle
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

2.0.3 oracle debian 64


Issue Links:
Duplicate
is duplicated by ZBX-5772 When deleting items I have very often... Closed
is duplicated by ZBX-5879 Possible ORA-01002 for a cursor that ... Closed

 Description   

I cloned Template OS Linux (little bit custom version) to Template Freeradius, then i deleted almost all triggers. That was ok.
Then i tried to delete almost all items and get this error -

Deleted: Item "Software raid md0 state" on "Template Freeradius".
Deleted: Item "Software raid md1 state" on "Template Freeradius".
Deleted: Item "Software raid md2 state" on "Template Freeradius".
Deleted: Item "Maximum number of opened files" on "Template Freeradius".
Deleted: Item "Maximum number of processes" on "Template Freeradius".
Deleted: Item "Number of running processes" on "Template Freeradius".
Deleted: Item "Number of processes" on "Template Freeradius".
Deleted: Item "Cron proc check" on "Template Freeradius".
Deleted: Item "Ntpd proc check" on "Template Freeradius".
Deleted: Item "Sshd proc check" on "Template Freeradius".
Deleted: Item "Host boot time" on "Template Freeradius".
Deleted: Item "Interrupts per second" on "Template Freeradius".
Deleted: Item "Processor load (15 min average per core)" on "Template Freeradius".
Deleted: Item "Processor load (1 min average per core)" on "Template Freeradius".
Deleted: Item "Processor load (5 min average per core)" on "Template Freeradius".
Deleted: Item "Context switches per second" on "Template Freeradius".
Deleted: Item "CPU $2 time" on "Template Freeradius".
Deleted: Item "CPU $2 time" on "Template Freeradius".
Deleted: Item "CPU $2 time" on "Template Freeradius".
Deleted: Item "CPU $2 time" on "Template Freeradius".
Deleted: Item "CPU $2 time" on "Template Freeradius".
Deleted: Item "CPU $2 time" on "Template Freeradius".
Deleted: Item "CPU $2 time" on "Template Freeradius".
Deleted: Item "CPU $2 time" on "Template Freeradius".
Deleted: Item "Host name" on "Template Freeradius".
Deleted: Item "Host local time" on "Template Freeradius".
Deleted: Item "Free swap space" on "Template Freeradius".
Deleted: Item "Free swap space in %" on "Template Freeradius".
Deleted: Item "Total swap space" on "Template Freeradius".
Deleted: Item "System information" on "Template Freeradius".
Deleted: Item "System uptime" on "Template Freeradius".
Deleted: Item "Number of logged in users" on "Template Freeradius".
Deleted: Item "Checksum of $1" on "Template Freeradius".
Deleted: Item "Available memory" on "Template Freeradius".
Deleted: Item "Total memory" on "Template Freeradius".
oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
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]
ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
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]
ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
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]
ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
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]
ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
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]
ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
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]
ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
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]
ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
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]
ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
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]
ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
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]
ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
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]
ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
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]
ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
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]
ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
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]
ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
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]
ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
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]
ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]
oci_execute(): ORA-01002: fetch out of sequence [include/db.inc.php:449]
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]
ocifetchinto(): ORA-01002: fetch out of sequence [include/db.inc.php:582]

But items deleted.



 Comments   
Comment by Alexander Romanov [ 2012 Oct 29 ]

also my frontend db.inc.php patched like ZBX-5691

Comment by Alexander Vladishev [ 2012 Nov 01 ]

Related issue: ZBX-5671

Comment by Toms (Inactive) [ 2012 Nov 16 ]

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

Comment by Eduards Samersovs (Inactive) [ 2012 Nov 19 ]

Tested

Comment by Toms (Inactive) [ 2012 Nov 20 ]

Fixed in 2.0.4rc1 r31511, 2.1.0 r31512

Comment by Oleksii Zagorskyi [ 2015 Sep 15 ]

Looks like similar error has appeared in 2.2.8, see ZBX-9789

Generated at Fri Apr 26 09:37:08 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.