DB error when upgrading from 6.0.14 to 7.0.9

[hb8323634]

All,
I'm trying to upgrade from 6.0.14 to 7.0.9 (using official Debian backport repository) and getting the following error:

[Z3005] query failed: [1091] Can't DROP INDEX `scripts_3`; check that it exists [drop index scripts_3 on scripts]

I tried:

mysql> SET GLOBAL log_bin_trust_function_creators = 1;

but that didn't make a difference.

My system:
- Debian 12.10
- MariaDB 10.11.11

I would appreciate any suggestions.
Thank you!


Full log:

 47929:20250509:121309.464 Starting Zabbix Server. Zabbix 7.0.9 (revision 05b8b05eefe).
 47929:20250509:121309.464 ****** Enabled features ******
 47929:20250509:121309.464 SNMP monitoring:           YES
 47929:20250509:121309.464 IPMI monitoring:           YES
 47929:20250509:121309.465 Web monitoring:            YES
 47929:20250509:121309.465 VMware monitoring:         YES
 47929:20250509:121309.465 SMTP authentication:       YES
 47929:20250509:121309.465 ODBC:                      YES
 47929:20250509:121309.465 SSH support:               YES
 47929:20250509:121309.465 IPv6 support:              YES
 47929:20250509:121309.465 TLS support:               YES
 47929:20250509:121309.465 ******************************
 47929:20250509:121309.465 using configuration file: /etc/zabbix/zabbix_server.conf
 47929:20250509:121309.475 current database version (mandatory/optional): 06000000/06000018
 47929:20250509:121309.475 required mandatory version: 07000000
 47929:20250509:121309.475 mandatory patches were found
 47929:20250509:121309.478 starting automatic database upgrade
 47929:20250509:121309.481 completed 0% of database upgrade
 47929:20250509:121309.556 completed 1% of database upgrade
 47929:20250509:121309.623 completed 2% of database upgrade
 47929:20250509:121309.673 completed 3% of database upgrade
 47929:20250509:121309.717 completed 4% of database upgrade
 47929:20250509:121309.740 completed 5% of database upgrade
 47929:20250509:121309.768 completed 6% of database upgrade
 47929:20250509:121309.797 completed 7% of database upgrade
 47929:20250509:121309.840 completed 8% of database upgrade
 47929:20250509:121309.881 completed 9% of database upgrade
 47929:20250509:121309.918 completed 10% of database upgrade
 47929:20250509:121309.963 completed 11% of database upgrade
 47929:20250509:121309.998 completed 12% of database upgrade
 47929:20250509:121310.379 completed 13% of database upgrade
 47929:20250509:121310.589 completed 14% of database upgrade
 47929:20250509:121310.669 completed 15% of database upgrade
 47929:20250509:121310.741 completed 16% of database upgrade
 47929:20250509:121310.763 completed 17% of database upgrade
 47929:20250509:121310.811 completed 18% of database upgrade
 47929:20250509:121310.853 completed 19% of database upgrade
 47929:20250509:121310.888 completed 20% of database upgrade
 47929:20250509:121310.921 completed 21% of database upgrade
 47929:20250509:121310.952 completed 22% of database upgrade
 47929:20250509:121311.007 completed 23% of database upgrade
 47929:20250509:121311.068 completed 24% of database upgrade
 47929:20250509:121311.127 completed 25% of database upgrade
 47929:20250509:121311.198 completed 26% of database upgrade
 47929:20250509:121311.237 completed 27% of database upgrade
 47929:20250509:121311.239 hosts_name_upper_update trigger for table "hosts" already exists, skipping patch of adding "name_upper" column to "hosts" table
 47929:20250509:121311.242 hosts_name_upper_update trigger for table "hosts" already exists, skipping patch of adding index to "name_upper" column
 47929:20250509:121311.244 hosts_name_upper_update trigger for table "hosts" already exists, skipping patch of updating "name_upper" column
 47929:20250509:121311.247 hosts_name_upper_insert trigger for table "hosts" already exists, skipping patch of adding it to "hosts" table
 47929:20250509:121311.250 hosts_name_upper_update trigger for table "hosts" already exists, skipping patch of adding it to "hosts" table
 47929:20250509:121311.253 items_name_upper_update trigger for table "items" already exists, skipping patch of adding "name_upper" column to "items" table
 47929:20250509:121311.254 completed 28% of database upgrade
 47929:20250509:121311.256 items_name_upper_update trigger for table "items" already exists, skipping patch of adding index to "name_upper" column
 47929:20250509:121311.259 items_name_upper_update trigger for table "items" already exists, skipping patch of updating "name_upper" column
 47929:20250509:121311.262 items_name_upper_insert trigger for table "items" already exists, skipping patch of adding it to "items" table
 47929:20250509:121311.264 items_name_upper_update trigger for table "items" already exists, skipping patch of adding it to "items" table
 47929:20250509:121311.289 completed 29% of database upgrade
 47929:20250509:121311.403 completed 30% of database upgrade
 47929:20250509:121311.475 completed 31% of database upgrade
 47929:20250509:121311.532 completed 32% of database upgrade
 47929:20250509:121311.578 completed 33% of database upgrade
 47929:20250509:121311.624 completed 34% of database upgrade
 47929:20250509:121311.694 completed 35% of database upgrade
 47929:20250509:121311.745 completed 36% of database upgrade
 47929:20250509:121311.787 completed 37% of database upgrade
 47929:20250509:121311.837 completed 38% of database upgrade
 47929:20250509:121311.899 completed 39% of database upgrade
 47929:20250509:121311.944 completed 40% of database upgrade
 47929:20250509:121311.985 completed 41% of database upgrade
 47929:20250509:121312.026 completed 42% of database upgrade
 47929:20250509:121312.064 completed 43% of database upgrade
 47929:20250509:121312.106 completed 44% of database upgrade
 47929:20250509:121312.144 completed 45% of database upgrade
 47929:20250509:121312.185 completed 46% of database upgrade
 47929:20250509:121312.186 [Z3005] query failed: [1091] Can't DROP INDEX `scripts_3`; check that it exists [drop index scripts_3 on scripts]
 47929:20250509:121312.186 database upgrade failed on patch 06030192, exiting in 10 seconds
 47929:20250509:121322.187 Zabbix Server stopped. Zabbix 7.0.9 (revision 05b8b05eefe).​