-
Problem report
-
Resolution: Fixed
-
Minor
-
6.0.10, 6.2.4
-
None
-
RHEL 8
Mariadb 10.6
Galera Cluster
Zabbix 3.4
-
Sprint 94 (Nov 2022)
-
0.125
Steps to reproduce:
- Run automatical DB upgrade in a system with strict primary keys requirement (InnoDB Cluster/Galera Cluster, etc) via Zabbix-server service new binary run (6.2.4)
- Â Check the upgrade process
Result:
DB schema upgrade fails because the application trying to create a table without primary keys (see the screenshot)
Expected:
We've upgraded to the 6.2 version, table in the 6.2 version schema has a primary key - the table should be updated to the latest version directly without consecutive changes
trigger_queue table creation statement example from MySQL schema file (Zabbix 6.2.4)Â
CREATE TABLE `trigger_queue` (   ->     `trigger_queueid`     bigint unsigned              NOT NULL,   ->     `objectid`        bigint unsigned              NOT NULL,   ->     `type`          integer     DEFAULT '0'        NOT NULL,   ->     `clock`          integer     DEFAULT '0'        NOT NULL,   ->     `ns`           integer     DEFAULT '0'        NOT NULL,   ->     PRIMARY KEY (trigger_queueid)   -> ) ENGINE=InnoDB;
The table creation patch is defined in
Workaround:
innodb_force_primary_key=0Â
into MariaDB configuration - restart required (downtime for the whole DB cluster during the restart)