As you can see above, most of my issues were related to indexes.
For example “quality_gates.uniq_quality_gates”, In this example, this is complaining about table name “quality_gates” and index name “uniq_quality_gates”. It’s joining the table name and index name with a “.”.
Where as my database had the same key defined as “quality_gates$uniq_quality_gates”. So when database migration was happening, it would complain key not found or permissions not correct.
So i had to go inside my database and correct the key’s.
I would rename my existing key “quality_gates$uniq_quality_gates” to “uniq_quality_gates”. This way when database upgrade would run, it would look for “quality_gates.uniq_quality_gates”. Where “quality
-gates” would be the table name and join that with my newly renamed key “uniq_quality_gates”.
Painful process for me but i had to do it. Once i took care off the key’s / Indexes, DB migration went fine.
1 Like