Upgrade Problems and troubleshooting from 3.4.15 to 4.0 (repository and Database)

[carsa81]

Hi

I Just upgrade my Zabbix Server from 3.4.15 to 4.0.0 (on my Centos7.5 mysql/apache)

I want share some problems and fix that I used.

I follow this Guide: https://www.zabbix.com/documentation...es/rhel_centos

First problem: Repository Zabbix 4.0 are not seen

FIX:

• Use > sudo yum clean all > sudo rm -rf /var/cache/yum > sudo yum repolist > then perform sudo yum update/upgrade -y

Second Problem: DB upgrade failed

FIX:

1. check the log sudo cat /var/log/zabbix/zabbix_server.log
2. On logs: "[Z3005] query failed: [1060] Duplicate column name 'severity' [alter table `events` add `severity` integer def ault '0' not null]'
3. According with this Issue https://support.zabbix.com/projects/...lter=allissues I removed the severity value in the events table.
   1. mysql -u USER -P
   2. use DB-ZABBIX;
   3. ALTER TABLE events DROP COLUMN severity;
   4. exit
4. sudo systemctl start zabbix-server.service
5. check log and try to login on dashboard

I hope this will be useful to someone.

[sancho]

Use > yum clean all > rm -rf /var/cache/yum > yum repolist > the perform yum update/upgrade -y

Thank you very much carsa81
You have saved me a headache.

[Mun]

Hi

I Just upgrade my Zabbix Server from 3.4.15 to 4.0.0 (on my Centos7.5 mysql/apache)

I want share some problems and fix that I used.

I follow this Guide: https://www.zabbix.com/documentation...es/rhel_centos

First problem: Repository Zabbix 4.0 are not seen

FIX:

• Use > sudo yum clean all > sudo rm -rf /var/cache/yum > sudo yum repolist > then perform sudo yum update/upgrade -y

Second Problem: DB upgrade failed

FIX:

1. check the log sudo cat /var/log/zabbix/zabbix_server.log
2. On logs: "[Z3005] query failed: [1060] Duplicate column name 'severity' [alter table `events` add `severity` integer def ault '0' not null]'
3. According with this Issue https://support.zabbix.com/projects/...lter=allissues I removed the severity value in the events table.
   1. mysql -u USER -P
   2. use DB-ZABBIX;
   3. ALTER TABLE events DROP COLUMN severity;
   4. exit
4. sudo systemctl start zabbix-server.service
5. check log and try to login on dashboard

I hope this will be useful to someone.

Thanks! Your solution works for me.

[hugosantos]

Thanks for this.

[tealsteam]

Thanks very much, this helped a treat!