3593: Upgrade from 2.0.6 to 2.0.8 fails due to creation of index that already exists

michal.e********@gmai***** (Google Code) (Is this you? Claim this profile.)
Jan. 18, 2015 
What version are you running?
2.0.6

What's the URL of the page containing the problem?
no url related problem

What steps will reproduce the problem?
1. Install rb 2.0.6.
2. Add two repositories
3. Upgrade to 2.0.8.

What is the expected output? What do you see instead?
upgrade should succeed, but it fails with a message saying that it cannot create index which already exists - scmtools_repository_8c446842.

What operating system are you using? What browser?
Ubuntu 14.04 LTS
DB on PostgreSQL

Please provide any additional information below.
Please verify upgrade scripts.
chipx86
#1 chipx86 
Happen to have a backup of the database prior to upgrade? I need a schema dump from it in order to properly diagnose this.
  • +NeedInfo
#2 michal.e********@gmai***** (Google Code) (Is this you? Claim this profile.) 
Unfortunately not. I don't even remember which version was I upgrading from :/
However, if I may suggest - verify if any previous versions prior to 2.0.8 had the possibility to create this index. If so, in the upgrade script, if the index exists, drop and rebuild it or do nothing.
david
#3 david
  • -NeedInfo
    +Incomplete