MySQL Forums
Forum List  »  Replication

Replication hangs
Posted by: Martijn Meijers
Date: May 26, 2014 01:23AM

I'm running mysql 5.5.19 master and a mysql 5.5.30 slave. The slave SQL process hangs without any messages in the error log or in the status information:

mysql> show slave status \G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: master
Master_User: replication
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: binlog_lba-dbp2.007186
Read_Master_Log_Pos: 3303909
Relay_Log_File: lba-dbp1-relay-bin.000084
Relay_Log_Pos: 746
Relay_Master_Log_File: binlog_lba-dbp2.007136
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: 594
Relay_Log_Space: 11168469215
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: 183524
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 54
1 row in set (0.00 sec)

ERROR:
No query specified

When I check the relay file I see something strange:

/*!*/;
# at 746
#140524 5:41:01 server id 54 end_log_pos 690 Query thread_id=280721 exec_time=17 error_code=0
SET TIMESTAMP=1400902861/*!*/;
BEGIN
/*!*/;
# at 842
# at 1266
.
.
.
# at 373306612
# at 373307932
#140524 5:41:01 server id 54 end_log_pos 1114 Table_map: `lbaProd_HollandRijnland`.`t_proces_ug140090260610200300` mapped to number 81112
#140524 5:41:01 server id 54 end_log_pos 2458 Update_rows: table id 81112
#140524 5:41:01 server id 54 end_log_pos 3836 Update_rows: table id 81112
.
.
.

There are 250000 at <id> statements followed by 250000 Update_rows: table id 811112 statements.

The processlist shows that it's reading events from the relay log:
| 11 | system user | | NULL | Connect | 310740 | Waiting for master to send event | NULL |
| 12 | system user | | NULL | Connect | 186000 | Reading event from the relay log | NULL


Is this a problem with a large transaction or a bug? Does anyone know a solution for this?

Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication hangs
2129
May 26, 2014 01:23AM
950
May 26, 2014 09:23PM
994
May 27, 2014 12:53AM


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.