-
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?