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

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

    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

          duplicates

          Problem report - Problem report ZBX-11203 database upgrade from Zabbix 3.0 to Zabbix 3.2 fails

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: