zabbix_log.log
[ZBX-20734] Upgrade from 5.4.7 to 6.0.1 : Database upgrade failed Created: 2022 Mar 11 Updated: 2022 Mar 14 Resolved: 2022 Mar 14 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Installation (I) |
| Affects Version/s: | 6.0.1 |
| Fix Version/s: | None |
| Type: | Problem report | Priority: | Trivial |
| Reporter: | Jérémy Neveu | Assignee: | Zabbix Support Team |
| Resolution: | Won't fix | Votes: | 0 |
| Labels: | MySQL | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Debian 11, Mysql Mariadb 10.5.12 |
||
| Attachments: |
zabbix_log.log
|
| Description |
|
Hi, I want to upgrade zabbix from 5.4.7 to 6.0.1 but i have an error when zabbix want to upgrade the database : [Z3005] query failed: [1005] Can't create table `zabbix`.`service_status_rule` (errno: 121 "Duplicate key on write or update") [alter table `service_status_rule` add constraint c_service_status_rule_1 foreign key (`serviceid`) references `services` (`serviceid`) on delete cascade] Can you help me ? |
| Comments |
| Comment by Edgar Akhmetshin [ 2022 Mar 14 ] |
|
Hello This means - inconsistent data in the database, check schema for constraints and foreign keys of the involved tables, cleanup orphaned data. Please be advised that this section of the tracker is for bug reports only. The case you have submitted can not be qualified as one, so please reach out to [email protected] for commercial support (https://zabbix.com/support) or consultancy services. Alternatively, you can also use our IRC channel or community forum (https://www.zabbix.com/forum) for assistance. With that said, we are closing this ticket. Thank you for understanding. Regards, |