database upgrade fails if httptest_2 index does not exist

XMLWordPrintable

    • Type: Incident report
    • Resolution: Duplicate
    • Priority: Trivial
    • None
    • Affects Version/s: 2.0.12, 2.2.4
    • Component/s: Frontend (F), Server (S)
    • None

      I updated 2.0 to 2.2, no db change. Server was unable to start. From the log:

      Starting Zabbix Server. Zabbix 2.2.4 (revision 46772).
      ...
      current database version (mandatory/optional): 02010000/02010000
      required mandatory version: 02020000
      optional patches were found
      starting automatic database upgrade
      completed 0% of database upgrade
      completed 1% of database upgrade
      completed 2% of database upgrade
      completed 3% of database upgrade
      completed 4% of database upgrade
      completed 5% of database upgrade
      completed 6% of database upgrade
      [Z3005] query failed: [1091] Can't DROP 'httptest_2'; check that column/key exists [drop index httptest_2 on httptest]
      database upgrade failed

      I was able to start zabbix server and successfully upgrade database by issuing the following mysql command:
      CREATE INDEX httptest_2 on httptest (name);

      It would be nice if database upgrade did not fail if index which is going to be dropped does not exist.

            Assignee:
            Unassigned
            Reporter:
            Nerijus Baliunas
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: