Hi Christian, Yeah, sorry, I took it through a few versions before calling for help. The killed upgrade was 1.7.21 to 2.0.2. I'm willing to do the manual surgery--I've got the MySQL manual open--but I don't know where to start. My first thought was to create a new 2.0.2 installation and database and then take it table by table. If there's a way I can hijack the rb-site upgrade process, though, I'd prefer that option.
Thanks, Andrew On Jul 1, 2014, at 1:52 PM, Christian Hammond <[email protected]<mailto:[email protected]>> wrote: Hi Andrew, At what point did it hang? This looks very much like the process was killed while it was performing database migrations, which is not something you can easily recover from without a lot of manual surgery. You said you upgraded from 1.7.21 to 2.0.2, but that log is showing 2.0 to 2.0.2, with a handful of unapplied evolutions that I would only expect if coming from 1.7.21. Was the killed upgrade from 1.7.21 to 2.0? Christian -- Christian Hammond - [email protected]<mailto:[email protected]> Review Board - http://www.reviewboard.org<http://www.reviewboard.org/> Beanbag, Inc. - http://www.beanbaginc.com<http://www.beanbaginc.com/> On July 1, 2014 at 10:12:54 AM, Andrew Hills (anhills) ([email protected]<mailto:[email protected]>) wrote: Hi all, During an upgrade from 1.7.21 to 2.0.2, rb-site upgrade hung. I killed it, and running it again yields the error below, and now no combination of versions works. My last database backup is not so very old, but I'd really rather not lose anything if it's possible to avoid it. (The upgrade on the staging server worked flawlessly; I don't know what's different here.) Is there any way to apply the evolutions that are missing using the rb-site upgrade mechanism, or will I need to resort to applying the schema manually? ------------------ <begin log output> ------------------ Creating tables ... Upgrading Review Board from 2.0 to 2.0.2 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. 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: (1054, "Unknown column 'show_submitted' in 'accounts_profile'") Thanks, Andrew -- 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 [email protected]<mailto:[email protected]>. 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
