-
Incident report
-
Resolution: Won't fix
-
Blocker
-
None
-
1.9.9 (beta)
-
I have tried 3 servers:
S1&S2 2xXeon @2.8Ghz, 8GB RAM, RAID10, Mysql+InnoDB (Debian Stable 64bit, Mysql server 5.1.49-3, Apache2 2.2.16-6+squeeze6, PHP5 5.3.3-7+squeeze8)
S3 Intel Core 3 Quad 8300 @2.5Ghz, 4GB RAM, RAID10, Mysql+InnoDB (Debian Testing 64bit, Mysql server 5.1.58-1, Apache2 2.2.22-1, PHP5 5.3.10-2)I have tried 3 servers: S1&S2 2xXeon @2.8Ghz, 8GB RAM, RAID10, Mysql+InnoDB (Debian Stable 64bit, Mysql server 5.1.49-3, Apache2 2.2.16-6+squeeze6, PHP5 5.3.3-7+squeeze8) S3 Intel Core 3 Quad 8300 @2.5Ghz, 4GB RAM, RAID10, Mysql+InnoDB (Debian Testing 64bit, Mysql server 5.1.58-1, Apache2 2.2.22-1, PHP5 5.3.10-2)
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
- is duplicated by
-
ZBX-4728 Availability report don't work
- Closed