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 26155 Edwin Valencia 03/29/2005 07:27AM
Re: Slave_IO_Running = NO 12420 James Day 03/30/2005 12:32AM
Re: Slave_IO_Running = NO 70821 Edwin Valencia 03/30/2005 06:38AM
Re: Slave_IO_Running = NO 26850 James Day 04/01/2005 01:35AM
Re: Slave_IO_Running = NO 17663 Edwin Valencia 04/01/2005 03:21AM
Re: Slave_IO_Running = NO 14885 James Day 04/01/2005 09:31PM
Re: Slave_IO_Running = NO 20523 Vipul Shukla 04/18/2006 12:07AM
Re: Slave_IO_Running = NO 16889 James Day 04/21/2006 07:18PM
Re: Slave_IO_Running = NO 11914 Vipul Shukla 06/14/2006 03:04PM
Re: Slave_IO_Running = NO 10194 tom smith 01/08/2008 03:50PM
Re: Slave_IO_Running = NO 9829 KimSeong Loh 01/08/2008 04:47PM
Re: Slave_IO_Running = NO 9897 vidal condori 03/08/2008 07:40PM
Re: Slave_IO_Running = NO 9103 KimSeong Loh 03/09/2008 07:59AM
Re: Slave_IO_Running = NO 9034 John Ketchersid 12/15/2008 11:43AM
plzzzzzzz help me (how 2 do replication using mysql and windows) 5058 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.