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

4.0.5 to 4.2.1 database upgrade failed

    XMLWordPrintable

    Details

    • Type: Problem report
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 4.2.1
    • Fix Version/s: None
    • Component/s: Installation (I)
    • Labels:
      None
    • Environment:
      Centos 6.7

      Description

      Database upgrade failed like this .

      34705:20190517:170120.768 2: /app/zabbix/sbin/zabbix_server: poller #20 [got 7 values in 0.047905 sec, getting values](main+0x44b) [0x418ffb]
       34705:20190517:170120.768 1: /lib64/libc.so.6(__libc_start_main+0xfd) [0x3e6941ed1d]
       34705:20190517:170120.768 0: /app/zabbix/sbin/zabbix_server: poller #20 [got 7 values in 0.047905 sec, getting values]() [0x417bc9]
       34690:20190517:170129.001 Zabbix agent item "system.swap.size[,free]" on host "Zabbix server" failed: first network error, wait for 15 seconds
       34640:20190517:170134.825 Got signal [signal:15(SIGTERM),sender_pid:44842,sender_uid:0,reason:0]. Exiting ...
       34640:20190517:170134.958 syncing history data...
       34640:20190517:170134.958 syncing history data done
       34640:20190517:170134.958 syncing trend data...
       34640:20190517:170137.503 syncing trend data done
       34640:20190517:170137.519 Zabbix Server stopped. Zabbix 4.0.5 (revision 90164).
      5946:20190517:170918.254 Starting Zabbix Server. Zabbix 4.2.1 (revision 92832).
       5946:20190517:170918.255 ****** Enabled features ******
       5946:20190517:170918.255 SNMP monitoring: YES
       5946:20190517:170918.255 IPMI monitoring: NO
       5946:20190517:170918.255 Web monitoring: YES
       5946:20190517:170918.255 VMware monitoring: YES
       5946:20190517:170918.255 SMTP authentication: NO
       5946:20190517:170918.255 Jabber notifications: NO
       5946:20190517:170918.255 Ez Texting notifications: YES
       5946:20190517:170918.255 ODBC: NO
       5946:20190517:170918.255 SSH2 support: NO
       5946:20190517:170918.255 IPv6 support: NO
       5946:20190517:170918.255 TLS support: NO
       5946:20190517:170918.255 ******************************
       5946:20190517:170918.255 using configuration file: /app/zabbix/etc/zabbix_server.conf
       5946:20190517:170918.262 current database version (mandatory/optional): 04000000/04000003
       5946:20190517:170918.262 required mandatory version: 04020000
       5946:20190517:170918.262 starting automatic database upgrade
       5946:20190517:170918.449 completed 3% of database upgrade
       5946:20190517:170918.450 completed 7% of database upgrade
       5946:20190517:170918.747 completed 10% of database upgrade
       5946:20190517:170918.948 completed 14% of database upgrade
       5946:20190517:170918.976 completed 17% of database upgrade
       5946:20190517:170918.980 completed 21% of database upgrade
       5946:20190517:170919.009 completed 25% of database upgrade
       5946:20190517:170919.086 completed 28% of database upgrade
       5946:20190517:170919.091 completed 32% of database upgrade
       5946:20190517:170919.096 completed 35% of database upgrade
       5946:20190517:170919.107 completed 39% of database upgrade
       5946:20190517:170919.884 completed 42% of database upgrade
       5946:20190517:170919.894 completed 46% of database upgrade
       5946:20190517:170919.895 completed 50% of database upgrade
       5946:20190517:170919.896 completed 53% of database upgrade
       5946:20190517:170919.897 completed 57% of database upgrade
       5946:20190517:170919.966 completed 60% of database upgrade
       5946:20190517:170919.998 completed 64% of database upgrade
       5946:20190517:170919.999 [Z3005] query failed: [1091] Can't DROP 'c_dchecks_1'; check that column/key exists [alter table dchecks drop foreign key c_dchecks_1]
       5946:20190517:170919.999 database upgrade failed

        Attachments

          Activity

            People

            Assignee:
            agavrilovs Aleksandrs Petrovs-Gavrilovs
            Reporter:
            xiaoxue999 jhwangpin
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: