I ran into the issue as well. Upgraded from 2.0.6 to 2.0.8 with postgres (seems to be the common theme). The steps listed by Christian Wuerdig resolved things.
On Thursday, September 25, 2014 4:10:07 PM UTC-4, Christian Wuerdig wrote: > > 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 >> 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) 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. >> > 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.
