Patch.sql 1.6.8 -> 1.8.1 : "Duplicate key name" error

[befortin]

Hi,

I'm having some issues, trying to upgrade from Zabbix 1.6.8 to Zabbix 1.8.1.

I'm following the upgrade procedure (http://www.zabbix.com/documentation/...tion/upgrading) step-by-step, and here's what happens :

1. When I try to drop the actions_1 index :

"mysql> alter table actions drop index actions_1;
ERROR 1091 (42000): Can't DROP 'actions_1'; check that column/key exists"

2. Then, when running the patch :

root@srvcgimon:/home/ce42999/zabbix-1.8.1/upgrades/dbpatches/1.8/mysql# mysql -uroot -ppassword zabbix < patch.sql
ERROR 1061 (42000) at line 1: Duplicate key name 'actions_1'

How is this possible!?

Thanks!

[richlv]

altering the same database on the same server in the first step ?

[alj]

Hi,

I'm having some issues, trying to upgrade from Zabbix 1.6.8 to Zabbix 1.8.1.

I'm following the upgrade procedure (http://www.zabbix.com/documentation/...tion/upgrading) step-by-step, and here's what happens :

1. When I try to drop the actions_1 index :

"mysql> alter table actions drop index actions_1;
ERROR 1091 (42000): Can't DROP 'actions_1'; check that column/key exists"

2. Then, when running the patch :

root@srvcgimon:/home/ce42999/zabbix-1.8.1/upgrades/dbpatches/1.8/mysql# mysql -uroot -ppassword zabbix < patch.sql
ERROR 1061 (42000) at line 1: Duplicate key name 'actions_1'

How is this possible!?

Thanks!

it is possible if you didn't do "use zabbix" during first step.

[befortin]

Thanks!

Actually, I don't know what went wrong at first... So I restored the database, converted it to UTF-8 (took about 20 hours on a dual CPU, 8 GB server!!, and then converted the database to 1.8.1 (successfully).

[alj]

Thanks!

Actually, I don't know what went wrong at first... So I restored the database, converted it to UTF-8 (took about 20 hours on a dual CPU, 8 GB server!!, and then converted the database to 1.8.1 (successfully).

You probably interrupted patch.sql and tried to run it 2-nd time. It doesn't work unless you restart patch.sql where it stopped (just delete line that generates error + all lines above it).

About 20 hour conversion - read this thread

http://www.zabbix.com/forum/showthread.php?t=15521

if you patch sh script it takes rather 20 minutes instead of 20 hours, which makes me think that developers don't really have big history database to test those kind of things. In my case it would take days to convert it assuming i had free disk space to alter huge tables.