MySQL Forums
Forum List  »  Replication

Similar problem here, but different symptoms?
Posted by: Solomon Chang
Date: August 26, 2009 08:19PM

I have exactly this problem. The conundrum is, nothing is touching either master or slave.

mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.110.1.11
Master_User: repvanwinkle
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: masprd01.000002
Read_Master_Log_Pos: 4
Relay_Log_File: masprd02.000001
Relay_Log_Pos: 98
Relay_Master_Log_File: masprd01.000001
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 98
Relay_Log_Space: 556
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: 2694
1 row in set (0.06 sec)

The Seconds_Behind_Master keeps falling farther and farther behind. However, nothing is currently in process:

mysql> show full processlist;
+----+--------------+-------------------+------+-------------+------+----------------------------------------------------------------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+--------------+-------------------+------+-------------+------+----------------------------------------------------------------+-----------------------+
| 36 | repvanwinkle | 10.110.1.11:59678 | NULL | Binlog Dump | 792 | Has sent all binlog to slave; waiting for binlog to be updated | NULL |
| 37 | system user | | NULL | Connect | 769 | Waiting for master to send event | NULL |
| 38 | system user | | NULL | Connect | 0 | Reading event from the relay log | NULL |
| 39 | root | localhost | NULL | Query | 0 | NULL | show full processlist |
+----+--------------+-------------------+------+-------------+------+----------------------------------------------------------------+-----------------------+
4 rows in set (0.00 sec)

The thing that really bugs me is, if there's nothing to replicate, why is it falling behind?! I try inserting a simple record on the Master, but it never shows up on the Slave, despite telling me that both IO and SQL threads are totally peachy and the process list is completely clean...

Options: ReplyQuote


Subject
Views
Written By
Posted
7362
August 08, 2009 09:10AM
Similar problem here, but different symptoms?
3476
August 26, 2009 08:19PM


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.