Do you have a dump of the database pre-upgrade? I need someone to provide this in order to fix the problem for good.
Christian On Wednesday, October 15, 2014, Erik Lattimore <erik.l...@gmail.com> wrote: > 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 > <javascript:_e(%7B%7D,'cvml','reviewboard%2bunsubscr...@googlegroups.com');> > . > For more options, visit https://groups.google.com/d/optout. > -- -- Christian Hammond - christ...@beanbaginc.com Review Board - http://www.reviewboard.org Beanbag, Inc. - http://www.beanbaginc.com -- 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.