Hi there,

Trying to update our productive Zabbix at the company I run into following Problems:

Unable to Upgrade from v4 to v5 since database upgrade fails with following message:

 14350:20211123:094213.782 Starting Zabbix Server. Zabbix 5.0.17 (revision 0a4ac3dabc).
 14350:20211123:094213.782 ****** Enabled features ******
 14350:20211123:094213.783 SNMP monitoring:           YES
 14350:20211123:094213.783 IPMI monitoring:           YES
 14350:20211123:094213.783 Web monitoring:            YES
 14350:20211123:094213.783 VMware monitoring:         YES
 14350:20211123:094213.783 SMTP authentication:       YES
 14350:20211123:094213.783 ODBC:                      YES
 14350:20211123:094213.783 SSH support:               YES
 14350:20211123:094213.784 IPv6 support:              YES
 14350:20211123:094213.784 TLS support:               YES
 14350:20211123:094213.784 ******************************
 14350:20211123:094213.784 using configuration file: /etc/zabbix/zabbix_server.conf
 14350:20211123:094213.803 current database version (mandatory/optional): 04000000/04000006
 14350:20211123:094213.803 required mandatory version: 05000000
 14350:20211123:094213.803 optional patches were found
 14350:20211123:094213.803 starting automatic database upgrade
 14350:20211123:094213.834 completed 0% of database upgrade
 14350:20211123:094213.870 completed 1% of database upgrade
 14350:20211123:094214.110 completed 2% of database upgrade
 14350:20211123:094214.319 completed 3% of database upgrade
 14350:20211123:094214.407 completed 4% of database upgrade
 14350:20211123:094214.591 completed 5% of database upgrade
 14350:20211123:094215.265 completed 6% of database upgrade
 14350:20211123:094215.275 completed 7% of database upgrade
 14350:20211123:094215.711 completed 8% of database upgrade
 14350:20211123:094215.775 completed 9% of database upgrade
 14350:20211123:094215.933 completed 10% of database upgrade
 14350:20211123:094216.001 completed 11% of database upgrade
 14350:20211123:094216.030 completed 12% of database upgrade
 14350:20211123:094216.202 completed 13% of database upgrade
 14350:20211123:094216.490 completed 14% of database upgrade
 14350:20211123:094216.779 completed 15% of database upgrade
 14350:20211123:094217.523 completed 16% of database upgrade
 14350:20211123:094217.596 completed 17% of database upgrade
 14350:20211123:094217.865 completed 18% of database upgrade
 14350:20211123:094218.034 completed 19% of database upgrade
 14350:20211123:094218.064 completed 20% of database upgrade
 14350:20211123:094218.111 completed 21% of database upgrade
 14350:20211123:094218.162 completed 22% of database upgrade
 14350:20211123:094218.736 completed 23% of database upgrade
 14350:20211123:094218.873 completed 24% of database upgrade
 14350:20211123:094218.882 completed 25% of database upgrade
 14350:20211123:094218.914 completed 26% of database upgrade
 14350:20211123:094218.921 completed 27% of database upgrade
 14350:20211123:094218.926 completed 28% of database upgrade
 14350:20211123:094218.957 completed 29% of database upgrade
 14350:20211123:094219.058 completed 30% of database upgrade
 14350:20211123:094219.546 completed 31% of database upgrade
 14350:20211123:094219.616 completed 32% of database upgrade
 14350:20211123:094219.693 completed 33% of database upgrade
 14350:20211123:094219.755 completed 34% of database upgrade
 14350:20211123:094219.835 completed 35% of database upgrade
 14350:20211123:094220.108 completed 36% of database upgrade
 14350:20211123:094220.190 completed 37% of database upgrade
 14350:20211123:094220.228 completed 38% of database upgrade
 14350:20211123:094220.287 completed 39% of database upgrade
 14350:20211123:094220.534 completed 40% of database upgrade
 14350:20211123:094223.334 completed 41% of database upgrade
 14350:20211123:094223.410 completed 42% of database upgrade
 14350:20211123:094223.417 completed 43% of database upgrade
 14350:20211123:094223.752 completed 44% of database upgrade
 14350:20211123:094223.797 completed 45% of database upgrade
 14350:20211123:094223.863 completed 46% of database upgrade
 14350:20211123:094223.929 completed 47% of database upgrade
 14350:20211123:094223.987 completed 48% of database upgrade
 14350:20211123:094224.396 completed 49% of database upgrade
 14350:20211123:094224.448 completed 50% of database upgrade
 14350:20211123:094224.707 completed 51% of database upgrade
 14350:20211123:094224.914 [Z3005] query failed: [1265] Data truncated for column 'note' at row 1 [alter table `auditlog` change column `details` `note` varchar(128) default '0' not null]
 14350:20211123:094224.915 database upgrade failed

Upgrade to 4.2 goes through but any further version will not work and fail with the same error message from above.

If you need more information, feel free to ask.

Greetings,

Andreas