Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-6593

Lots of errors [Z3007] query failed: [-1] ORA-01460: unimplemented or unreasonable conversion requested

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Unsupported version
    • Icon: Critical Critical
    • None
    • 2.0.4, 2.0.5, 2.0.6
    • Server (S)
    • SunOS monit1pre 5.10 Generic_144489-08 i86pc i386 i86pc
      oracle - 10g2

      in zabbix_server.log I have lots of error - [Z3007] query failed: [-1] ORA-01460: unimplemented or unreasonable conversion requested
      First problem is, that I cannot find which query cause this - debug level 4 - We tried all queryes around this error - ad they are work without problem

      part of log:

      16834:20130510:071822.845 End of process_event():SUCCEED
      16834:20130510:071822.845 End of DCmass_update_triggers()
      16834:20130510:071822.845 In DCmass_update_trends()
      16834:20130510:071822.845 In DCflush_trends() trends_num:1
      16834:20130510:071822.845 query [txnlev:1] [begin
      insert into trends_uint (itemid,clock,num,value_min,value_avg,value_max) values (44302,1368165600,1,33844844544,33844844544,33844844544);
      end;]
      16834:20130510:071822.852 End of DCflush_trends()
      16834:20130510:071822.852 End of DCmass_update_trends()
      16834:20130510:071822.854 In DCflush_nextchecks() nextcheck_num:0
      16834:20130510:071822.854 End of DCflush_nextchecks()
      16834:20130510:071822.854 history syncer #1 spent 0.219220 seconds while processing 33 items
      16834:20130510:071822.854 sleeping for 5 seconds
      16837:20130510:071822.889 End of DCmass_update_items()
      16837:20130510:071822.889 In DCmass_add_history()
      16837:20130510:071822.889 In DCget_nextid() table:'history_text' num:4
      16837:20130510:071822.889 End of DCget_nextid() table:'history_text' [16239777:16239780]
      16837:20130510:071822.889 query [txnlev:1] [insert into history_text (id,itemid,clock,value,ns) values (:1,:2,:3,:4,:5)]
      16837:20130510:071822.891 [Z3007] query failed: [-1] ORA-01460: unimplemented or unreasonable conversion requested
      16837:20130510:071822.891 query failed, setting transaction as failed
      16837:20130510:071822.891 zbx_db_statement_execute():-1
      16837:20130510:071822.891 ignoring query [txnlev:1] within failed transaction
      16837:20130510:071822.891 ignoring query [txnlev:1] within failed transaction
      16837:20130510:071822.891 ignoring query [txnlev:1] within failed transaction
      16837:20130510:071822.891 ignoring query [txnlev:1] within failed transaction
      16837:20130510:071822.891 ignoring query [txnlev:1] within failed transaction
      16837:20130510:071822.891 ignoring query [txnlev:1] within failed transaction
      16837:20130510:071822.891 zbx_db_statement_execute():-1
      16837:20130510:071822.891 ignoring query [txnlev:1] within failed transaction
      16837:20130510:071822.891 ignoring query [txnlev:1] within failed transaction
      16837:20130510:071822.891 ignoring query [txnlev:1] within failed transaction
      16837:20130510:071822.891 ignoring query [txnlev:1] within failed transaction
      16837:20130510:071822.891 ignoring query [txnlev:1] within failed transaction
      16837:20130510:071822.891 ignoring query [txnlev:1] within failed transaction
      16837:20130510:071822.891 zbx_db_statement_execute():-1
      16837:20130510:071822.891 ignoring query [txnlev:1] within failed transaction
      16837:20130510:071822.891 ignoring query [txnlev:1] within failed transaction
      16837:20130510:071822.891 ignoring query [txnlev:1] within failed transaction
      16837:20130510:071822.891 ignoring query [txnlev:1] within failed transaction
      16837:20130510:071822.891 ignoring query [txnlev:1] within failed transaction
      16837:20130510:071822.891 ignoring query [txnlev:1] within failed transaction
      16837:20130510:071822.891 zbx_db_statement_execute():-1
      16837:20130510:071822.892 ignoring query [txnlev:1] [begin
      insert into history (itemid,clock,value,ns) values (49518,1368170298,162.000000,287239341);
      insert into history (itemid,clock,value,ns) values (58999,1368170299,99.630764,10600620);
      insert into history (itemid,clock,value,ns) values (35239,1368170299,32.194466,13182927);
      insert into history (itemid,clock,value,ns) values (54859,1368170299,72.821745,14264615);
      insert into history (itemid,clock,value,ns) values (56359,1368170299,7571189760.000000,14626278);
      insert into history (itemid,clock,value,ns) values (58518,1368170299,0.000000,19740829);
      insert into history (itemid,clock,value,ns) values (29539,1368170299,5895155712.000000,20456258);
      insert into history (itemid,clock,value,ns) values (58879,1368170299,55.511743,22181985);

            Unassigned Unassigned
            pkobylan Pavol Kobylan
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: