I just ran into the same problem upgrading from 2.0.6 to 2.0.8. Running postgres as well
In prostgres dropping the index is achieved by: DROP index scmtools_repository_8c446842; running rb-site upgrade again after that completed successfully On Tuesday, 16 September 2014 13:44:48 UTC+12, Christian Hammond wrote: > > Hmmm, it should have tried to drop the old index in that upgrade. Very > odd. > > What version were you running before this? > > (I have to take off for a couple hours, but will be back.. hopefully the > other instructions will have helped.) > > Christian > > -- > Christian Hammond - chri...@beanbaginc.com <javascript:> > Review Board - https://www.reviewboard.org > Beanbag, Inc. - https://www.beanbaginc.com > > > On September 15, 2014 at 6:43:27 PM, Ian (iand...@mac.com <javascript:>) > wrote: > > Upgraded from 2.0.6 and using PostgreSQL. > > > > $ sudo rb-site manage /Library/Server/Web/Data/WebApps/ReviewBoard > evolve > > -- --sql > > > > Password: > > > > > > -- Evolve application scmtools > > > > ALTER TABLE "scmtools_repository" ADD COLUMN "hooks_uuid" varchar(32) > NULL; > > > > CREATE UNIQUE INDEX scmtools_repository_8c446842 ON scmtools_repository > > ("archived_timestamp", "path", "local_site_id"); > > > > CREATE UNIQUE INDEX scmtools_repository_f22c3cf5 ON scmtools_repository > > ("hooks_uuid", "local_site_id"); > > > > On Monday, September 15, 2014 6:40:21 PM UTC-7, Christian Hammond wrote: > > > > > > What version did you upgrade from? > > > > > > That looks like it may be a duplicate index. > > > > > > Can you run: > > > > > > rb-site manage /path/to/site evolve -- --sql > > > > > > And show me what that says? > > > > > > Also, are you using MySQL? > > > > > > Christian > > > > > > -- > > > Christian Hammond - chri...@beanbaginc.com > > > Review Board - https://www.reviewboard.org > > > Beanbag, Inc. - https://www.beanbaginc.com > > > > > > > > > On September 15, 2014 at 6:37:05 PM, Ian (iand...@mac.com ) > > > wrote: > > > > I did the easy_install -U thing to update Review Board, and then the > > > > rb-side upgrade thing to upgrade my site. I get this output though, > and > > > > now I can't view anything in Review Board. Any workarounds much > > > > appreciated! > > > > > > > > $ sudo rb-site upgrade /Library/Server/Web/Data/WebApps/ReviewBoard > > > > > > > > Password: > > > > > > > > Rebuilding directory structure > > > > > > > > Updating database. This may take a while. > > > > > > > > > > > > The log output below, including warnings and errors, > > > > > > > > can be ignored unless upgrade fails. > > > > > > > > > > > > ------------------ ------------------ > > > > > > > > Creating tables ... > > > > > > > > There are unapplied evolutions for scmtools. > > > > > > > > Project signature has changed - an evolution is required > > > > > > > > Installing custom SQL ... > > > > > > > > Installing indexes ... > > > > > > > > Installed 0 object(s) from 0 fixture(s) > > > > > > > > *CommandError: Error applying evolution: relation > > > > "scmtools_repository_8c446842" already exists* > > > > > > > > -- > > > > Get the Review Board Power Pack at > http://www.reviewboard.org/powerpack/ > > > > --- > > > > Sign up for Review Board hosting at RBCommons: > https://rbcommons.com/ > > > > --- > > > > Happy user? Let us know at http://www.reviewboard.org/users/ > > > > --- > > > > You received this message because you are subscribed to the Google > > > Groups "reviewboard" > > > > group. > > > > To unsubscribe from this group and stop receiving emails from it, > send > > > an email to reviewboard...@googlegroups.com . > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > > > > > -- > > Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/ > > --- > > Sign up for Review Board hosting at RBCommons: https://rbcommons.com/ > > --- > > Happy user? Let us know at http://www.reviewboard.org/users/ > > --- > > You received this message because you are subscribed to the Google > Groups "reviewboard" > > group. > > To unsubscribe from this group and stop receiving emails from it, send > an email to reviewboard...@googlegroups.com <javascript:>. > > For more options, visit https://groups.google.com/d/optout. > > > > -- Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/ --- Sign up for Review Board hosting at RBCommons: https://rbcommons.com/ --- Happy user? Let us know at http://www.reviewboard.org/users/ --- You received this message because you are subscribed to the Google Groups "reviewboard" group. To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.