Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Won't fix
    • Affects Version/s: 3.4.0alpha1
    • Fix Version/s: None
    • Component/s: Proxy (P), Server (S)
    • Labels:

      Description

      Upgrade from database version (mandatory/optional): 03030014/03030014
      to required mandatory version: 03030022 fails with impossible error

       18970:20170119:135822.518 Starting Zabbix Server. Zabbix 3.3.0 (revision {ZABBIX_REVISION}).
       18970:20170119:135822.518 ****** Enabled features ******
       18970:20170119:135822.518 SNMP monitoring:            NO
       18970:20170119:135822.518 IPMI monitoring:            NO
       18970:20170119:135822.518 Web monitoring:            YES
       18970:20170119:135822.518 VMware monitoring:         YES
       18970:20170119:135822.518 SMTP authentication:       YES
       18970:20170119:135822.518 Jabber notifications:       NO
       18970:20170119:135822.518 Ez Texting notifications:  YES
       18970:20170119:135822.518 ODBC:                       NO
       18970:20170119:135822.518 SSH2 support:               NO
       18970:20170119:135822.518 IPv6 support:               NO
       18970:20170119:135822.518 TLS support:                NO
       18970:20170119:135822.518 ******************************
       18970:20170119:135822.518 using configuration file: /etc/zabbix/zabbix_server.conf
       18970:20170119:135822.521 current database version (mandatory/optional): 03030014/03030014
       18970:20170119:135822.521 required mandatory version: 03030022
       18970:20170119:135822.521 starting automatic database upgrade
       18970:20170119:135822.541 completed 12% of database upgrade
       18970:20170119:135822.557 completed 25% of database upgrade
       18970:20170119:135822.596 completed 37% of database upgrade
      zabbix_server [18970]: ERROR [file:db.c,line:2035] Something impossible has just happened.
      

      Next launch

       19335:20170119:140733.033 current database version (mandatory/optional): 03030017/03030017
       19335:20170119:140733.033 required mandatory version: 03030022
       19335:20170119:140733.033 starting automatic database upgrade
      zabbix_server [19335]: ERROR [file:db.c,line:2035] Something impossible has just happened.
      

      Seems related to https://support.zabbix.com/browse/ZBXNEXT-1443

      static int	DBpatch_3030017(void)
      {
      	const ZBX_FIELD	field = {"itemid", NULL, "items", "itemid", 0, 0, 0, ZBX_FK_CASCADE_DELETE};
      
      	return DBadd_foreign_key("item_preproc", 1, &field);
      }
      

      my.cnf
      [mysqld]
      sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              vso Vladislavs Sokurenko
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: