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

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

            Dates

              Created:
              Updated:
              Resolved: