>Description:
I am unable to get replication running. I have set up both master and slave
systems with version 3.23.33-log of musql. I can do a "load table from
master" but when I start the slave, all I get in the slave log is:
010410 16:37:24 Slave: Failed reading log event, reconnecting to retry, log 'FIRST'
position 4
010410 16:37:24 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4
010410 16:37:24 Error reading packet from server: Binlog has bad magic number, fire
your magician (read_errno 0,server_errno=65535)
and in the master log:
010410 16:35:58 3006 Connect [EMAIL PROTECTED] on
3007 Connect [EMAIL PROTECTED] on
3007 Quit
3006 Binlog Dum
>How-To-Repeat:
see below
>Fix:
This problem occurs when the my.cnf file on the master contains
"log-bin=/var/log/replication.log"
but just
"log-bin"
seems to work.
However, how do you control the location and name of the log?
(This may just be a documentation issue, but the error message is not very intuitive.)
>Submitter-Id: <submitter ID>
>Originator: Jim Ziegler
>Organization:
[EMAIL PROTECTED] (Jim Ziegler)
>
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: replication-bad magic number-fire your magician
>Severity: critical
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.36 (Source distribution)
>Environment:
System: Linux jimz 2.2.19 #1 Sun Jun 24 15:06:27 EST 2001 i586 unknown
Architecture: i586
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 20010319 (Debian prerelease)
Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g' CXX='g++'
CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 14 Mar 28 11:57 /lib/libc.so.5 ->
libc.so.5.4.46
-rw-r--r-- 1 root root 589460 Mar 19 08:47 /lib/libc.so.5.4.46
lrwxrwxrwx 1 root root 13 Jun 11 13:04 /lib/libc.so.6 -> libc-2.2.3.so
-rwxr-xr-x 1 root root 1104456 May 28 18:49 /lib/libc-2.2.3.so
-rw-r--r-- 1 root root 2522408 May 28 18:51 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 May 28 18:51 /usr/lib/libc.so
lrwxrwxrwx 1 root root 10 Nov 15 2000 /usr/lib/libc-client.a ->
c-client.a
lrwxrwxrwx 1 root root 18 Nov 15 2000 /usr/lib/libc-client.so ->
libc-client.so.4.7
-rw-r--r-- 1 root root 665260 Sep 1 2000 /usr/lib/libc-client.so.4.7
Configure command: ./configure --prefix=/usr --exec-prefix=/usr
--libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql
--localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info
--mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler
--with-berkeley-db --with-innobase --enable-static --enable-shared --with-raid
--without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock
--with-mysqld-user=mysql --without-bench --with-extra-charsets=all
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
