mysql Upgrade Script (1.8.12 to 2.0.0rc4) fails

[gigatec]

Hi,

just tried to upgrade my 1.8.12 installation to 2.0.0rc4.

Unfortunately the database migration script throws errors:

root@server01:/compile/zabbix2/upgrades/dbpatches/2.0/mysql# ./upgrade
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
Patching the database
... patching of the database took 0:06:54
bash >= 4.1 detected
Checking for 'Disabled' user group... found, not doing anything.
Checking for 'Debug' user group... not found, adding.
Checking for hosts not belonging to any group... found.
Group 'none' does not exist, creating it and adding all orphaned hosts to it.
./upgrade: Zeile 58: 100100000000016
200100000000002+1: Syntaxfehler im Ausdruck. (Fehlerverursachendes Zeichen ist \"200100000000002+1\").
./upgrade: Zeile 63: 100100000000016
200100000000002+1: Syntaxfehler im Ausdruck. (Fehlerverursachendes Zeichen ist \"200100000000002+1\").
./upgrade: Zeile 58: 100100000000103
200100000000002+1: Syntaxfehler im Ausdruck. (Fehlerverursachendes Zeichen ist \"200100000000002+1\").
./upgrade: Zeile 63: 100100000000103
200100000000002+1: Syntaxfehler im Ausdruck. (Fehlerverursachendes Zeichen ist \"200100000000002+1\").
./upgrade: Zeile 58: 100100000000103
200100000000002+1: Syntaxfehler im Ausdruck. (Fehlerverursachendes Zeichen ist \"200100000000002+1\").
./upgrade: Zeile 63: 100100000000103
200100000000002+1: Syntaxfehler im Ausdruck. (Fehlerverursachendes Zeichen ist \"200100000000002+1\").
ERROR 1062 (23000) at line 1: Duplicate entry '0' for key 'PRIMARY'
Added 2 hosts to group 'none'. Move them to correct groups manually.
... checking for hosts not belonging to any group took 0:00:01

I run a multinode setup with two nodes. What's going wrong here?

Any help welcome, thx & regards
Stephan

PS - I've read the part about the script being unsupported ,-)

[zalex_ua]

root@server01:/compile/zabbix2/upgrades/dbpatches/2.0/mysql# ./upgrade
...
Usage: pass required MySQL parameters to this script (like database, user, password etc).
...

Use:
./upgrade -u<username> -p<password> <databasename>

[gigatec]

Sorry - I missed that point - I've added the credentials, database and host to the script to speed up testing.

Except these errors the migration works.

[gigatec]

Still the same with rc6.

[dotneft]

What are mysql server version you using?

[gigatec]

It's Server Version: 5.1.61-0+squeeze1-log

But without the upgrade-script, only patching with the SQL statement file the update process works.

2.0.0 is up and running here :-)