Zabbix 6 to 7 databsae upgrade fail on patch 06050201

[jgroves]

We are upgarding from Zabbix 6.0.39 to 7.0.0 (tested on 7.0 latest aswell, just logs are on 7.0.0 to test bugs), and when doing a test upgrade we get the following error:

Starting Zabbix Server. Zabbix 7.0.0 (revision 49955f1).
Press Ctrl+C to exit.

1:20250313:142516.859 Starting Zabbix Server. Zabbix 7.0.0 (revision 49955f1).
1:20250313:142516.859 ****** Enabled features ******
1:20250313:142516.859 SNMP monitoring: YES
1:20250313:142516.859 IPMI monitoring: YES
1:20250313:142516.859 Web monitoring: YES
1:20250313:142516.859 VMware monitoring: YES
1:20250313:142516.859 SMTP authentication: YES
1:20250313:142516.859 ODBC: YES
1:20250313:142516.859 SSH support: YES
1:20250313:142516.860 IPv6 support: YES
1:20250313:142516.860 TLS support: YES
1:20250313:142516.860 ******************************
1:20250313:142516.860 using configuration file: /etc/zabbix/zabbix_server.conf
1:20250313:142516.984 current database version (mandatory/optional): 06050200/06050200
1:20250313:142516.984 required mandatory version: 07000000
1:20250313:142516.984 mandatory patches were found
1:20250313:142516.987 starting automatic database upgrade
1:20250313:142516.993 host or template [hostid=10014] is not assigned to any group, permissions not granted
1:20250313:142517.642 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: null value in column "groupid" of relation "hgset_group" violates not-null constraint
DETAIL: Failing row contains (488, null).
[insert into hgset_group (hgsetid,groupid) values ... (487,332),(488,null),(488,188)...;
]
     1:20250313:142517.644 database upgrade failed on patch 06050201, exiting in 10 seconds
     1:20250313:142527.644 Zabbix Server stopped. Zabbix 7.0.0 (revision 49955f1).

the ... is just because there are alot of hostgroups

I am looking through the database to see if I can find the issue ... but not sure why it is picking up 'null'

Any advice would be appreciated ...

I had a similar issue it seems when going from zabbix 3 to 5 ... https://www.zabbix.com/forum/zabbix-...lue-on-groupid but cannot remember how i fixed it lol