Re: Help, upgrading to 2.0.7 broke my server!

2014-10-15 Thread Christian Hammond
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!

2014-10-15 Thread Erik Lattimore
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!

2014-09-25 Thread Christian Hammond
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!

2014-09-25 Thread Christian Wuerdig
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!

2014-09-15 Thread Ian
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!

2014-09-15 Thread Ian
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!

2014-09-15 Thread Christian Hammond
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!

2014-09-15 Thread Ian
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!

2014-09-15 Thread Christian Hammond
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!

2014-09-15 Thread Christian Hammond
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!

2014-09-15 Thread Ian
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.