Percona Server moved to https://jira.percona.com/projects/PS

  1. Series 5.5
  2. Bug #1065841
  3. Comment #5

Comment 5 for bug 1065841

Revision history for this message
Miguel Angel Nieto (miguelangelnieto) wrote : Re: Replication breaks with "You cannot 'ALTER' a log table if logging is enabled" on upgrade, even when logging to files

I've tested the bug on the following environment (Debian Squeeze):

Master PS 5.5.27 (binlog and slowlog enabled)
Slave PS 5.5.7 (binlog and slowlog enabled)

After upgrading the master to 5.5.28 I get the following error on the slave status:

               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'

So confirmed, it breaks the replication.