Zabbix Upgrade Fail - From 3.4.1 to 4.0

[JCast638]

Hi!

I follow the steps in Zabbix documetation to upgrade my service from 3.4.1 to 4.0:

https://www.zabbix.com/documentation/4.0/manual/installation/upgrade/packages/debian_ubuntu

1. I stop Zabbix service

2. Backup database

3. Backup config fles

So when the upgrade process finishes and I start Zabbix (/etc/init.d/zabbix_server start) the zabbix startup process stops on automatic updating of the database, as follows:


[Z3005] query failed: [1054] Unknown column 'acknowledged' in 'field list' [update prob
lem set acknowledged=(select acknowledged from events where events.eventid=problem.eventid)]
29081:20190113:074128.660 database upgrade failed

Someone helps!!

[zux]

It seems that you have a problem with your DB. Have you modified it manually?
I would suggest to take a clean installation of your version Zabbix db, and compare the table schema.
You can even omit the clean installation, just create another DB and push the schema.sql into it.
If you can figure out from that, how to fix this, you can try. Otherwise I would suggest taking a configuration bacup and starting from clean db.