Package: mysql-server-core-5.1
Version: 5.1.66-0+squeeze1
File: /usr/sbin/mysqld
Severity: important
*** Please type your report below this line ***
Since last upgrade from 5.1.63 to 5.1.66, after a while, replication on
the slave begins drifting relative to the master position.
A "show processlist" indicates that slave is stuck on an "INSERT IGNORE"
statement. And from that point, replication is frozen and "seconds
behind master" starts to increase more and more.
Here is the output from a "show processlist" on the slave :
*************************** 1. row ***************************
Id: 1
User: system user
Host:
db: NULL
Command: Connect
Time: 60497
State: Waiting for master to send event
Info: NULL
*************************** 2. row ***************************
Id: 2
User: system user
Host:
db: referential
Command: Connect
Time: 36978
State: Sending data
Info: INSERT IGNORE INTO symfony.ebook_author (ebook_id,author_id)
(
SELECT ec.ebook_id as ebook_id, a
*************************** 3. row ***************************
Id: 1536
User: debian-sys-maint
Host: localhost
db: NULL
Command: Query
Time: 0
State: NULL
Info: show processlist
And at the same time, "Seconds_Behind_Master" is 36968.
I tried a rollback to 5.1.63 for the following packages :
libmysqlclient16
mysql-client-5.1
mysql-common
mysql-server-5.1
mysql-server
mysql-server-core-5.1
Replication then just works fine, for as long as I let it run (almost 3
days). Seconds behind master remained all that time 0s.
If I upgrade slave again to last version 5.1.66, even with replication
restarted from scratch on the slave, bug is reproduced (the output
pasted above is from this second try)
Master version is 5.1.66 too.
To reproduce, i guess you can configure a master/slave replication with
5.1.66 on Debian Squeeze servers and try to execute an INSERT IGNORE on
the master which should then freeze replication process on the slave.
-- System Information:
Debian Release: 6.0.6
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.32-5-amd64 (SMP w/24 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages mysql-server-core-5.1 depends on:
ii libc6 2.11.3-4 Embedded GNU C Library:
Shared lib
ii libgcc1 1:4.4.5-8 GCC support library
ii libstdc++6 4.4.5-8 The GNU Standard C++ Library v3
ii libwrap0 7.6.q-19 Wietse Venema's TCP
wrappers libra
ii zlib1g 1:1.2.3.4.dfsg-3 compression library - runtime
mysql-server-core-5.1 recommends no packages.
mysql-server-core-5.1 suggests no packages.
-- no debconf information
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
