-
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).
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