[ZBX-14345] Lock wait timeout exceeded; try restarting transaction is not listed as recoverable error Created: 2018 May 11  Updated: 2024 Apr 10  Resolved: 2018 May 23

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Proxy (P), Server (S)
Affects Version/s: 4.0.0alpha6
Fix Version/s: 4.0.0alpha7, 4.0 (plan)

Type: Problem report Priority: Trivial
Reporter: Vladislavs Sokurenko Assignee: Vladislavs Sokurenko
Resolution: Fixed Votes: 0
Labels: lock, mysql
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Team: Team A
Team: Team A
Sprint: Sprint 33, Sprint 34
Story Points: 0.125

 Description   

ER_LOCK_WAIT_TIMEOUT must be added to a list of recoverable errors to avoid possible data loss in case if this error is ever encountered.

Index: src/libs/zbxdb/db.c
===================================================================
--- src/libs/zbxdb/db.c	(revision 80725)
+++ src/libs/zbxdb/db.c	(working copy)
@@ -337,6 +337,7 @@
 		case ER_TABLEACCESS_DENIED_ERROR:	/* user without some privilege */
 		case ER_UNKNOWN_ERROR:
 		case ER_LOCK_DEADLOCK:
+		case ER_LOCK_WAIT_TIMEOUT:
 			return SUCCEED;
 	}


 Comments   
Comment by Vladislavs Sokurenko [ 2018 May 18 ]

Fixed in:

  • 4.0.0alpha7 (trunk)
Generated at Thu Apr 18 11:11:33 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.