Bug #65912 Lock wait timeout exceeded while failing-over on master-master replication setup
Submitted: 16 Jul 2012 14:52 Modified: 16 Jul 2012 15:42
Reporter: Nipun Marhatha Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server: Locking Severity:S1 (Critical)
Version:5.1.49 OS:Linux
Assigned to: CPU Architecture:Any
Tags: lock, replication

[16 Jul 2012 14:52] Nipun Marhatha
Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'CMS'. Query: 'INSERT INTO TASK_PROFILE (STATUS, CHANNEL_TYPE_ID, SCHEDULE_TIME, MSG_COUNT, CREATED_BY, CREATE_DATE, SCHEDULE_ID, SLOT_ID, START_TIME, END_TIME, PRIORITY_LEVEL, menu_id, retry_plan_id, CAMP_ID,OP_ID,TOTAL_COUNT,PLAN_ID,INTERFACE_ID,CONTENT_TYPE,OA,FILE_COUNT,IS_DELIVERY_RPT_REQ,SMS_COUNT,BINARY_ID,MSG_TEXT,ONLINE,VIDEO,SERVICE_CODE,SPLIT_COUNT,THROTTLING_LIMIT,MSG_DEF_TYPE,QUICKLAUNCH,FTP_FLAG,APPEND_COUNTRY_CODE,LANG_INC,DAILCODE) VALUES(31, 1, STR_TO_DATE('16/7/2012 17:21','%d/%m/%Y %H:%i:%S'), '586979', 200, '2012/07/16 17:21:11', 84583, '0', '17:21:00', '21:00:00', 3, '0', '0' ,121 ,'1' ,'0' ,203 ,'3' ,'0' ,'VL-611112' ,1 ,'0' ,'2' ,'0',null,'0','0','0',1,null,0,1,'F','0','F','1234')'

How to repeat:
- Setup master-master replication
- Run a batch provision of inserts and updates

Suggested fix:
No Idea
[16 Jul 2012 15:42] Valeriy Kravchuk
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.