Advertising:

Error al actualizar zabbix de 4.4.7 a 5 (beta) (Z3005 query failed: 1091 Can't DROP ‘snmpv3 securityname’)

From Zabbix-ES
Jump to navigation Jump to search

[Z3005] query failed: [1091] Can't DROP ‘snmpv3_securityname’

# systemctl stop zabbix-server
ERROR en el FrontEnd  : required mandatory version: 04050079
required mandatory version: 04050079


ERROR en log de Zabbix: [Z3005] query failed: [1091] Can't DROP ‘snmpv3_securityname’; check that column/key exists [alter table items drop column snmpv3_securityname]
Can't DROP ‘snmpv3_securityname’

Paso 1 Actualizar dbversion a la version que sale en el error

mysql> show databases;
mysql> use zabbix;
mysql> update dbversion set mandatory= 04050079;

Paso 2 Creamos la columna que falta e intentamos arrancar zabbix

mysql> use zabbix;
mysql> ALTER TABLE items ADD COLUMN snmpv3_securityname INT;
# systemctl start zabbix-server
# tail -f /var/log/zabbix/zabbix_server.log
Miramos el Log y vemos si arranca correctamente. 
Database Ugrading