[ZBX-11584] Only first character saved in data when SELECTing from ntext field Created: 2016 Dec 12  Updated: 2024 Apr 10  Resolved: 2017 May 28

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Proxy (P), Server (S)
Affects Version/s: 3.0.6
Fix Version/s: 2.2.19rc1, 3.0.8rc1, 3.2.4rc1, 3.4.0alpha1

Type: Incident report Priority: Major
Reporter: Andrew Kobelkov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: lld, odbc
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: Text File log-debug-4.txt     PNG File s-1.png     PNG File s-2.png     PNG File s-3.png     PNG File s-4.png    
Issue Links:
Duplicate
is duplicated by ZBX-12048 DB Monitoring result truncated in 2.2.17 Closed
is duplicated by ZBX-11759 MSSQL ODBC monitoring doesn't work af... Closed
Team: Team A
Team: Team A
Sprint: Sprint 8
Story Points: 1

 Description   

Updating to 3.0.6 and having a problem.
The SELECT query return only the first character from ntext field.
isql query is worked as expeced.

 Comments   
Comment by richlv [ 2016 Dec 12 ]

this was sort of supposed to be fixed in 3.0.6 (ZBX-11213)...

Comment by Aleksandrs Saveljevs [ 2016 Dec 13 ]

Could you please post a DebugLevel=4 log that shows pollers processing these ODBC items?

Comment by Andrew Kobelkov [ 2016 Dec 13 ]

Log file for zabbix with debuglevel=4, filtered by odbc was attached

Comment by Aleksandrs Saveljevs [ 2016 Dec 13 ]

Thank you!

Comment by Soem Uesr [ 2016 Dec 22 ]

Have the same issue with version 3.2.2.

Comment by Sergejs Paskevics [ 2017 Jan 02 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-11584 (Tested with MSSQL, MYSQL, PSQL, ORACLE, DB2)

Comment by Sergejs Paskevics [ 2017 Jan 11 ]

Fixed in:

  • pre-3.0.8rc1 r64998,
  • pre-3.2.4rc1 r64999,
  • pre-3.3.0 (trunk) r65000.
Comment by Glebs Ivanovskis (Inactive) [ 2017 May 15 ]

Fix should be backported to 2.2.

Comment by Sergejs Paskevics [ 2017 May 17 ]

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

Comment by Andris Zeila [ 2017 May 22 ]

Successfully tested

Comment by Sergejs Paskevics [ 2017 May 26 ]

Fixed in pre-2.2.19rc1 r68569

Generated at Thu Apr 18 19:14:22 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.