[debian-mysql] Bug#444167: mysql-server-5.0: Binary log for replication fails with event too small message

[Leif]

Package: mysql-server-5.0
Version: 5.0.45-1
Severity: important

We are running two Debian Etch machines as database servers. One is supposed to be a master, 
the other a replicated client. The replication only works for up to a few hours (at most we 
managed 2 so far), then the MySQL slave SQL thread stops with the message:

mysqld[3316]: 070926  8:16:26 [ERROR] Slave: Could not parse relay log event 
entry. The possible reasons are: the master's binary log is corrupted (you 
can check this by running 'mysqlbinlog' on the binary log), the slave's relay 
log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), 
a network problem, or a bug in the master's or slave's MySQL code. If you want 
to check the master's binary log or slave's relay log, you will be able to know 
their names by issuing 'SHOW SLAVE STATUS' on this slave. Error_code: 0

Running mysqlbinlog on the master's binary log then ends with this message:

ERROR: Error in Log_event::read_log_event(): 'Event too small', data_len: 0, event_type: 0
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;

Since this occurs always when starting repliction, we cannot use replication at all.

We have tried this for a couple of months now with various kernels, switched from stable to
unstable, and various libc6 and mysql-server-5.0 releases. We have been using 2.6.18 and
2.6.22-2-amd64 with 4 gb RAM on Intel Core2 Duo 6600 cpus (2.4 ghz).

I'm not sure whether this is a Debian or a MySQL issue, though I'm posting this bug here 
first.

-- System Information:
Debian Release: 4.0
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'stable')
Architecture: i386 (x86_64)

Kernel: Linux 2.6.22-2-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server-5.0 depends on:
ii  adduser                 3.102            Add and remove users and groups
ii  debconf [debconf-2.0]   1.5.11           Debian configuration management sy
ii  libc6                   2.6.1-5          GNU C Library: Shared libraries
ii  libdbi-perl             1.53-1           Perl5 database interface by Tim Bu
ii  libgcc1                 1:4.2-20070528-1 GCC support library
ii  libmysqlclient15off     5.0.45-1         MySQL database client library
ii  libncurses5             5.6+20070716-1   Shared libraries for terminal hand
ii  libreadline5            5.2-2            GNU readline and history libraries
ii  libstdc++6              4.2-20070528-1   The GNU Standard C++ Library v3
ii  libwrap0                7.6.dbs-13       Wietse Venema's TCP wrappers libra
ii  lsb-base                3.1-23.1         Linux Standard Base 3.1 init scrip
ii  mysql-client-5.0        5.0.45-1         MySQL database client binaries
ii  mysql-common            5.0.45-1         MySQL database common files
ii  passwd                  1:4.0.18.1-7     change and administer password and
ii  perl                    5.8.8-7          Larry Wall's Practical Extraction 
ii  psmisc                  22.3-1           Utilities that use the proc filesy
ii  zlib1g                  1:1.2.3.3.dfsg-5 compression library - runtime

Versions of packages mysql-server-5.0 recommends:
pn  mailx                         <none>     (no description available)

-- debconf information:
  mysql-server/root_password: (password omitted)
  mysql-server-5.0/really_downgrade: false
  mysql-server-5.0/need_sarge_compat: false
  mysql-server-5.0/start_on_boot: true
  mysql-server/error_setting_password:
  mysql-server-5.0/nis_warning:
  mysql-server-5.0/postrm_remove_databases: false
  mysql-server-5.0/need_sarge_compat_done: true