Skip navigation links

MySQL Forums :: Replication :: Slave_IO_Running = NO


Advanced Search

Re: Slave_IO_Running = NO
Posted by: Edwin Valencia ()
Date: March 30, 2005 06:38AM

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 'user@xxx.xxx.xxx.xxx: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 'user@xxx.xxx.xxx.xxx: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 'user@xxx.xxx.xxx.xxx: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.

Options: ReplyQuote


Subject Views Written By Posted
Slave_IO_Running = NO 26776 Edwin Valencia 03/29/2005 07:27AM
Re: Slave_IO_Running = NO 12658 James Day 03/30/2005 12:32AM
Re: Slave_IO_Running = NO 73219 Edwin Valencia 03/30/2005 06:38AM
Re: Slave_IO_Running = NO 27420 James Day 04/01/2005 01:35AM
Re: Slave_IO_Running = NO 17995 Edwin Valencia 04/01/2005 03:21AM
Re: Slave_IO_Running = NO 15120 James Day 04/01/2005 09:31PM
Re: Slave_IO_Running = NO 21249 Vipul Shukla 04/18/2006 12:07AM
Re: Slave_IO_Running = NO 17302 James Day 04/21/2006 07:18PM
Re: Slave_IO_Running = NO 12138 Vipul Shukla 06/14/2006 03:04PM
Re: Slave_IO_Running = NO 10394 tom smith 01/08/2008 03:50PM
Re: Slave_IO_Running = NO 10004 KimSeong Loh 01/08/2008 04:47PM
Re: Slave_IO_Running = NO 10109 vidal condori 03/08/2008 07:40PM
Re: Slave_IO_Running = NO 9264 KimSeong Loh 03/09/2008 07:59AM
Re: Slave_IO_Running = NO 9365 John Ketchersid 12/15/2008 11:43AM
plzzzzzzz help me (how 2 do replication using mysql and windows) 5167 daisy m 12/18/2008 01:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.