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

SQL Upgrade to 3.2.0 failed

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • 3.0.4
    • Server (S)

      Database upgrade failed for Zabbix Server from 3.0.4 to 3.2.0 on Centos7.

      Fixed by adding the missing column "id" manually to table history_log drop column.

      11275:20160917:121335.359 current database version (mandatory/optional): 03010000/03010000
      11275:20160917:121335.359 required mandatory version: 03020000
      11275:20160917:121335.359 starting automatic database upgrade
      11275:20160917:121335.360 [Z3005] query failed: [1091] Can't DROP 'id'; check that column/key exists [alter table history_log drop column id]
      11275:20160917:121335.360 database upgrade failed
      11282:20160917:121345.495 Starting Zabbix Server. Zabbix 3.2.0 (revision 62485).

            Unassigned Unassigned
            Zimeon Antti Hurme
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: