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

    Details

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

        Attachments

          Activity

            People

            • Assignee:
              vso Vladislavs Sokurenko
              Reporter:
              vso Vladislavs Sokurenko
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: