On Fri, Jan 15, 2016 at 11:04 PM, Christian Hammond <christ...@beanbaginc.com> wrote: > Hi Ben, > > This is due to a mismatch between MySQL table types. The existing tables are > likely MyISAM, with MySQL now defaulting to InnoDB for new ones. You'll need > to either migrate all the existing tables, or tell MySQL to use the existing > type for new tables. > > (It's a pretty terrible error, but unfortunately, beyond our control. I just > recognize this sort of problem.)
Argh. Our systems usually have InnoDB as default, guess that isn't the case when we originally had Reviewboard provisioned. I shouldn't see any issues migrating all tables into InnoDB correct? > > Christian Cheers, Ben > > -- > Christian Hammond - christ...@beanbaginc.com > Review Board - https://www.reviewboard.org > Beanbag, Inc. - https://www.beanbaginc.com > > On Thu, Jan 14, 2016 at 11:27 PM, Ben Cooksley <bcooks...@kde.org> wrote: >> >> Hi everyone, >> >> While upgrading from Reviewboard 2.0.17 to 2.5.2 i've encountered a >> few SQL errors. >> Reviewboard itself appears to boot and run fine though, based on the >> nature of the errors I suspect it's a case of index name collisions. >> >> Output from the upgrade process is below: >> >> (virtualenv)reviewboard@mimi:~$ rb-site upgrade >> /srv/www/reviewboard/git.reviewboard.kde.org/ >> 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 ... >> Creating table accounts_trophy >> >> [!] There was an error synchronizing the database. Make sure the >> database is created and has the appropriate permissions, and then >> continue. >> [!] Details: (1005, "Can't create table 'reviewboard_git.#sql- >> 331d_214215' (errno: 150)") >> >> Press Enter to continue >> Creating tables ... >> Creating table attachments_fileattachmenthistory >> Creating table diffviewer_rawfilediffdata >> Creating table notifications_webhooktarget_repositories >> >> [!] There was an error synchronizing the database. Make sure the >> database is created and has the appropriate permissions, and then >> continue. >> [!] Details: (1005, "Can't create table 'reviewboard_git.#sql- >> 331d_214215' (errno: 150)") >> >> Press Enter to continue >> Creating tables ... >> Creating table notifications_webhooktarget >> >> [!] There was an error synchronizing the database. Make sure the >> database is created and has the appropriate permissions, and then >> continue. >> [!] Details: (1005, "Can't create table 'reviewboard_git.#sql- >> 331d_214215' (errno: 150)") >> >> Press Enter to continue >> Creating tables ... >> Creating table webapi_webapitoken >> >> [!] There was an error synchronizing the database. Make sure the >> database is created and has the appropriate permissions, and then >> continue. >> [!] Details: (1005, "Can't create table 'reviewboard_git.#sql- >> 331d_214215' (errno: 150)") >> >> Press Enter to continue >> Creating tables ... >> Upgrading Review Board from 2.0.17 to 2.5.2 >> There are unapplied evolutions for accounts. >> There are unapplied evolutions for attachments. >> There are unapplied evolutions for diffviewer. >> There are unapplied evolutions for notifications. >> There are unapplied evolutions for reviews. >> There are unapplied evolutions for webapi. >> Adding baseline version for new models >> Evolutions in notifications baseline: webhooktarget_extra_state, >> webhooktarget_extra_data_null >> 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_git.#sql-331d_214238' (errno: 150)") >> >> Any pointers? >> >> Cheers, >> Ben Cooksley >> KDE Sysadmin >> >> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "reviewboard-dev" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to reviewboard-dev+unsubscr...@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. > > > -- > > --- > You received this message because you are subscribed to the Google Groups > "reviewboard-dev" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to reviewboard-dev+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.