Ad Widget

Collapse

Ошибка обновления 4.2.8 -> 4.4.4

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • zawex6
    Junior Member
    • Jan 2018
    • 9

    #1

    Ошибка обновления 4.2.8 -> 4.4.4

    Коллеги выручайте!
    После обновления до 4.4.4, update BD не проходит:
    --
    23273:20200123:162114.359 Starting Zabbix Server. Zabbix 4.4.4 (revision 3131fdac04).
    23273:20200123:162114.359 ****** Enabled features ******
    23273:20200123:162114.360 SNMP monitoring: YES
    23273:20200123:162114.360 IPMI monitoring: YES
    23273:20200123:162114.360 Web monitoring: YES
    23273:20200123:162114.360 VMware monitoring: YES
    23273:20200123:162114.360 SMTP authentication: YES
    23273:20200123:162114.360 ODBC: YES
    23273:20200123:162114.360 SSH2 support: YES
    23273:20200123:162114.360 IPv6 support: YES
    23273:20200123:162114.360 TLS support: YES
    23273:20200123:162114.360 ******************************
    23273:20200123:162114.360 using configuration file: /etc/zabbix/zabbix_server.conf
    23273:20200123:162114.363 current database version (mandatory/optional): 04030035/04030035
    23273:20200123:162114.364 required mandatory version: 04040000
    23273:20200123:162114.364 starting automatic database upgrade
    23273:20200123:162114.364 [Z3005] query failed: [1091] Can't DROP FOREIGN KEY `c_host_inventory_1`; check that it exists [alter table host_inventory drop foreign key c_host_inventory_1]
    23273:20200123:162114.364 database upgrade failed

    Завалил огромный сервер мониторинга, выручайте!
  • wakeon
    Junior Member
    • Nov 2018
    • 6

    #2
    Code:
     
     alter table host_inventory ADD CONSTRAINT `c_host_inventory_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE
    Попробуйте

    Comment

    • zawex6
      Junior Member
      • Jan 2018
      • 9

      #3
      Спасибо большое, помогло!

      Comment

      Working...