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

Cannot upgrade MySQL database

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.1.1
    • Fix Version/s: 2.1.2
    • Component/s: Installation (I)
    • Labels:
    • Environment:
      MySQL v5.5.32
      sql_mode = STRICT_ALL_TABLES

      Description

      SQL error occurred when upgrading database from 2.0.x to 2.1.x:

      11847:20130801:113511.539 query [txnlev:1] [begin;]
      11847:20130801:113511.539 query [txnlev:1] [alter table httptest change column macros variables text default '' not null]
      11847:20130801:113511.539 [Z3005] query failed: [1101] BLOB/TEXT column 'variables' can't have a default value [alter table httptest change column macros variables text default '' not null]
      11847:20130801:113511.539 query [alter table httptest change column macros variables text default '' not null] failed, setting transaction as failed
      11847:20130801:113511.540 query [txnlev:1] [rollback;]
      11847:20130801:113511.540 database upgrade failed
      11847:20130801:113511.540 End of DBcheck_version():FAIL

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            sasha Alexander Vladishev
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: