>Description:
Replication cannot be started
>How-To-Repeat:
Following the set up instructions in section 4.10 "Replication in
MySQL" of the MySQL documentation
>Fix:
Not known
>Submitter-Id:
>Originator: B.L. Choy
>Organization:
>MySQL support: none
>Synopsis:
Related messages in hermes1.err file (master - 192.168.60.1):
Nil
Grand tables on hermes1 (master - 192.168.60.1):
--
-- Dumping data for table 'user'
--
INSERT INTO user VALUES
('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user VALUES
('hermes1','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user VALUES
('localhost','','','N','N','N','N','N','N','N','N','N','N','N','N','N','N');
INSERT INTO user VALUES
('hermes1','','','N','N','N','N','N','N','N','N','N','N','N','N','N','N');
INSERT INTO user VALUES
('192.168.60.2','repl','','N','N','N','N','N','N','N','N','N','Y','N','N','N','N');
Related messages in hermes2.err file (slave - 192.168.60.2):
020821 17:34:47 Slave: connected to master
'[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 32
020821 17:34:47 Slave: received 0 length packet from server,
apparent master shutdown:
020821 17:34:47 Slave: Failed reading log event, reconnecting
to retry, log 'FIRST' position 32
020821 17:34:47 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 32
020821 17:34:47 Slave: received 0 length packet from server,
apparent master shutdown:
...last 3 lines repeats...
Related messages using 'mysqladmin processlist' command:
+----+-------------+-----------+----+---------+------+------------------------------------------+------------------+
| Id | User | Host | db | Command | Time |
State | Info |
+----+-------------+-----------+----+---------+------+------------------------------------------+------------------+
| 1 | system user | none | | Connect | 10 | Waiting
to reconnect after a failed read | |
| 3 | root | localhost | | Query |
0 | | show processlist |
+----+-------------+-----------+----+---------+------+------------------------------------------+------------------+
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.52 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.52, 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.52-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysql/mysql.sock
Uptime: 3 min 38 sec
Threads: 1 Questions: 10 Slow queries: 0 Opens: 6 Flush tables: 1 Open
tables: 0 Queries per second avg: 0.046
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux hermes2 2.4.18 #1 SMP Mon Jul 8 15:30:39 HKT 2002 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-slackware-linux/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc' CFLAGS='-O3
-march=i486' CXX='gcc' CXXFLAGS='-O3 -march=i486 -felide-constructors
-fno-except
ions -fno-rtti' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Jul 8 19:21 /lib/libc.so.6 ->
libc-2.2.5.so
-rwxr-xr-x 1 root root 5029105 May 18 11:54 /lib/libc-2.2.5.so
-rw-r--r-- 1 root root 24991240 May 18 11:53 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 May 18 11:53 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --with-mysqld-user=mysql
--with-unix-socket-path=/var/run/mysql/mysql.sock --l
ocalstatedir=/var/lib/mysql --with-pthread --enable-thread-safe-client
--enable-assembler --with-raid --with-libwrap --with
out-bench '--with-mysqld-ldflags=-all-static
-L/tmp/glibc-2.2.5/linuxthreads' --with-charset=latin1 --with-extra-charset=bi
g5,gb2312 --with-berkeley-db --with-innobase 'CFLAGS=-O3 -march=i486'
'CXXFLAGS=-O3 -march=i486 -felide-constructors -fno-e
xceptions -fno-rtti' CXX=gcc
---------------------------------------------------------------------
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
