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

Duplicate task insertion rarely happens with escalator.

    XMLWordPrintable

    Details

    • Team:
      Team A
    • Sprint:
      Sprint 70 (Nov 2020)
    • Story Points:
      0.5

      Description

      There are duplicates inserts into the tasks table by escalator processes in the log:

       28756:20200825:120641.310 [Z3005] query failed: [1062] Duplicate entry '20677076' for key 'PRIMARY' [insert into task (taskid,type,status,clock,ttl,proxy_hostid) values (20677076,2,1,1598328397,600,10275);
       28752:20200825:120641.546 [Z3005] query failed: [1062] Duplicate entry '20677076' for key 'PRIMARY' [insert into task (taskid,type,status,clock,ttl,proxy_hostid) values (20677076,2,1,1598328396,600,10275);
       28754:20200825:120653.814 [Z3005] query failed: [1062] Duplicate entry '20677213' for key 'PRIMARY' [insert into task (taskid,type,status,clock,ttl,proxy_hostid) values (20677213,2,1,1598328408,600,10275);
       28750:20200825:120653.817 [Z3005] query failed: [1062] Duplicate entry '20677213' for key 'PRIMARY' [insert into task (taskid,type,status,clock,ttl,proxy_hostid) values (20677213,2,1,1598328413,600,10275);
       28752:20200825:120701.361 [Z3005] query failed: [1062] Duplicate entry '20677313' for key 'PRIMARY' [insert into task (taskid,type,status,clock,ttl,proxy_hostid) values (20677313,2,1,1598328413,600,10275);
       28754:20200825:120706.814 [Z3005] query failed: [1062] Duplicate entry '20677368' for key 'PRIMARY' [insert into task (taskid,type,status,clock,ttl,proxy_hostid) values (20677368,2,1,1598328421,600,10275);
       28752:20200825:120706.816 [Z3005] query failed: [1062] Duplicate entry '20677368' for key 'PRIMARY' [insert into task (taskid,type,status,clock,ttl,proxy_hostid) values (20677368,2,1,1598328422,600,10275);
       28754:20200825:120712.839 [Z3005] query failed: [1062] Duplicate entry '20677413' for key 'PRIMARY' [insert into task (taskid,type,status,clock,ttl,proxy_hostid) values (20677413,2,1,1598328431,600,10275);
      

        Attachments

          Activity

            People

            Assignee:
            wiper Andris Zeila
            Reporter:
            neogan Andrei Gushchin
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: