-
Incident report
-
Resolution: Unsupported version
-
Critical
-
None
-
2.0.4, 2.0.5, 2.0.6
-
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);
- is duplicated by
-
ZBX-7675 Email notifications sending failed with ORA-01460
-
- Closed
-