Re: Help, upgrading to 2.0.7 broke my server!
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 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 Powe
Re: Help, upgrading to 2.0.7 broke my server!
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
Re: Help, upgrading to 2.0.7 broke my server!
Hi Christian, Any chance you have a database backup from before the upgrade? I'd like to figure out why this is breaking in django-evolution. Christian -- Christian Hammond - christ...@beanbaginc.com Review Board - https://www.reviewboard.org Beanbag, Inc. - https://www.beanbaginc.com On September 25, 2014 at 1:10:12 PM, Christian Wuerdig (christian.wuer...@gmail.com) 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 Bo
Re: Help, upgrading to 2.0.7 broke my server!
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.
Re: Help, upgrading to 2.0.7 broke my server!
Phew, that worked, thanks! Ian On Monday, September 15, 2014 6:45:50 PM UTC-7, Ian wrote: > > I was running 2.0.6. I'll try to figure out the PostgreSQL equivalent to > drop the index and try again. > > Ian > > On Monday, September 15, 2014 6:44:48 PM UTC-7, 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.
Re: Help, upgrading to 2.0.7 broke my server!
I was running 2.0.6. I'll try to figure out the PostgreSQL equivalent to drop the index and try again. Ian On Monday, September 15, 2014 6:44:48 PM UTC-7, 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.
Re: Help, upgrading to 2.0.7 broke my server!
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 - christ...@beanbaginc.com Review Board - https://www.reviewboard.org Beanbag, Inc. - https://www.beanbaginc.com On September 15, 2014 at 6:43:27 PM, Ian (iander...@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+unsubscr...@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.
Re: Help, upgrading to 2.0.7 broke my server!
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+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Help, upgrading to 2.0.7 broke my server!
Assuming MySQL, try connecting to the database using the mysql command line client and running this: show indexes from scmtools_repository; It will likely have scmtools_repository_8c446842 in the list. Try doing: alter table scmtools_repository drop index scmtools_repository_8c446842; Then try the upgrade again. If it complains about a duplicate field, you'll need to do the above again (if the index is still there) and: alter table scmtools_repository drop column hooks_uuid; And then repeat the upgrade. I'm curious if other people have hit this? We haven't hit it in our deployments. Christian -- Christian Hammond - christ...@beanbaginc.com Review Board - https://www.reviewboard.org Beanbag, Inc. - https://www.beanbaginc.com On September 15, 2014 at 6:40:18 PM, Christian Hammond (christ...@beanbaginc.com) 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 - christ...@beanbaginc.com > Review Board - https://www.reviewboard.org > Beanbag, Inc. - https://www.beanbaginc.com > > > On September 15, 2014 at 6:37:05 PM, Ian (iander...@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+unsubscr...@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.
Re: Help, upgrading to 2.0.7 broke my server!
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 - christ...@beanbaginc.com Review Board - https://www.reviewboard.org Beanbag, Inc. - https://www.beanbaginc.com On September 15, 2014 at 6:37:05 PM, Ian (iander...@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+unsubscr...@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.
Help, upgrading to 2.0.7 broke my server!
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+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.