[debian-mysql] Bug#736777: mysql-server-5.5 upgrade breaks replication: Error 'You cannot 'ALTER' a log table if logging

Jinn Ko debianbugs at mx.ixydo.org
Sun Jan 26 18:53:44 UTC 2014

Package: mysql-server-5.5
Version: 5.5.35+dfsg-0+wheezy1
Severity: important
Tags: d-i

Dear Maintainer,

Upgrading from mysql-server-5.5.33+dfsg-0+wheezy1 to mysql-server_5.5.35+dfsg-0+wheezy1 cause replication to fail with the following error:

    Last_Errno: 1580
    Last_Error: Error 'You cannot 'ALTER' a log table if logging is enabled' on query. Default database: 'mysql'. Query:   MODIFY start_time TIMESTAMP NOT NULL,...

Percona[1] and MariaDB[2] have the same issue open and have identified that the issue is caused by the lack of of the --skip-write-binlog arg to the mysql_upgrade command[3].

As stated in the linked bug reports, the workaround is to issue the following commands in MySQL:


Having to issue this workaround is not desirable in a production environment when applying minor-point upgrades.  The upgrade scripting should be handling this for us.

[1] https://bugs.launchpad.net/percona-server/+bug/1065841
[2] https://mariadb.atlassian.net/browse/MDEV-5116
[3] https://bugs.launchpad.net/percona-server/+bug/1065841/comments/11

-- System Information:
Debian Release: 7.3
  APT prefers stable
  APT policy: (950, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 3.2.0-4-amd64 (SMP w/8 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=C (charmap=UTF-8) (ignored: LC_ALL set to en_US.UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages mysql-server-5.5 depends on:
ii  adduser                3.113+nmu3
ii  debconf [debconf-2.0]  1.5.49
ii  initscripts            2.88dsf-41+deb7u1
ii  libc6                  2.13-38
ii  libdbi-perl            1.622-1
ii  libgcc1                1:4.7.2-5
ii  libstdc++6             4.7.2-5
ii  lsb-base               4.1+Debian8+deb7u1
ii  mysql-client-5.5       5.5.35+dfsg-0+wheezy1
ii  mysql-common           5.5.35+dfsg-0+wheezy1
ii  mysql-server-core-5.5  5.5.35+dfsg-0+wheezy1
ii  passwd                 1:
ii  perl                   5.14.2-21+deb7u1
ii  psmisc                 22.19-1+deb7u1
ii  zlib1g                 1:1.2.7.dfsg-13

Versions of packages mysql-server-5.5 recommends:
ii  heirloom-mailx [mailx]  12.5-2
ii  libhtml-template-perl   2.91-1

Versions of packages mysql-server-5.5 suggests:
pn  tinyca  <none>

-- debconf information:
  mysql-server-5.5/postrm_remove_databases: false
  mysql-server-5.5/start_on_boot: true
  mysql-server-5.5/really_downgrade: false

More information about the pkg-mysql-maint mailing list