Re: Slave_IO_Running = NO

[Edwin Valencia]

Hi...

Thank's for your reply.

- This is in the "SLAVE":

mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: xxx.xxx.xxx.xxx
Master_User: user
Master_Port: 3306
Connect_Retry: 1
Master_Log_File: slave-bin.000001
Read_Master_Log_Pos: 15240949
Relay_Log_File: slave-relay-bin.000005
Relay_Log_Pos: 4
Relay_Master_Log_File: slave-bin.000001
Slave_IO_Running: No
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table: db.r000 db.r001
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 15240949
Relay_Log_Space: 4
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: NULL
1 row in set (0.00 sec)
mysql>

- This is in the "MASTER":

mysql> show master status\G
*************************** 1. row ***************************
File: master-bin.000004
Position: 123676001
Binlog_Do_DB:
Binlog_Ignore_DB:
1 row in set (0.30 sec)

mysql> show master logs;
+----------------------+
| Log_name |
+----------------------+
| master-bin.000001 |
| master-bin.000002 |
| master-bin.000003 |
| master-bin.000004 |
+----------------------+
4 rows in set (0.32 sec)

mysql>


-This is the log file in the "SLAVE"

050327 20:54:51 [ERROR] Error reading packet from server: Client requested master to start replication from impossible position (server_errno=1236)
050327 20:54:51 [ERROR] Got fatal error 1236: 'Client requested master to start replication from impossible position' from master when reading data from binary log
050327 20:54:51 [ERROR] Slave I/O thread exiting, read up to log 'slave-bin.000001', position 15240949

050328 7:49:08 [Note] Slave I/O thread: connected to master '[e-mail]:3306', replication started in log 'slave-bin.000001' at position 15240949
050328 7:49:10 [ERROR] Error reading packet from server: Client requested master to start replication from impossible position (server_errno=1236)
050328 7:49:10 [ERROR] Got fatal error 1236: 'Client requested master to start replication from impossible position' from master when reading data from binary log
050328 7:49:10 [ERROR] Slave I/O thread exiting, read up to log 'slave-bin.000001', position 15240949

050328 14:12:20 [ERROR] Error reading relay log event: slave SQL thread was killed
050328 14:12:23 [Note] Slave SQL thread initialized, starting replication in log 'slave-bin.000001' at position 15240949, relay log './slave-relay-bin.000005' position: 200701871
050328 14:12:24 [Note] Slave I/O thread: connected to master '[e-mail]:3306', replication started in log 'slave-bin.000001' at position 15240949
050328 14:12:26 [ERROR] Error reading packet from server: Client requested master to start replication from impossible position (server_errno=1236)
050328 14:12:26 [ERROR] Got fatal error 1236: 'Client requested master to start replication from impossible position' from master when reading data from binary log
050328 14:12:26 [ERROR] Slave I/O thread exiting, read up to log 'slave-bin.000001', position 15240949

050328 14:12:42 [ERROR] Error reading relay log event: slave SQL thread was killed
050329 9:49:11 [Note] /usr/sbin/mysqld-max: Normal shutdown

050329 9:49:13 InnoDB: Starting shutdown...
050329 9:49:23 InnoDB: Shutdown completed; log sequence number 1 3526396384
050329 9:49:23 [Note] /usr/sbin/mysqld-max: Shutdown complete

050329 09:49:24 mysqld ended

050329 09:49:25 mysqld started
050329 9:49:29 InnoDB: Started; log sequence number 1 3526396384
050329 9:49:29 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run
050329 9:49:29 [Note] Slave SQL thread initialized, starting replication in log 'slave-bin.000001' at position 15240949, relay log './slave-relay-bin.000005' position: 200701871
/usr/sbin/mysqld-max: ready for connections.
Version: '4.1.10-Max-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Max (GPL)

050329 9:49:30 [Note] Slave I/O thread: connected to master '[e-mail]:3306', replication started in log 'slave-bin.000001' at position 15240949
050329 9:49:32 [ERROR] Error reading packet from server: Client requested master to start replication from impossible position (server_errno=1236)
050329 9:49:32 [ERROR] Got fatal error 1236: 'Client requested master to start replication from impossible position' from master when reading data from binary log
050329 9:49:32 [ERROR] Slave I/O thread exiting, read up to log 'slave-bin.000001', position 15240949
--


I don't restart the slave, until that this "the SLAVE" show me the "Slave_IO_Running = NO",
then I do in the "SLAVE" manually :

mysql> slave stop;
mysql> slave start;

And follow show me the "Slave_IO_Running = NO"...


sorry for my bad english.