ZABBIX BUGS AND ISSUES

Oracle fetch failure

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Trivial Trivial
  • Resolution: Fixed
  • Affects Version/s: None
  • Fix Version/s: 2.0.4rc1, 2.1.0
  • Component/s: None
  • Environment:
    2.0.3 oracle debian 64
  • Zabbix ID:
    RTR

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 - {code}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]
{code}
But items deleted.

Issue Links

Activity

Hide
Alexander Romanov added a comment -

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

Show
Alexander Romanov added a comment - also my frontend db.inc.php patched like ZBX-5691
Hide
Alexander Vladishev added a comment -

Related issue: ZBX-5671

Show
Alexander Vladishev added a comment - Related issue: ZBX-5671
Hide
Toms added a comment -

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

Show
Toms added a comment - Fixed in dev. branch: svn://svn.zabbix.com/branches/dev/ZBX-5759
Hide
Eduards Samersovs added a comment -

Tested

Show
Eduards Samersovs added a comment - Tested
Hide
Toms added a comment -

Fixed in 2.0.4rc1 r31511, 2.1.0 r31512

Show
Toms added a comment - Fixed in 2.0.4rc1 r31511, 2.1.0 r31512

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: