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

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Blocker Blocker
    • None
    • 1.9.9 (beta)
    • Installation (I)

      patch to 2.0 db don't work>

      root@coudy:/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

      root@coudy:/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

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

              Created:
              Updated:
              Resolved: