Hi Christian,

Converting tables to InnoDB fixed the problem. 

Thank you for a quick help!

Regards,
Luke

W dniu czwartek, 29 stycznia 2015 01:17:11 UTC+1 użytkownik Christian 
Hammond napisał:
>
> Hi Lukasz,
>
> This is usually caused by an existing database with MyISAM tables, and 
> MySQL wanting to create new InnoDB tables. The error is really confusing, 
> but is often times due to incompatibilities creating indexes between these 
> two table types. What I'd recommend is reverting to your database 
> pre-upgrade, then converting all MyISAM tables to InnoDB, and then 
> attempting the upgrade.
>
> Christian
>
> -- 
> Christian Hammond - chri...@beanbaginc.com <javascript:>
> Review Board - http://www.reviewboard.org
> Beanbag, Inc. - http://www.beanbaginc.com
>
> On Wed, Jan 28, 2015 at 1:52 PM, Łukasz Koniecki <lukasz....@gmail.com 
> <javascript:>> wrote:
>
>> Hi,
>>
>> I have an error during the database upgrade:
>>
>> $ sudo rb-site upgrade /var/www/reviewboard
>> Rebuilding directory structure
>> Updating database. This may take a while.
>>
>> The log output below, including warnings and errors,
>> can be ignored unless upgrade fails.
>>
>> ------------------ <begin log output> ------------------
>> Creating tables ...
>> Upgrading Review Board from 1.7.6 to 2.0.12
>> There are unapplied evolutions for auth.
>> There are unapplied evolutions for contenttypes.
>> There are unapplied evolutions for accounts.
>> There are unapplied evolutions for attachments.
>> There are unapplied evolutions for changedescs.
>> There are unapplied evolutions for diffviewer.
>> There are unapplied evolutions for hostingsvcs.
>> There are unapplied evolutions for reviews.
>> There are unapplied evolutions for scmtools.
>> There are unapplied evolutions for site.
>> Adding baseline version for new models
>> 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: (1005, "Can't create table 
>> 'reviewboard.#sql-36c_63' (errno: 150)")
>>
>> If I run the rb-site upgrade command second time I'm getting different 
>> error:
>>
>> $ sudo rb-site upgrade /var/www/reviewboard
>> Rebuilding directory structure
>> Updating database. This may take a while.
>>
>> The log output below, including warnings and errors,
>> can be ignored unless upgrade fails.
>>
>> ------------------ <begin log output> ------------------
>> Creating tables ...
>> There are unapplied evolutions for auth.
>> There are unapplied evolutions for contenttypes.
>> There are unapplied evolutions for accounts.
>> There are unapplied evolutions for attachments.
>> There are unapplied evolutions for changedescs.
>> There are unapplied evolutions for diffviewer.
>> There are unapplied evolutions for hostingsvcs.
>> There are unapplied evolutions for reviews.
>> There are unapplied evolutions for scmtools.
>> There are unapplied evolutions for site.
>> 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: (1060, "Duplicate column name 
>> 'permissions'")
>>
>> I have VM snapshot from before the upgrade so I can re-run the upgrade.
>>
>> Any suggestions/ideas?
>>
>> Thanks in advance
>> Lukasz Koniecki
>>
>> -- 
>> Supercharge your Review Board with Power Pack: 
>> https://www.reviewboard.org/powerpack/
>> Want us to host Review Board for you? Check out RBCommons: 
>> https://rbcommons.com/
>> Happy user? Let us know! https://www.reviewboard.org/users/
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "reviewboard" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to reviewboard...@googlegroups.com <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
Supercharge your Review Board with Power Pack: 
https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: 
https://rbcommons.com/
Happy user? Let us know! https://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.

Reply via email to