Hi Cory,
My apologies for the delay.
What likely happened is that you ended up with a mix of MyISAM and InnoDB
tables. The new MySQL server is likely defaulting to InnoDB, whereas your
dump is likely MyISAM. You'll need to fix up the dump to replace all MyISAM
instances with InnoDB.
You'd then need to re-import the dump. It should work this time.
Christian
--
Christian Hammond - chip...@chipx86.com
Review Board - http://www.reviewboard.org
Beanbag, Inc. - http://www.beanbaginc.com
On Thu, Nov 6, 2014 at 8:14 AM, Cory Demerau wrote:
> I'm migrating a 1.6.16 RB site to a new server that's running RB 2.0.11. I
> created a dump of the mysql database with --max_allowed_packet=512M to
> minimize the chance of incomplete data. I modified the dump so that all
> tables use InnoDB instead of MyISAM, and restored the reviewboard database
> on the new server using the dump. I have Django_Evolution version 0.7.4,
> and when I try to do an rb-site upgrade, I get the following 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: (1005, "Can't create table
> 'reviewboard.#sql-3f22_1e8' (errno: 150)")
>
>
> I have also tried (before running rb-site upgrade, but after restoring the
> database) rb-site manage /path/to/site syncdb. This gives the following
> output:
>
> Creating tables ...
> Creating table extensions_registeredextension
> Creating table diffviewer_filediffdata
> Upgrading Review Board from 1.6.16 to 2.0.11
> There are unapplied evolutions for auth.
> The following content types are stale and need to be deleted:
>
> auth | message
>
> Any objects related to these content types by a foreign key will also
> be deleted. Are you sure you want to delete these content types?
> If you're unsure, answer 'no'.
>
> Type 'yes' to continue, or 'no' to cancel:
>
> If I type 'yes':
>
> 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)
>
>
> After completing this, there is still no change in the output from rb-site
> upgrade. In the meantime, the Reviewboard site allows me to access some
> pages, but most return a 500 error.
>
> --
> 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.
