>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