XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 2.0.8, 2.0.9
    • None
    • Server (S)
    • FreeBSD 8.4, MySQL 5.6.14

    Description

      I have updated zabbix server from version 1.8.16 to 2.0.8 but zabbix server doesn't start. I've noticed that most updated table is ids, so I went to Debug level 4 and this log was repeating in very fast loop. at this point, no graph is updated and you cannot add or update any host or item, until you stop the zabbix server and it starts syncing history and trends and graphs are shown.

      19883:20131009:115427.627 query [txnlev:1] [update ids set nextid=nextid+47257 where nodeid=0 and table_name='events' and field_name='eventid']
      19883:20131009:115427.635 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
      19883:20131009:115427.647 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
      19883:20131009:115427.648 query [txnlev:1] [update ids set nextid=nextid+47257 where nodeid=0 and table_name='events' and field_name='eventid']
      19883:20131009:115427.655 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
      19883:20131009:115427.657 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
      19883:20131009:115427.658 query [txnlev:1] [update ids set nextid=nextid+47257 where nodeid=0 and table_name='events' and field_name='eventid']
      19883:20131009:115427.668 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
      19883:20131009:115427.680 query [txnlev:1] [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']

      I've tried disabling some triggers, and actions, upgrading from 2.0.8 to 2.0.9 stable but the problem remains the same. i've checked max(eventid) and eventid from ids table and it seems it is only increasing the ids but not using it as event at all.

      mysql> select * from ids where field_name="eventid"; select max(eventid) from events;
      --------------------------------------+

      nodeid table_name field_name nextid

      --------------------------------------+

      0 events eventid 8771531024

      --------------------------------------+
      1 row in set (0.01 sec)

      --------------

      max(eventid)

      --------------

      7596302101

      --------------
      1 row in set (0.00 sec)

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              webworld Morteza Gh
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: