Re: Error during upgrade from 1.7.6 to 2.0.12
Glad it works! - Christian -- Christian Hammond - christ...@beanbaginc.com Review Board - http://www.reviewboard.org Beanbag, Inc. - http://www.beanbaginc.com On Thu, Jan 29, 2015 at 12:29 AM, Łukasz Koniecki wrote: > 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 >> Review Board - http://www.reviewboard.org >> Beanbag, Inc. - http://www.beanbaginc.com >> >> On Wed, Jan 28, 2015 at 1:52 PM, Łukasz Koniecki >> 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. >>> >>> -- -- >>> 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. >>> >>> -- -- >>> 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. >>> 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. > -- 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 y
Re: Error during upgrade from 1.7.6 to 2.0.12
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 > Review Board - http://www.reviewboard.org > Beanbag, Inc. - http://www.beanbaginc.com > > On Wed, Jan 28, 2015 at 1:52 PM, Łukasz Koniecki > 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. >> >> -- -- >> 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. >> >> -- -- >> 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 . >> 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.
Re: Error during upgrade from 1.7.6 to 2.0.12
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 - christ...@beanbaginc.com Review Board - http://www.reviewboard.org Beanbag, Inc. - http://www.beanbaginc.com On Wed, Jan 28, 2015 at 1:52 PM, Łukasz Koniecki 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. > > -- -- > 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. > > -- -- > 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+unsubscr...@googlegroups.com. > 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.
