Ad Widget

**Markku** · 28-07-2025, 10:40

If you know that you haven't altered the database in any unusual way (by attempting some beta versions or manually editing the schema, or anything like that), you could definitely open an issue at https://support.zabbix.com as they promise direct upgrade path from 5.0.x to 7.0.x.

Even better if you can provide an easily reproducable case by installing 5.0.35 in a new setup and then upgrading it with the same issue.

Markku

**carnotan** · 28-07-2025, 11:36

We never attempted any beta versions. Any tests that we take are preceded by an Image in Vsphere (it's a virtualized system) and are therefore reverted. What we do (since this is de DEV environment) is import the production data into this database (but are exactly the same machines, software and Zabbix version). This is done to test and validate the upgrade procedure before doing it in production or any changes that we deem "sensible" are tested before on DEV . Just thought to mention it in case it was noteworthy. I'll open a bug request.

EDIT: Opened https://support.zabbix.com/browse/ZBX-26759

**Markku** · 28-07-2025, 18:12

Can you share the following outputs from the database?

select count(*) from information_schema.columns where table_schema = "zabbix" and table_name = "config";

(my test database has 85 columns in config table)

select column_name from information_schema.columns where table_schema = "zabbix" and table_name = "config" and column_name like "ha%";

(my test database has none)

Here are all the columns in my empty 5.0.35 database:

Code:

select column_name from information_schema.columns where table_schema = "zabbix" and table_name = "config";
+----------------------------+
| column_name                |
+----------------------------+
| configid                   |
| refresh_unsupported        |
| work_period                |
| alert_usrgrpid             |
| default_theme              |
| authentication_type        |
| ldap_host                  |
| ldap_port                  |
| ldap_base_dn               |
| ldap_bind_dn               |
| ldap_bind_password         |
| ldap_search_attribute      |
| discovery_groupid          |
| max_in_table               |
| search_limit               |
| severity_color_0           |
| severity_color_1           |
| severity_color_2           |
| severity_color_3           |
| severity_color_4           |
| severity_color_5           |
| severity_name_0            |
| severity_name_1            |
| severity_name_2            |
| severity_name_3            |
| severity_name_4            |
| severity_name_5            |
| ok_period                  |
| blink_period               |
| problem_unack_color        |
| problem_ack_color          |
| ok_unack_color             |
| ok_ack_color               |
| problem_unack_style        |
| problem_ack_style          |
| ok_unack_style             |
| ok_ack_style               |
| snmptrap_logging           |
| server_check_interval      |
| hk_events_mode             |
| hk_events_trigger          |
| hk_events_internal         |
| hk_events_discovery        |
| hk_events_autoreg          |
| hk_services_mode           |
| hk_services                |
| hk_audit_mode              |
| hk_audit                   |
| hk_sessions_mode           |
| hk_sessions                |
| hk_history_mode            |
| hk_history_global          |
| hk_history                 |
| hk_trends_mode             |
| hk_trends_global           |
| hk_trends                  |
| default_inventory_mode     |
| custom_color               |
| http_auth_enabled          |
| http_login_form            |
| http_strip_domains         |
| http_case_sensitive        |
| ldap_configured            |
| ldap_case_sensitive        |
| db_extension               |
| autoreg_tls_accept         |
| compression_status         |
| compression_availability   |
| compress_older             |
| instanceid                 |
| saml_auth_enabled          |
| saml_idp_entityid          |
| saml_sso_url               |
| saml_slo_url               |
| saml_username_attribute    |
| saml_sp_entityid           |
| saml_nameid_format         |
| saml_sign_messages         |
| saml_sign_assertions       |
| saml_sign_authn_requests   |
| saml_sign_logout_requests  |
| saml_sign_logout_responses |
| saml_encrypt_nameid        |
| saml_encrypt_assertions    |
| saml_case_sensitive        |
+----------------------------+
85 rows in set (0.001 sec)

Markku

**tim.mooney** · 30-07-2025, 04:40

Originally posted by carnotan

I have two RHEL 8 servers (one for the frontend on Apache, one for the backend on MySQL ) . Currently running 5.0.35 without a problem. We need to upgrade to 7
125290:20250724:102228.877 current database version (mandatory/optional): 05000000/05000007
125290:20250724:102228.877 required mandatory version: 07000000
125290:20250724:102228.877 mandatory patches were found
125290:20250724:102228.878 [Z3005] query failed: [1054] Unknown column 'ha_failover_delay' in 'field list' [select unix_timestamp(),ha_failover_delay from config]

Search these forums with the text

ha_failover_delay

You will see dozens of people that ran into the same problem.

See Cyber's comments and my comments in this thread: https://www.zabbix.com/forum/zabbix-...%E2%86%927-2-4

Ad Widget

Can't upgrade from Zabbix 5 to Zabbix 7

Can't upgrade from Zabbix 5 to Zabbix 7

Comment

Comment

Comment

Comment