zabbix_server.log
|
Duplicate |
|||
| duplicates |
|
Lots of errors [Z3007] query failed: ... | Closed |
[ZBX-7675] Email notifications sending failed with ORA-01460 Created: 2014 Jan 20 Updated: 2017 May 30 Resolved: 2014 Jan 20 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Server (S) |
| Affects Version/s: | 2.2.1 |
| Fix Version/s: | None |
| Type: | Incident report | Priority: | Major |
| Reporter: | N.Vazhenin | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | oracle | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Solaris 10 x64, Oracle Server 10.2.0.5 64bit |
||
| Attachments: |
zabbix_server.log
|
||||||||
| Issue Links: |
|
||||||||
| Description |
|
Zabbix 2.2.1 cant send email notices when compiled and running with Oracle 10.2 database. This caused by "ORA-01460: unimplemented or unreasonable conversion requested" error while inserting alert information into ALERTS table: 11516:20140120:112322.690 query [txnlev:1] [insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid,sendto,subject,message,status,esc_step,alerttype) values (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12)] 11516:20140120:112322.691 [Z3007] query failed: [-1] ORA-01460: unimplemented or unreasonable conversion requested More debug data in attached zabbix_server.log This is the only one inserting error. All other inserts into other tables are fine. |
| Comments |
| Comment by Alexander Vladishev [ 2014 Jan 20 ] |
|
It's duplicate of |
