| 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 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.
Description: 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