Comment 4 for bug 1065841

Revision history for this message
Marcus Bointon (marcus-synchromedia) wrote : Re: Replication breaks with "You cannot 'ALTER' a log table if logging is enabled" on upgrade, even when logging to files

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.