-
Incident report
-
Resolution: Won't fix
-
Trivial
-
None
-
6.2.3
-
None
-
Debian 11
MariaDB 10.8.5
Zabbix server 6.0.9 -> 6.2.3
Steps to reproduce:
- Schema in use is attached to this case
- AX-6.0.9.sql
- Upgrade from 6.0.9 -> 6.2.3
Result:
7681:20221028:150332.462 completed 77% of database upgrade 7681:20221028:150341.729 slow query: 9.266241 sec, "alter table `items` add constraint c_items_2 foreign key (`templateid`) references `items` (`itemid`)" 7681:20221028:150341.730 completed 78% of database upgrade 7681:20221028:150341.799 completed 79% of database upgrade 7681:20221028:150406.845 slow query: 25.045478 sec, "alter table `items` add constraint c_items_5 foreign key (`master_itemid`) references `items` (`itemid`)" 7681:20221028:150406.846 completed 80% of database upgrade 7681:20221028:150407.091 completed 81% of database upgrade 7681:20221028:150410.627 completed 82% of database upgrade 7681:20221028:150410.652 completed 83% of database upgrade 7681:20221028:150410.675 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`#sql-alter-318-2c`, CONSTRAINT `c_functions_1` FOREIGN KEY (`itemid`) REFERENCES `items` (`itemid`)) [alter table `functions` add constraint c_functions_1 foreign key (`itemid`) references `items` (`itemid`)] 7681:20221028:150410.675 database upgrade failed
Expected:
Database upgrade
