[debian-mysql] Bug#741266: mysql-server-5.5: MySQL replication breaks after a while (weeks) since security release 5.5.33+dfsg-0+wheezy1

[Jens Arnold]

Package: mysql-server-5.5
Version: 5.5.35+dfsg-0+wheezy1
Severity: normal

Dear Maintainer,

We're running MySQL replication between two equal boxes (hardware and software wise). On our old
hardware with Debian squeeze this has been working stable for about two years, after which we replaced
the boxes and upgraded to Debian wheezy in November 2013.

After configuring this on the new boxes it worked without problems for the first two months. On 2014-01-02
we installed the update to 5.5.33+dfsg-0+wheezy1. On 2014-02-10 we experienced the first breakage.
Replication stopped working with the following error (output of sql statement "SHOW SLAVE STATUS;"):

               Slave_IO_State: Waiting for master to send event
                  Master_Host: szshdb01.vmsd.de
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: szshdb01-bin.000782
          Read_Master_Log_Pos: 48329513
               Relay_Log_File: szshdb02-relay.002322
                Relay_Log_Pos: 48244712
        Relay_Master_Log_File: szshdb01-bin.000782
             Slave_IO_Running: Yes
            Slave_SQL_Running: No
              Replicate_Do_DB: 
          Replicate_Ignore_DB: 
           Replicate_Do_Table: 
       Replicate_Ignore_Table: 
      Replicate_Wild_Do_Table: 
  Replicate_Wild_Ignore_Table: 
                   Last_Errno: 1677
                   Last_Error: Column 5 of table 'ymulu_vmsd.nokatalog' cannot be converted from type 'decimal(0,?)' to type 'decimal(7,2)'
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 48244563
              Relay_Log_Space: 48329863
              Until_Condition: None
               Until_Log_File: 
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File: 
           Master_SSL_CA_Path: 
              Master_SSL_Cert: 
            Master_SSL_Cipher: 
               Master_SSL_Key: 
        Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error: 
               Last_SQL_Errno: 1677
               Last_SQL_Error: Column 5 of table 'ymulu_vmsd.nokatalog' cannot be converted from type 'decimal(0,?)' to type 'decimal(7,2)'
  Replicate_Ignore_Server_Ids: 
             Master_Server_Id: 10


On 2014-02-13 I installed the upgrade to 5.5.35+dfsg-0+wheezy1 and repaired replication by setting it up again
from scratch. Less than three weeks later (2014-03-05) the problem reappeared - in exactly the same table.

Checking the binlog on the master with "mysqlbinlog -v -v" shows that the problem is apparently caused
when the binlog is written. This points towards upstream bug #65551 (http://bugs.mysql.com/bug.php?id=65551).
It is marked as fixed upstream in 5.7.0 but I cannot check the details because their code browser times out.


-- System Information:
Debian Release: 7.4
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 3.2.0-4-amd64 (SMP w/16 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=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+deb7u1
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:4.1.5.1-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  bsd-mailx [mailx]      8.1.2-0.20111106cvs-1
ii  libhtml-template-perl  2.91-1

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

-- debconf information:
* mysql-server/root_password_again: (password omitted)
* mysql-server/root_password: (password omitted)
  mysql-server/error_setting_password:
  mysql-server-5.5/postrm_remove_databases: false
  mysql-server-5.5/start_on_boot: true
  mysql-server-5.5/nis_warning:
  mysql-server-5.5/really_downgrade: false
  mysql-server/password_mismatch:
  mysql-server/no_upgrade_when_using_ndb:

Diese elektronische Nachricht ist vertraulich. Die Information ist 
nur fuer den Adressaten bestimmt. Falls Sie nicht der Adressat 
sind, informieren Sie bitte sofort den Absender und vernichten 
Sie diese E-Mail sowie alle Kopien und angeschlossenen 
Anlagen. Bitte beachten Sie, dass es in diesem Fall verboten und 
gesetzeswidrig ist, diese Nachricht zu kopieren, weiterzuleiten 
oder zu benutzen. Es wurden alle moeglichen Massnahmen 
getroffen um eine Virusfreiheit der beigefuegten Dateien zu 
gewaehrleisten. Wir uebernehmen jedoch keine Verantwortung
fuer Schaeden, die aufgrund von Software-Viren entstehen und 
empfehlen Ihnen vor Benutzung der Dateien eine Ueberpruefung 
auf Viren durchzufuehren.

This electronic message contains information that is confidential. 
The information is intended for the use of the addressee only. If 
you are not the addressee please inform the sender immediately 
and delete this e-mail, its attachments and any copies. Please 
note that any disclosure, copy, distribution or use of the contents 
of this message is prohibited and may be unlawful. We have 
taken every reasonable precaution to ensure that any kind of 
attachment to this e-mail has been swept for viruses.
However, we cannot accept liability for any damage sustained as 
a result of software viruses and would advise you to carry out your 
own virus checks before opening any attachment.