Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-14345

Lock wait timeout exceeded; try restarting transaction is not listed as recoverable error

XMLWordPrintable

    • Team A
    • Sprint 33, Sprint 34
    • 0.125

      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;
       	}
      

            vso Vladislavs Sokurenko
            vso Vladislavs Sokurenko
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: