>Description:
Replication problem. When I restart my slave server, it is unable to connect
to the master. It says it cannot find the log file on the server. I noticed that it
looks like the log file it's looking for looks correct but it has has a Line-Feed
included in it. I tried fixing the master.info file to remove the line-feed, but it
keeps putting it back in there. The only fix I found was to run this SQL command on
the slave:
CHANGE MASTER TO MASTER_LOG_FILE='server-bin.001';
After running that it works fine, until I restart mysql on the slave again.
>How-To-Repeat:
Set up two master->slave servers and restart mysql on the slave.
>Fix:
Temporary fix: run the SQL command listed above.
>Submitter-Id: <submitter ID>
>Originator: Philip Gatt
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: Replication problem
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.32 (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver 8.14 Distrib 3.23.32, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.32
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 20 min 29 sec
Threads: 1 Questions: 2627 Slow queries: 0 Opens: 60 Flush tables: 1 Open tables:
2 Queries per second avg: 2.138
>Environment:
System: Linux localhost 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.0)
Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium' CXX='egcs'
CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti -mpentium' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 14 Oct 2 13:02 /lib/libc.so.6 ->
libc-2.1.92.so
-rwxr-xr-x 1 root root 4776568 Aug 30 17:56 /lib/libc-2.1.92.so
-rw-r--r-- 1 root root 22607104 Aug 30 17:15 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Aug 30 17:15 /usr/lib/libc.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db
'--with-comment=Official MySQL RPM'
---------------------------------------------------------------------
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
