Internal documentation only

This page has been marked as draft.

Data too long for column 'X'

Problem Copied

SNMP traps intermittently fail to be inserted into the Opsview database with the error:

 ERROR 1406 (22001): Data too long for column 'X'

Problem Copied

The data is to long, exceeding the defined database table column length and therefore causes the database insert to fail. This also leads to the trap not being correctly processed and not assigned to the host.

Possible cause(s) Copied

This behaviour may be triggered by the following:

• Vendor-specific or non-standard SNMP traps
• Missing or malformed address information
• Unexpected ordering or structure of SNMP trap contents
• Traps that do not match any configured host in the monitoring system

Possible solution(s) Copied

• Review the snmp data being sent by capturing raw traps using the debug stdin2sock to identify problematic information