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

database upgrade fails from 3.5 to 4.0

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 4.0.0
    • Frontend (F)
    • None
    • Redhat 7.5

      Steps to reproduce:

      1. Changes in configuration... upgrade from 3.5 to 4.0
      2. ...

      Result:
      See screenshot...
      See log file...

      query [txnlev:0] [show tables like 'dbversion']
      query [txnlev:0] [select mandatory,optional from dbversion]
      current database version (mandatory/optional): 03050097/03050097
      required mandatory version: 04000000
      starting automatic database upgrade
      query [txnlev:1] [begin;]
      query [txnlev:1] [alter table `functions` change column `function` `name` varchar(12) default '' not null]
      [Z3005] query failed: [1054] Unknown column 'function' in 'functions' [alter table `functions` change column `function` `name` varchar(12) default '' not null]
      query [alter table `functions` change column `function` `name` varchar(12) default '' not null] failed, setting transaction as failed
      query [txnlev:1] [rollback;]
      database upgrade failed
      End of DBcheck_version():FAIL

      See memory dump...
      Expected:
      See screenshot....
      See attached patch file...

            Unassigned Unassigned
            ravig Ravi
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: