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

Cannot upgrade MySQL database

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Critical Critical
    • 2.1.2
    • 2.1.1
    • Installation (I)
    • MySQL v5.5.32
      sql_mode = STRICT_ALL_TABLES

      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

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

              Created:
              Updated:
              Resolved: