I'm running replication between two MySQL servers. This has been working
fine for a while; howver, as of yesterday replication keeps failing because
of a lock wait timeout exceeded on one of my tables.
I thought I could use the mysqlbinlog utility to figure out what queries
were being executed before the query causing the lock wait timeout got
executed.. but I apparntly do not understand the output of SHOW SLAVE STATUS
or how to use the utility. How can i use the following output to figure out
what queries were being executed before this error?
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: xxxxxxxx
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: master-bin.000007
Read_Master_Log_Pos: 310823612
Relay_Log_File: repl-relay-bin.000220
Relay_Log_Pos: 8635081
Relay_Master_Log_File: master-bin.000007
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1205
Last_Error: Error 'Lock wait timeout exceeded; try
restarting transaction' on query. Default database: 'aca_ecash'. Query:
'INSERT INTO
trans_item(seq_num,ma_type_seq_num,type_seq_num,company_id,store_id,user_id,drawer_id,hdr_id,ma_type_id,type_id,sub_type_id,hdr_old_status_id,hdr_new_status_id,bus_date,actual_dt,amount,change_due,coupon_id,coupon_amount,co_check_num,payment_method,old_trans_v1_id)
VALUES(fnNextStoreSeqNum(26,10),fnNextMaTypeSeqNum(26,10,1),fnNextItemTypeSeqNum(26,10,1,1),26,10,34,17176,1989028,1,1,0,1,1,'2008-11-14
00:00:00','2008-11-14 22:38:52',400.00,0,0,0,0,0,0)'
Skip_Counter: 0
Exec_Master_Log_Pos: 276329966
Relay_Log_Space: 43128727
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)
Thanks.
--
-----------------------------
Johnny Withers
601.209.4985
[EMAIL PROTECTED]
