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

can't patch 1.8.10 DB to 1.9.9

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Won't fix
    • Affects Version/s: 1.9.9 (beta)
    • Fix Version/s: None
    • Component/s: Installation (I)
    • Labels:
    • Environment:

      Description

      patch to 2.0 db don't work>

      [email protected]:/home/zabbix/zabbix-1.9.9/upgrades/dbpatches/2.0/mysql# ./upgrade zabbix
      WARNING: backup your database before performing upgrade

      This is an UNSUPPORTED Zabbix upgrade script from 1.8 to 2.0 for MySQL
      It does the following things:
      1. Updates indexes that might require changes;
      2. Patches the database from 1.8 schema to 2.0 schema;
      3. Adds 'Disabled' and 'Debug' usergroup if any missing;
      4. Checks for hosts not belonging to any group and adds them to one if any found.

      Usage: pass required MySQL parameters to this script (like database, user, password etc).

      Continue ? (y/n) y
      Dropping indexes that might need re-creation...
      ... dropping of indexes took 0:00:00
      Creating possibly missing indexes...
      creating of indexes took 0:00:00
      Patching the database
      ERROR 1091 (42000) at line 136: Can't DROP 'escalations_2'; check that column/key exists
      Failed to patch Zabbix database. Restore from backup

      [email protected]:/home/zabbix/zabbix-1.9.9/upgrades/dbpatches/2.0/mysql# ./upgrade zabbix
      WARNING: backup your database before performing upgrade

      This is an UNSUPPORTED Zabbix upgrade script from 1.8 to 2.0 for MySQL
      It does the following things:
      1. Updates indexes that might require changes;
      2. Patches the database from 1.8 schema to 2.0 schema;
      3. Adds 'Disabled' and 'Debug' usergroup if any missing;
      4. Checks for hosts not belonging to any group and adds them to one if any found.

      Usage: pass required MySQL parameters to this script (like database, user, password etc).

      Continue ? (y/n) y
      Dropping indexes that might need re-creation...
      ... dropping of indexes took 0:00:00
      Creating possibly missing indexes...
      creating of indexes took 0:00:00
      Patching the database
      ERROR 1005 (HY000) at line 6: Can't create table 'zabbix.#sql-6b2b_a6' (errno: 121)
      Failed to patch Zabbix database. Restore from backup

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              coudy Coudy
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: