Fail to upgtrade 6.2.1 to 6.2.6 (zabbix image).

[Vitaly Tokarenko]

After upgrade 6.2.1 to 6.2.6 on official image (VirtualBox) after systemctl start zabbix_server server write to Log file.

2063:20221214:113512.630 starting automatic database upgrade
2063:20221214:113512.632 [Z3005] query failed: [1142] TRIGGER command denied to user 'zabbix_srv'@'localhost' for table 'hosts' [create trigger hosts_name_upper_insert
before insert on hosts for each row
set new.name_upper=upper(new.name)]
2063:20221214:113512.636 database upgrade failed

[Vitaly Tokarenko]

The problem is in MySql privilegies. Looks I was inattentive and somewhere made typos. So.
1. Assign password to root to get rights change privelegies to zabbix_srv
$ mysqladmin -u root password SuperSuperPassword
2. Login to Mysql as Root with Password.
mysql -u root -p
3. Change grants to two tables.
MySql> GRANT trigger ON zabbix.hosts TO 'zabbix_srv'@'localhost';
MySql> GRANT trigger ON zabbix.items TO 'zabbix_srv'@'localhost';
MySql> exit
4. Start zabbix server
$ systemctl start zabbix-server
5. check the process
$ tail /var/log/zabbix/zabbix_server.log

Hope everything will be Ok.

[Vitaly Tokarenko]

The problem is in MySql privilegies. Looks I was inattentive and somewhere made typos. So.
1. Assign password to root to get rights change privelegies to zabbix_srv
$ mysqladmin -u root password SuperSuperPassword
2. Login to Mysql as Root with Password.
mysql -u root -p
3. Change grants to two tables.
MySql> GRANT trigger ON zabbix.hosts TO 'zabbix_srv'@'localhost';
MySql> GRANT trigger ON zabbix.items TO 'zabbix_srv'@'localhost';
MySql> exit
4. Start zabbix server
$ systemctl start zabbix-server
5. check the process
$ tail /var/log/zabbix/zabbix_server.log

Hope everything will be Ok.

[tonytlc]

Hi,
I have similar problem but with update zabbix server from 6.0.21 to 6.4.1
In my case I saw this on log file:

330688:20230905:162643.140 current database version (mandatory/optional): 06000000/06000020
330688:20230905:162643.143 starting automatic database upgrade
330688:20230905:162643.146 completed 0% of database upgrade
330688:20230905:162643.287 completed 1% of database upgrade
330688:20230905:162643.801 completed 2% of database upgrade
330688:20230905:162643.917 completed 3% of database upgrade
330688:20230905:162644.049 completed 4% of database upgrade
330688:20230905:162644.106 completed 5% of database upgrade
330688:20230905:162644.180 completed 6% of database upgrade
330688:20230905:162644.297 completed 7% of database upgrade
330688:20230905:162644.392 completed 8% of database upgrade
330688:20230905:162644.414 completed 9% of database upgrade
330688:20230905:162644.421 completed 10% of database upgrade
330688:20230905:162644.488 completed 11% of database upgrade
330688:20230905:162644.589 completed 12% of database upgrade
330688:20230905:162644.591 database upgrade failed on patch 06010035, exiting in 10 seconds
330702:20230905:162704.814 current database version (mandatory/optional): 06010034/06010034
330702:20230905:162704.816 starting automatic database upgrade
330702:20230905:162704.817 database upgrade failed on patch 06010035, exiting in 10 seconds

You have any idea for resolve this problem?
I try all that I have read on this forum but my problem it's the same, thanks in advance.