[ZBX-8072] IBM DB2 ERROR: "Value is too long" (Windows event log). Created: 2014 Apr 11  Updated: 2017 May 30  Resolved: 2014 Oct 17

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 2.2.6
Fix Version/s: 2.2.7rc1, 2.4.2rc1, 2.5.0

Type: Incident report Priority: Major
Reporter: Oleg Ivanivskyi Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: db2, eventlog
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

SLES 11 SP3, DB2 10.5, zabbix 2.2.2 and 2.0.5

Issue Links:
Duplicate

 Description   

Zabbix with IBM DB2 doesn't correctly handle a long text from Windows event log.
Data type(length) "varchar(2048)" for "value" column in the history_log table causes errors like this:
2877:20140409:140311.492 IBM DB2 ERROR: [-433] 22001 [[IBM][CLI Driver][DB2/LINUX] SQL0433N Value "NOTE: Escalation cancelled: item 'Windows Application Log' d" is too long. SQLSTATE=22001]

 Comments   
Comment by Alexander Vladishev [ 2014 Apr 11 ]

It is a duplicate of ZBX-7151. I close the issue.

Comment by Aleksandrs Saveljevs [ 2014 Jun 10 ]

ZBX-8328 is related, but the reason is different.

Comment by Andris Zeila [ 2014 Oct 10 ]

It should work in 2.0 branch, but in 2.2 the database inserts were reworked and ZBX_TYPE_TEXT type fields are not truncated to 2KB on DB2.

Comment by Andris Zeila [ 2014 Oct 10 ]

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

Comment by Alexander Vladishev [ 2014 Oct 14 ]

Successfully tested! Please review my changes in r49868.

wiper reviewed, thanks

Comment by Andris Zeila [ 2014 Oct 15 ]

Released in:

  • pre-2.2.7rc1 r49880
  • pre-2.4.2rc1 r49881
  • pre-2.5.0 r49882
Comment by richlv [ 2014 Oct 17 ]

(1) changelog message appears both in 2.5 and 2.4 sections - i believe it should not be listed in the 2.5 section

sasha RESOLVED in r49981.

CLOSED

Generated at Thu Apr 25 17:22:35 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.