>Description:
Replication master info seems to get corrupted when the database is restarted
after a shutdown
master.info after shutdown
--------------------
master-bin.001
25699
master
username
password
3306
60
--------------------
master.info after startup - note the blank line
--------------------
master-bin.001
25699
master
username
password
3306
60
--------------------
slave my.cnf
[mysqld]
master-host=master
master-user=username
master-password=password
replicate-do-db=testdb
server-id=16
master my.cnf
[mysqld]
log-bin
server-id=8
binlog-do-db=testdb
hopefully I'm not doing something wrong :)
>How-To-Repeat:
shutdown database - start database - check var/slave.err and it says
010206 10:10:02 Slave: reconnected to master 'username@master:3306',replication
resumed in log 'master-bin.001
' at position 0
010206 10:10:02 Error reading packet from server: Could not find first log
(read_errno 0,server_errno=65535)
there is a new line after 'master-bin.001 but before the closing '
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Michael Dean
>Organization:
>MySQL support: none
>Synopsis: Replication info in master.info corrupted in database startup
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.32 (Source distribution)
>Server: /usr/local/bin/mysqladmin Ver 8.14 Distrib 3.23.32, for sun-solaris2.6 on
>sparc
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 /tmp/mysql.sock
Uptime: 8 hours 33 min 56 sec
Threads: 2 Questions: 62 Slow queries: 0 Opens: 26 Flush tables: 1 Open tables:
20 Queries per second avg: 0.002
>Environment:
System: SunOS pegasus 5.6 Generic_105181-15 sun4m sparc SUNW,SPARCstation-10
Architecture: sun4
Some paths: /usr/local/bin/perl /usr/ccs/bin/make /usr/local/bin/gmake
/usr/local/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.7.2.3/specs
gcc version 2.7.2.3
Compilation info: CC='gcc' CFLAGS='-O6' CXX='gcc' CXXFLAGS='-O6
-felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
-rw-r--r-- 1 bin bin 1607628 Jun 28 1999 /lib/libc.a
lrwxrwxrwx 1 root root 11 Jun 10 1995 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 bin bin 1014020 Jun 28 1999 /lib/libc.so.1
-rw-r--r-- 1 bin bin 1607628 Jun 28 1999 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Jun 10 1995 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 bin bin 1014020 Jun 28 1999 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/web/server/mysql --with-low-memory
--enable-assembler
Perl: This is perl, version 5.004_04 built for sun4-solaris
---------------------------------------------------------------------
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
