Upgrade from 2.0.6 to 2.2 failed

XMLWordPrintable

    • Type: Incident report
    • Resolution: Incomplete
    • Priority: Major
    • None
    • Affects Version/s: None
    • Component/s: None
    • None

      Hi,

      some time ago I tried to upgrade zabbix and script failed. In the log I see:

      16373:20140212:164028.727 Starting Zabbix Server. Zabbix 2.2.1 (revision 40808).
      16373:20140212:164028.727 ****** Enabled features ******
      16373:20140212:164028.727 SNMP monitoring: YES
      16373:20140212:164028.727 IPMI monitoring: YES
      16373:20140212:164028.727 WEB monitoring: YES
      16373:20140212:164028.727 VMware monitoring: YES
      16373:20140212:164028.727 Jabber notifications: YES
      16373:20140212:164028.727 Ez Texting notifications: YES
      16373:20140212:164028.727 ODBC: YES
      16373:20140212:164028.727 SSH2 support: YES
      16373:20140212:164028.727 IPv6 support: YES
      16373:20140212:164028.727 ******************************
      16373:20140212:164028.727 NodeID: 1
      16373:20140212:164028.727 ******************************
      16373:20140212:164028.727 using configuration file: /etc/zabbix/zabbix_server.conf
      16373:20140212:164028.732 current database version (mandatory/optional): 02010021/02010021
      16373:20140212:164028.732 required mandatory version: 02020000
      16373:20140212:164028.732 starting automatic database upgrade
      16373:20140212:164028.732 [Z3005] query failed: [1060] Duplicate column name 'snmpv3_authprotocol' [alter table items add snmpv3_authprotocol integer default '0' not null]
      16373:20140212:164028.732 database upgrade failed

      I have Zabbix 2.0.6 (revision 35158).

      /etc/init.d/mysql status
      [info] /usr/bin/mysqladmin Ver 8.42 Distrib 5.5.31, for debian-linux-gnu on i686
      Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

      Oracle is a registered trademark of Oracle Corporation and/or its
      affiliates. Other names may be trademarks of their respective
      owners.

      Server version 5.5.31-1
      Protocol version 10
      Connection Localhost via UNIX socket
      UNIX socket /var/run/mysqld/mysqld.sock
      Uptime: 8 days 23 hours 42 min 3 sec

      Threads: 165 Questions: 125493248 Slow queries: 2116 Opens: 448 Flush tables: 1 Open tables: 400 Queries per second avg: 161.609.

      Can anyone help me please?

            Assignee:
            Unassigned
            Reporter:
            Ales Rataj
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: