[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: |
|
Description |
I cloned Template OS Linux (little bit custom version) to Template Freeradius, then i deleted almost all triggers. That was ok. 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 |
Comment by Alexander Vladishev [ 2012 Nov 01 ] |
Related issue: |
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 |