Your message dated Wed, 09 Mar 2016 22:02:05 +0000
with message-id <e1admbb-0003tc...@franck.debian.org>
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 ow...@bugs.debian.org
immediately.)
--
741266: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=741266
Debian Bug Tracking System
Contact ow...@bugs.debian.org 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
ftpmas...@ftp-master.debian.org.
Debian distribution maintenance software
pp.
Scott Kitterman (the ftpmaster behind the curtain)
--- End Message ---