MySQL Forums
Forum List  »  Replication

I/O slave never updates
Posted by: John Zastrow
Date: October 14, 2004 07:44AM

This setup was running happily for months. Then I did an apt-get on debian and it upgraded mysql and overwrote my my.cnf. By the time I realized what was happening the slave had not been replicating for some time. I repaired the my.cnf on the master.

Now I can login into the master (master running 4.0.21 on debian) as the slave repl user just fine, and the slave (slave running 4.0.20 on mandrake) issues the status results below. Slave SQL and Slave I/O appear to be running fine without errors. But, the databases are not synced. WTF?

mysql> show processlist \G
*************************** 1. row ***************************
Id: 1
User: system user
Host:
db: NULL
Command: Connect
Time: 80786
State: Connecting to master
Info: NULL
*************************** 2. row ***************************
Id: 2
User: system user
Host:
db: NULL
Command: Connect
Time: 80786
State: Has read all relay log; waiting for the I/O slave thread to update it
Info: NULL
*************************** 3. row ***************************
Id: 12
User: jcz
Host: localhost
db: NULL
Command: Query
Time: 0
State: NULL
Info: show processlist
3 rows in set (0.00 sec)

mysql> show slave status \G
*************************** 1. row ***************************
Master_Host: slave.here.com
Master_User: repl
Master_Port: 3306
Connect_retry: 60
Master_Log_File: mysql-bin.037
Read_Master_Log_Pos: 21295
Relay_Log_File: slave-relay-bin.010
Relay_Log_Pos: 4
Relay_Master_Log_File: mysql-bin.037
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_do_db:
Replicate_ignore_db:
Last_errno: 0
Last_error:
Skip_counter: 0
Exec_master_log_pos: 21295
Relay_log_space: 4
1 row in set (0.00 sec)

mysql>

Options: ReplyQuote


Subject
Views
Written By
Posted
I/O slave never updates
4028
October 14, 2004 07:44AM
2715
December 07, 2004 09:05AM


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.