Database upgrade failed to 3.4.4 ("alter table alerts add p_eventid bigint unsigned")

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Blocker
    • None
    • Affects Version/s: 3.4.4
    • Component/s: Server (S)
    • None

      39335:20171116:173839.702 Zabbix Server stopped. Zabbix 3.2.6 (revision 67849).
      42421:20171116:173902.182 Starting Zabbix Server. Zabbix 3.4.4 (revision 74338).
      42421:20171116:173902.185 ****** Enabled features ******
      42421:20171116:173902.185 SNMP monitoring: YES
      42421:20171116:173902.185 IPMI monitoring: YES
      42421:20171116:173902.185 Web monitoring: YES
      42421:20171116:173902.185 VMware monitoring: YES
      42421:20171116:173902.185 SMTP authentication: YES
      42421:20171116:173902.185 Jabber notifications: YES
      42421:20171116:173902.185 Ez Texting notifications: YES
      42421:20171116:173902.185 ODBC: YES
      42421:20171116:173902.185 SSH2 support: YES
      42421:20171116:173902.185 IPv6 support: YES
      42421:20171116:173902.185 TLS support: YES
      42421:20171116:173902.185 ******************************
      42421:20171116:173902.186 using configuration file: /etc/zabbix/zabbix_server.conf
      42421:20171116:173902.201 current database version (mandatory/optional): 03020000/03020000
      42421:20171116:173902.201 required mandatory version: 03040000
      42421:20171116:173902.201 optional patches were found
      42421:20171116:173902.201 starting automatic database upgrade
      42421:20171116:173902.490 completed 0% of database upgrade
      42421:20171116:173907.245 slow query: 4.696081 sec, "alter table items modify snmp_oid varchar(512) default '' not null"
      42421:20171116:173907.245 completed 1% of database upgrade
      42421:20171116:173907.576 completed 2% of database upgrade
      42421:20171116:173907.667 completed 3% of database upgrade
      42421:20171116:173907.705 completed 4% of database upgrade
      42421:20171116:173907.845 completed 5% of database upgrade
      42421:20171116:173907.977 completed 6% of database upgrade
      42421:20171116:173908.231 completed 7% of database upgrade
      42421:20171116:173908.306 completed 8% of database upgrade
      42421:20171116:173910.478 completed 9% of database upgrade
      42421:20171116:173914.983 slow query: 4.504362 sec, "alter table items drop column multiplier"
      42421:20171116:173919.440 slow query: 4.456142 sec, "alter table items drop column data_type"
      42421:20171116:173919.441 completed 10% of database upgrade
      42421:20171116:173922.887 slow query: 3.446336 sec, "alter table items drop column delta"
      42421:20171116:173924.123 completed 11% of database upgrade
      42421:20171116:173924.203 completed 12% of database upgrade
      42421:20171116:173924.216 completed 13% of database upgrade
      42421:20171116:174010.927 [Z3005] query failed: [1034] Incorrect key file for table 'alerts'; try to repair it [alter table alerts add p_eventid bigint unsigned]
      42421:20171116:174010.928 slow query: 46.711020 sec, "alter table alerts add p_eventid bigint unsigned"
      42421:20171116:174010.928 database upgrade failed
      42477:20171116:174021.058 Starting Zabbix Server. Zabbix 3.4.4 (revision 74338).
      42477:20171116:174021.058 ****** Enabled features ******
      42477:20171116:174021.058 SNMP monitoring: YES
      42477:20171116:174021.058 IPMI monitoring: YES
      42477:20171116:174021.059 Web monitoring: YES
      42477:20171116:174021.059 VMware monitoring: YES
      42477:20171116:174021.059 SMTP authentication: YES
      42477:20171116:174021.059 Jabber notifications: YES
      42477:20171116:174021.059 Ez Texting notifications: YES
      42477:20171116:174021.059 ODBC: YES
      42477:20171116:174021.059 SSH2 support: YES
      42477:20171116:174021.059 IPv6 support: YES
      42477:20171116:174021.059 TLS support: YES
      42477:20171116:174021.059 ******************************
      42477:20171116:174021.059 using configuration file: /etc/zabbix/zabbix_server.conf
      42477:20171116:174021.068 current database version (mandatory/optional): 03030026/03030026
      42477:20171116:174021.068 required mandatory version: 03040000
      42477:20171116:174021.068 optional patches were found
      42477:20171116:174021.068 starting automatic database upgrade
      42477:20171116:174107.840 [Z3005] query failed: [1034] Incorrect key file for table 'alerts'; try to repair it [alter table alerts add p_eventid bigint unsigned]
      42477:20171116:174107.840 slow query: 46.771856 sec, "alter table alerts add p_eventid bigint unsigned"
      42477:20171116:174107.841 database upgrade failed

            Assignee:
            Unassigned
            Reporter:
            Arthur Ivanov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: