Type: Incident report
Resolution: Unsupported version
Affects Version/s: 1.8.17, 2.0.8
Fix Version/s: None
Component/s: Server (S)
Environment:Ubuntu 12.04, MySQL 5.5.31 (distribution package), Node based Setup (two nodes), 6 proxies
We are trying to perform a upgrade from 1.8.17 to 2.0.8 and we experience problems while applying the database patch.
We performed the upgrade like described in:
While executing the "patch.sql" we get the following message:
The problem is caused by the following statement:
I analyzed the table "items_applications":
All rows which might cause problems with the unique index created by the migration script seems to have:
- exactly two duplicates
- all duplicate entries are looking like the output of the second statement (they have a leading 1001 and 2002 in column "itemappid")
I removed "DROP INDEX items_applications_1.. " and "CREATE UNIQUE INDEX items_applications_1..." from "patch.sql" and kept the existing non-unique index on "applicationid" and "itemid".
Is it really needed to have a unique index here? What can be a solution for this conflict?
Please contact me - i can support you in examining the situation.