On the server itself this worked perfectly, however on the slave (it's a master-master mmm config), it stops replication with this error:
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'
Logging is not using tables on either server, and never has.
I told the slave to skip that statement and continue, and all worked again.
When I upgraded the other master, I had exactly the same problem in the opposite direction.
Well it's hapened again...
I did this upgrade:
replace percona- server- server 5.5.27- rel29.0- 315.lucid (using .../percona- server- server_ 5.5.28- rel29.1- 334.lucid_ am
d64.deb)
On the server itself this worked perfectly, however on the slave (it's a master-master mmm config), it stops replication with this error:
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'
Logging is not using tables on either server, and never has.
I told the slave to skip that statement and continue, and all worked again.
When I upgraded the other master, I had exactly the same problem in the opposite direction.