Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-15763

Zabbix server update failed 3.4 to 4.0.5 while automatic database upgrade

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Fixed
    • Icon: Critical Critical
    • None
    • 4.0.5
    • Server (S)
    • None

      128770:20190305:153458.209 query [txnlev:1] [begin;]
      128770:20190305:153458.209 query [txnlev:1] [alter table `event_suppress` add constraint c_event_suppress_1 foreign key (`eventid`) references `events` (`eventid`) on delete cascade]
      128770:20190305:153458.242 [Z3005] query failed: [1005] Can't create table `zabbix`.`event_suppress` (errno: 150 "Foreign key constraint is incorrectly formed") [alter table `event_suppress` add constraint c_event_suppress_1 foreign key (`eventid`) references `events` (`eventid`) on delete cascade]
      128770:20190305:153458.242 query [alter table `event_suppress` add constraint c_event_suppress_1 foreign key (`eventid`) references `events` (`eventid`) on delete cascade] failed, setting transaction as failed
      128770:20190305:153458.242 query [txnlev:1] [rollback;]
      128770:20190305:153458.242 database upgrade failed

            zabbix.support Zabbix Support Team
            hexes Ivan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: