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

Possible deadlock on ids table on "housekeeper" row

    XMLWordPrintable

    Details

      Description

      It can happen because Zabbix frontend and server can use the same table row for updating at the same time:

      31628:20141020:094957.796 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update ids set nextid=nextid+14 where nodeid=0 and table_name='housekeeper' and field_name='housekeeperid']
      zabbix_server [31628]: ERROR [file:db.c,line:999] Something impossible has just happened.
      
       31616:20141020:094930.468 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update ids set nextid=nextid+14 where nodeid=0 and table_name='housekeeper' and field_name='housekeeperid']
      zabbix_server [31616]: ERROR [file:db.c,line:999] Something impossible has just happened.
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            dotneft Alexey Pustovalov
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: