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

SQL Upgrade to 3.2.0 failed

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 3.0.4
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:

      Description

      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).

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: