On Fri, Jan 15, 2016 at 11:09 PM, Ben Cooksley <[email protected]> wrote: > On Fri, Jan 15, 2016 at 11:04 PM, Christian Hammond > <[email protected]> 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?
Seems it is safe. Unfortunately it looks like one of the evolutions got part way through the process. CommandError: Error applying evolution: (1060, "Duplicate column name 'visibility'") Any suggestions (I could restore from backups, but if I can avoid it...)? > >> >> Christian > > Cheers, > Ben Thanks, Ben > >> >> -- >> Christian Hammond - [email protected] >> Review Board - https://www.reviewboard.org >> Beanbag, Inc. - https://www.beanbaginc.com >> >> On Thu, Jan 14, 2016 at 11:27 PM, Ben Cooksley <[email protected]> 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 [email protected]. >>> 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 [email protected]. >> 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
