mysql>
mysql> show slave status\G
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
ERROR:
Can't connect to the server
b)
InnoDB: In a MySQL replication slave the last master binlog file
InnoDB: position 79107507, file name mysql-bin.000004
InnoDB: and relay log file
InnoDB: position 21187325, file name ./archie-relay-bin.000004
InnoDB: Last MySQL binlog file position 0 22958867, file name /var/lib/mysql/mysql-bin.000002
As can be seen, the position looks good.
@Nickolay, can you verify the above results? I crashed it twice so as to get more results.
Not seeing the expected result. But logs need to be further verified.
The hosts were prepared as described in the bug report.
Full slave error log is here http:// sprunge. us/RERT (ignore the 1062 error for now)
Few show slave status outputs: http:// sprunge. us/MFNJ
Interesting to note:
a)
show slave status\G ******* ******* ****** 1. row ******* ******* ******* ******
Slave_ IO_State: Queueing master event to the relay log
Master_ Host: Percona
Master_ User: root
Master_ Port: 3306
Connect_ Retry: 60
Master_ Log_File: mysql-bin.000004
Read_ Master_ Log_Pos: 75733104
Relay_ Log_File: archie- relay-bin. 000004
Relay_ Log_Pos: 14733102
Relay_ Master_ Log_File: mysql-bin.000004
Slave_ IO_Running: Yes
Slave_ SQL_Running: Yes
Replicate_ Do_DB:
Replicate_ Ignore_ DB:
Replicate_ Do_Table:
Replicate_ Ignore_ Table: _Wild_Do_ Table: Wild_Ignore_ Table:
Last_ Errno: 0
Last_ Error:
Skip_ Counter: 0
Exec_ Master_ Log_Pos: 72653284
Relay_Log_ Space: 39013793
Until_Condition : None
Until_ Log_File:
Until_ Log_Pos: 0
Master_ SSL_Allowed: No
Master_ SSL_CA_ File:
Master_ SSL_CA_ Path:
Master_ SSL_Cert:
Master_ SSL_Cipher:
Master_ SSL_Key:
Seconds_ Behind_ Master: 1 SSL_Verify_ Server_ Cert: No
Last_ IO_Errno: 0
Last_ IO_Error:
Last_SQL_ Errno: 0
Last_SQL_ Error: Ignore_ Server_ Ids:
Master_ Server_ Id: 392
*******
Replicate
Replicate_
Master_
Replicate_
1 row in set (0.00 sec)
mysql> mysql/mysql. sock' (111)
mysql> show slave status\G
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/
ERROR:
Can't connect to the server
b)
InnoDB: In a MySQL replication slave the last master binlog file relay-bin. 000004 mysql/mysql- bin.000002
InnoDB: position 79107507, file name mysql-bin.000004
InnoDB: and relay log file
InnoDB: position 21187325, file name ./archie-
InnoDB: Last MySQL binlog file position 0 22958867, file name /var/lib/
As can be seen, the position looks good.
@Nickolay, can you verify the above results? I crashed it twice so as to get more results.