It is amazing to see on monitoring as first thing in the morning error 1580 on all 5.5 replicas… 🙂
in “show slave status\G” you can see:
Last_SQL_Errno: 1580 Last_SQL_Error: Error 'You cannot 'ALTER' a log table if logging is enabled' on query. Default database: 'mysql'. Query: 'ALTER TABLE slow_log MODIFY start_time TIMESTAMP NOT NULL, MODIFY user_host MEDIUMTEXT NOT NULL, MODIFY query_time TIME NOT NULL, MODIFY lock_time TIME NOT NULL, MODIFY rows_sent INTEGER NOT NULL, MODIFY rows_examined INTEGER NOT NULL, MODIFY db VARCHAR(512) NOT NULL, MODIFY last_insert_id INTEGER NOT NULL, MODIFY insert_id INTEGER NOT NULL, MODIFY server_id INTEGER UNSIGNED NOT NULL, MODIFY sql_text MEDIUMTEXT NOT NULL'
you have run this sequence of commands on every replica:STOP SLAVE; SET GLOBAL slow_query_log = "OFF"; START SLAVE; SET GLOBAL slow_query_log = "ON";
Binlog showed that 5.5 master recreated all internal tables like performance_schema, all log tables etc. because update of MySQL (5.5.58) was installed. And since we replicate all databases to avoid problems with cross database references we got this fun…