Your message dated Wed, 09 Mar 2016 22:02:05 +0000 with message-id <[email protected]> and subject line Bug#811158: Removed package(s) from unstable has caused the Debian Bug report #741266, regarding mysql-server-5.5: MySQL replication breaks after a while (weeks) since security release 5.5.33+dfsg-0+wheezy1 to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 741266: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=741266 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---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.
--- End Message ---
--- Begin Message ---Version: 5.5.46-0+deb8u1+rm Dear submitter, as the package mysql-5.5 has just been removed from the Debian archive unstable we hereby close the associated bug reports. We are sorry that we couldn't deal with your issue properly. For details on the removal, please see https://bugs.debian.org/811158 The version of this package that was in Debian prior to this removal can still be found using http://snapshot.debian.org/. This message was generated automatically; if you believe that there is a problem with it please contact the archive administrators by mailing [email protected]. Debian distribution maintenance software pp. Scott Kitterman (the ftpmaster behind the curtain)
--- End Message ---
