-
Incident report
-
Resolution: Fixed
-
Trivial
-
None
-
zabbix-server 2.2.11
MySQL 5.6
-
Sprint 1
An error occurs if you register over than 65535 characters in the messages column of the action message.
Also, when an error occurs, the action status of the escalations table remains active, and the query is written exclusively to zabbix_server.log.
I updated the status of the escalation to COMPLETED.and now not logging error message.
zabbix_server.log
8704:20161226:174258.442 [Z3005] query failed: [1406] Data too long for column 'message' at row 1 [insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid,sendto,subject,message,status,error,esc_step,alerttype) values (15207076,39,18266071,30,1482741778,1,'root@localhost','[zabbix error message] .....................
When sql_mode is invalidated, no error occurs.
#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES sql_mode='NO_ENGINE_SUBSTITUTION'
- is duplicated by
-
ZBX-11478 Truncate text values correctly before insertion into Oracle database
- Closed