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

ERROR [file:db.c,line:1582] Something impossible has just happened

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Critical
    • Resolution: Won't fix
    • 1.8.11
    • None
    • Server (S)
    • None
    • SLES 11SP1

    Description

      Received hundreds of notifications that hosts did not receive any data in the last xx seconds (trigger using nodata, therefore evaluated on the server side).

      Had a quick look at zabbix-server.log and noticed the following error logs:
      [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+42 where nodeid=1 and table_name='events' and field_name='eventid']

      20468:20120416:000132.902 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+42 where nodeid=1 and table_name='events' and field_name='eventid']
      zabbix-server [20468]: ERROR file:db.c,line:1582 Something impossible has just happened.
      20471:20120416:000134.761 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+19 where nodeid=1 and table_name='events' and field_name='eventid']
      zabbix-server [20471]: ERROR file:db.c,line:1582 Something impossible has just happened.
      20463:20120416:000139.912 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+8 where nodeid=1 and table_name='events' and field_name='eventid']
      zabbix-server [20463]: ERROR file:db.c,line:1582 Something impossible has just happened.
      20461:20120416:000139.912 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+3 where nodeid=1 and table_name='events' and field_name='eventid']
      zabbix-server [20461]: ERROR file:db.c,line:1582 Something impossible has just happened.
      20469:20120416:000139.913 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+24 where nodeid=1 and table_name='events' and field_name='eventid']
      zabbix-server [20469]: ERROR file:db.c,line:1582 Something impossible has just happened.
      20460:20120416:000139.913 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+6 where nodeid=1 and table_name='events' and field_name='eventid']
      zabbix-server [20460]: ERROR file:db.c,line:1582 Something impossible has just happened.
      20464:20120416:000149.926 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+26 where nodeid=1 and table_name='events' and field_name='eventid']
      zabbix-server [20464]: ERROR file:db.c,line:1582 Something impossible has just happened.
      20473:20120416:000205.948 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+2 where nodeid=1 and table_name='events' and field_name='eventid']
      20458:20120416:000205.948 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+2 where nodeid=1 and table_name='events' and field_name='eventid']
      zabbix-server [20473]: ERROR file:db.c,line:1582 Something impossible has just happened.
      zabbix-server [20458]: ERROR file:db.c,line:1582 Something impossible has just happened.
      20472:20120416:000205.949 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+21 where nodeid=1 and table_name='events' and field_name='eventid']
      zabbix-server [20472]: ERROR file:db.c,line:1582 Something impossible has just happened.
      20466:20120416:000206.950 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+13 where nodeid=1 and table_name='events' and field_name='eventid']
      zabbix-server [20466]: ERROR file:db.c,line:1582 Something impossible has just happened.
      20471:20120416:000227.979 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+19 where nodeid=1 and table_name='events' and field_name='eventid']
      zabbix-server [20471]: ERROR file:db.c,line:1582 Something impossible has just happened.
      20426:20120416:000241.101 Sending configuration data to proxy 'xxxxxx'. Datalen 193386
      20460:20120416:000313.042 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+9 where nodeid=1 and table_name='events' and field_name='eventid']
      zabbix-server [20460]: ERROR file:db.c,line:1582 Something impossible has just happened.
      zabbix-server [20460]: ERROR file:db.c,line:1582 Something impossible has just happened.
      20466:20120416:000315.045 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+13 where nodeid=1 and table_name='events' and field_name='eventid']
      zabbix-server [20466]: ERROR file:db.c,line:1582 Something impossible has just happened.
      20424:20120416:000328.504 Sending configuration data to proxy 'vzugunit8'. Datalen 193507
      20472:20120416:000353.099 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+21 where nodeid=1 and table_name='events' and field_name='eventid']
      20458:20120416:000353.099 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+2 where nodeid=1 and table_name='events' and field_name='eventid']
      zabbix-server [20458]: ERROR file:db.c,line:1582 Something impossible has just happened.
      zabbix-server [20472]: ERROR file:db.c,line:1582 Something impossible has just happened.
      20460:20120416:000407.119 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+9 where nodeid=1 and table_name='events' and field_name='eventid']
      zabbix-server [20460]: ERROR file:db.c,line:1582 Something impossible has just happened.
      20459:20120416:000413.127 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+13 where nodeid=1 and table_name='events' and field_name='eventid']
      zabbix-server [20459]: ERROR file:db.c,line:1582 Something impossible has just happened.
      20461:20120416:000416.131 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update ids set nextid=nextid+21 where nodeid=1 and table_name='events' and field_name='eventid']
      zabbix-server [20461]: ERROR file:db.c,line:1582 Something impossible has just happened.

      Could you please let me know if this is a known issue and if I have to do anything about it.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mcerutti Matteo Cerutti
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: