Skip to content
  • Venkatesh Duggirala's avatar
    5b11ccc4
    Bug#17319380 ERROR 1406 (22001): DATA TOO LONG FOR COLUMN · 5b11ccc4
    Venkatesh Duggirala authored
    'PROCESSLIST_STATE' FOR SLAVE SQL
    Problem:
    SQL thread's idle state message (Slave has read all relay
    log; waiting for the slave I/O thread to update it) is 75
    chars length. But performance_schema.threads 
    processlist_state column is defined as char(64). When SQL
    thread is instrumented and 75 chars state message is
    inserted into this varchar(64) column. Server will generate
    either warning/error depends on sql_mode empty or
    'strict_all_tables'.                                        
    Fix: Truncate the state message to 64 chars before inserting
    into the column (No Warning/No error).
    5b11ccc4
    Bug#17319380 ERROR 1406 (22001): DATA TOO LONG FOR COLUMN
    Venkatesh Duggirala authored
    'PROCESSLIST_STATE' FOR SLAVE SQL
    Problem:
    SQL thread's idle state message (Slave has read all relay
    log; waiting for the slave I/O thread to update it) is 75
    chars length. But performance_schema.threads 
    processlist_state column is defined as char(64). When SQL
    thread is instrumented and 75 chars state message is
    inserted into this varchar(64) column. Server will generate
    either warning/error depends on sql_mode empty or
    'strict_all_tables'.                                        
    Fix: Truncate the state message to 64 chars before inserting
    into the column (No Warning/No error).
Loading