I'm trying to get a 3.4 server upgraded to 4.0. However, the database upgrade is failing with the following error: [Z3005] query failed: [1060] Duplicate column name 'name' [alter table `events` add `name` varchar(2048) default '' not null]. I tried deleting the column 'name' from the 'events' table and restarting zabbix server. Unfortunately, I got the same error. Does anyone know to get around this problem? Thanks.
-
-
I had this error as well...- Delete the column
- Restart the upgrade
- Start zabbix server
-
That worked for you? I've tried it three times without success. I'll give it one more try.Comment
-
What's the output of your zabbix server log ?Comment
-
Ok. It appears to be working now. The mistake I made was that I was restarting the zabbix-server after making the database changes instead of completely stopping the service before making the changes. So, the steps to fix the problem were:
1. Stop the zabbix-server service (systemctl stop zabbix-server)
2. Log into MariaDB or MySQL and drop the column (alter table events drop column name
3. Restart the zabbix-server service (systemctl start zabbix-server)
Thank you for your help.Comment
Comment