-
Problem report
-
Resolution: Won't fix
-
Trivial
-
None
-
None
-
None
-
None
-
Debian 12 bookworm
Nginx 1.22
postgresql 16.3
php-fpm 8.3
Steps to reproduce:
Folow by update instructions on 2 Debian/Ubuntu (zabbix.com)
- stop zabbix_server service
- backup zabbix database on postgres
- Install php8.3-fpm
- stop php7.4-fpm service
- backup files and folders from instruction
- download and update apt repozitory for zabbix verzion 7.0
- upgrade zabbix-server-pgsql zabbix-frontend-php zabbix-agent
- durring upgrade save the repozitory zabbix_server.conf file
- ater upgrade changed DBPassword parameterr - only parameter set for instaletion of zabbix 6.4
- install php-pgsql
- start zabbix-server.service
Result:
On zabbix page thers an error
on log file zabbix_server.log:
20040:20240607:092637.341 Starting Zabbix Server. Zabbix 7.0.0 (revision 49955f1fb5c). 20040:20240607:092637.342 ****** Enabled features ****** 20040:20240607:092637.342 SNMP monitoring: YES 20040:20240607:092637.342 IPMI monitoring: YES 20040:20240607:092637.342 Web monitoring: YES 20040:20240607:092637.342 VMware monitoring: YES 20040:20240607:092637.342 SMTP authentication: YES 20040:20240607:092637.342 ODBC: YES 20040:20240607:092637.342 SSH support: YES 20040:20240607:092637.342 IPv6 support: YES 20040:20240607:092637.342 TLS support: YES 20040:20240607:092637.342 ****************************** 20040:20240607:092637.342 using configuration file: /etc/zabbix/zabbix_server.conf 20040:20240607:092637.453 current database version (mandatory/optional): 06050110/06050110 20040:20240607:092637.453 required mandatory version: 07000000 20040:20240607:092637.453 mandatory patches were found 20040:20240607:092637.457 starting automatic database upgrade 20040:20240607:092637.463 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: table tid from new index tuple (336,20) overlaps with invalid duplicate tuple at offset 27 of block 108 in index "items_8" [update items set timeout='' where type not in (19,21)] 20040:20240607:092637.463 database upgrade failed on patch 06050111, exiting in 10 seconds 20040:20240607:092647.464 Zabbix Server stopped. Zabbix 7.0.0 (revision 49955f1fb5c).
Expected:
Hotfix or Patched version of database migration script to pass 06050111 database patch
