Thanks for the follow-up, Risha! I'm glad it's working :) Hopefully this will help someone else down the road.
Christian -- Christian Hammond - [email protected] Review Board - https://www.reviewboard.org Beanbag, Inc. - https://www.beanbaginc.com On Wed, Jul 29, 2015 at 4:21 PM, Risha Chheda <[email protected]> wrote: > I managed to get this to work, just updating this thread. > > The problem was that the mysqldump I had done had truncated some of the > data in the diffviewer_filediff table. I had to gzip the mysqldump output > and dump it in my test mysql instance. After gzipping the dump was 1.6G. > > I then converted all the tables from MyISAM to Innodb. Again this was > failing for the diffviewer_filediff table with the error 'The table is > full' since the VM I was running this on didn't have enough space. Moving > to a physical server from the VM fixed this issue. I've attached the > commands I ran along with the mysql settings. > > Reviewboard with Docker worked beautifully after that. I just had to run > the docker instance and it installed reviewboard, connected to my database, > performed all the evolutions and started hosting immediately. > > Thanks, > Risha > > > On Tue, Jul 14, 2015 at 12:21 PM, Christian Hammond < > [email protected]> wrote: > >> Hi Risha, >> >> Hmm, I'm not seeing what I was expecting to see there. >> >> It's possible that there's a bug in upgrading to 2.5, due to one of the >> changes we've made. I'm going to be investigating this. For now, I'd >> suggest taking a copy of the 1.6 database and upgrading to the latest 2.0.x >> release instead of 2.5 beta. >> >> Christian >> >> -- >> Christian Hammond - [email protected] >> Review Board - https://www.reviewboard.org >> Beanbag, Inc. - https://www.beanbaginc.com >> >> On Tue, Jul 14, 2015 at 10:14 AM, Risha Chheda <[email protected]> >> wrote: >> >>> I'm not sure if it makes any difference but yesterday I ran the rb-site >>> manage evolve --hint and execute commands. I have attached the output of >>> both of those in the attached document. It didn't seem to make a >>> difference, rb-site upgrade still gives me the same issue. >>> rb-site_evolve >>> <https://docs.google.com/document/d/1eg47ZY25Zzx4rOnWk-WWPaUOEF33emWx3S16PruRmZE/edit?usp=drive_web> >>> >>> >>> Here is the output you requested. >>> >>> from django_evolution.models import Version >>> >>> for v in Version.objects.order_by('pk'): >>> ... print '%s - %s - %s' % (v.pk, v.evolutions.count(), v.when) >>> ... >>> 1 - 0 - 2008-05-19 20:11:53+00:00 >>> 2 - 0 - 2008-09-24 10:08:29+00:00 >>> 3 - 1 - 2008-09-24 10:09:01+00:00 >>> 4 - 0 - 2008-10-27 16:17:08+00:00 >>> 5 - 1 - 2008-10-27 16:17:25+00:00 >>> 6 - 11 - 2011-03-08 05:21:06+00:00 >>> 7 - 2 - 2011-10-17 12:15:42+00:00 >>> 8 - 0 - 2012-10-13 09:34:28+00:00 >>> 9 - 13 - 2012-10-13 09:34:36+00:00 >>> 10 - 3 - 2015-07-13 22:41:16+00:00 >>> >>> >>> On Tue, Jul 14, 2015 at 2:58 AM, Christian Hammond < >>> [email protected]> wrote: >>> >>>> Can you run the following: >>>> >>>> $ rb-site manage /path/to/site shell >>>> >>> from django_evolution.models import Version >>>> >>> for v in Version.objects.order_by('pk'): >>>> >>> print '%s - %s - %s' % (v.pk, v.evolutions.count(), v.when) >>>> >>>> That'll give me a sense of what evolutions are applied. There's a >>>> hard-to-diagnose issue that's come up before where an invalid entry ends up >>>> in the history, throwing things off, and this will help me check for that. >>>> >>>> Thanks, >>>> >>>> Christian >>>> >>>> -- >>>> Christian Hammond - [email protected] >>>> Review Board - https://www.reviewboard.org >>>> Beanbag, Inc. - https://www.beanbaginc.com >>>> >>>> On Mon, Jul 13, 2015 at 3:58 PM, Risha Chheda <[email protected]> >>>> wrote: >>>> >>>>> No, that doesn't help either. >>>>> >>>>> # rb-site manage /var/ReviewBoard syncdb >>>>> Creating tables ... >>>>> 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: 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. >>>>> Project signature has changed - an evolution is required >>>>> Installing custom SQL ... >>>>> Installing indexes ... >>>>> Installed 0 object(s) from 0 fixture(s) >>>>> >>>>> >>>>> root@05e83c8f5ab7:/# rb-site upgrade /var/ReviewBoard >>>>> ...... >>>>> ...... >>>>> <Same error as the original email> >>>>> >>>>> >>>>> On Mon, Jul 13, 2015 at 3:26 PM, Christian Hammond < >>>>> [email protected]> wrote: >>>>> >>>>>> Hi Risha, >>>>>> >>>>>> That's strange. It's like some state is missing there. >>>>>> >>>>>> Can you try doing this first: >>>>>> >>>>>> $ rb-site manage /var/ReviewBoard syncdb >>>>>> >>>>>> and then do the upgrade? See if that gets any further. >>>>>> >>>>>> Christian >>>>>> >>>>>> -- >>>>>> Christian Hammond - [email protected] >>>>>> Review Board - https://www.reviewboard.org >>>>>> Beanbag, Inc. - https://www.beanbaginc.com >>>>>> >>>>>> -----Original Message----- >>>>>> From: Risha Chheda <[email protected]> >>>>>> Reply: [email protected] <[email protected]>> >>>>>> Date: July 13, 2015 at 3:24:20 PM >>>>>> To: [email protected] <[email protected]>> >>>>>> Subject: Upgrading from 1.6.8 to 2.x >>>>>> >>>>>> > Hi, >>>>>> > >>>>>> > I am trying to upgrade reviewboard from 1.6.8 to 2.5.beta and >>>>>> everytime I >>>>>> > get this traceback: >>>>>> > mysql version I'm testing against is 5.6.25. >>>>>> > >>>>>> > Both reviewboard and mysql are running in their own docker >>>>>> containers on >>>>>> > the same VM. >>>>>> > I tried upgrading from 1.6.8 to 2.0.18 as well, but I get the same >>>>>> issue. >>>>>> > >>>>>> > # rb-site upgrade /var/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) >>>>>> > ERROR:root:Unexpected error: u'FileDiffData' >>>>>> > Traceback (most recent call last): >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/django_evolution-0.7.5-py2.7.egg/django_evolution/management/commands/evolve.py", >>>>>> > line 65, in handle >>>>>> > self.evolve(*app_labels, **options) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/django_evolution-0.7.5-py2.7.egg/django_evolution/management/commands/evolve.py", >>>>>> > line 125, in evolve >>>>>> > sql.extend(self.evolve_app(app)) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/django_evolution-0.7.5-py2.7.egg/django_evolution/management/commands/evolve.py", >>>>>> > line 164, in evolve_app >>>>>> > app_mutator.run_mutations(mutations) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/django_evolution-0.7.5-py2.7.egg/django_evolution/mutators.py", >>>>>> > line 279, in run_mutations >>>>>> > self.run_mutation(mutation) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/django_evolution-0.7.5-py2.7.egg/django_evolution/mutators.py", >>>>>> > line 268, in run_mutation >>>>>> > model_mutator.run_mutation(mutation) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/django_evolution-0.7.5-py2.7.egg/django_evolution/mutators.py", >>>>>> > line 165, in run_mutation >>>>>> > mutation.mutate(self, self.create_model()) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/django_evolution-0.7.5-py2.7.egg/django_evolution/mutations.py", >>>>>> > line 446, in mutate >>>>>> > self.add_column(mutator, model) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/django_evolution-0.7.5-py2.7.egg/django_evolution/mutations.py", >>>>>> > line 450, in add_column >>>>>> > self.field_type, self.field_attrs, model) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/django_evolution-0.7.5-py2.7.egg/django_evolution/mutations.py", >>>>>> > line 37, in create_field >>>>>> > related_model_sig = proj_sig[related_app_name][related_model_name] >>>>>> > KeyError: u'FileDiffData' >>>>>> > Traceback (most recent call last): >>>>>> > File "/usr/local/bin/rb-site", line 9, in >>>>>> > load_entry_point('ReviewBoard==2.5beta1', 'console_scripts', >>>>>> > 'rb-site')() >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/ReviewBoard-2.5beta1-py2.7.egg/reviewboard/cmdline/rbsite.py", >>>>>> > line 1885, in main >>>>>> > command.run() >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/ReviewBoard-2.5beta1-py2.7.egg/reviewboard/cmdline/rbsite.py", >>>>>> > line 1694, in run >>>>>> > site.migrate_database() >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/ReviewBoard-2.5beta1-py2.7.egg/reviewboard/cmdline/rbsite.py", >>>>>> > line 438, in migrate_database >>>>>> > self.run_manage_command("evolve", ["--noinput", "--execute"]) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/ReviewBoard-2.5beta1-py2.7.egg/reviewboard/cmdline/rbsite.py", >>>>>> > line 662, in run_manage_command >>>>>> > execute_from_command_line([__file__, cmd] + params) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/Django-1.6.11-py2.7.egg/django/core/management/__init__.py", >>>>>> > line 399, in execute_from_command_line >>>>>> > utility.execute() >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/Django-1.6.11-py2.7.egg/django/core/management/__init__.py", >>>>>> > line 392, in execute >>>>>> > self.fetch_command(subcommand).run_from_argv(self.argv) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/Django-1.6.11-py2.7.egg/django/core/management/base.py", >>>>>> > line 242, in run_from_argv >>>>>> > self.execute(*args, **options.__dict__) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/Django-1.6.11-py2.7.egg/django/core/management/base.py", >>>>>> > line 285, in execute >>>>>> > output = self.handle(*args, **options) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/django_evolution-0.7.5-py2.7.egg/django_evolution/management/commands/evolve.py", >>>>>> > line 65, in handle >>>>>> > self.evolve(*app_labels, **options) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/django_evolution-0.7.5-py2.7.egg/django_evolution/management/commands/evolve.py", >>>>>> > line 125, in evolve >>>>>> > sql.extend(self.evolve_app(app)) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/django_evolution-0.7.5-py2.7.egg/django_evolution/management/commands/evolve.py", >>>>>> > line 164, in evolve_app >>>>>> > app_mutator.run_mutations(mutations) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/django_evolution-0.7.5-py2.7.egg/django_evolution/mutators.py", >>>>>> > line 279, in run_mutations >>>>>> > self.run_mutation(mutation) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/django_evolution-0.7.5-py2.7.egg/django_evolution/mutators.py", >>>>>> > line 268, in run_mutation >>>>>> > model_mutator.run_mutation(mutation) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/django_evolution-0.7.5-py2.7.egg/django_evolution/mutators.py", >>>>>> > line 165, in run_mutation >>>>>> > mutation.mutate(self, self.create_model()) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/django_evolution-0.7.5-py2.7.egg/django_evolution/mutations.py", >>>>>> > line 446, in mutate >>>>>> > self.add_column(mutator, model) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/django_evolution-0.7.5-py2.7.egg/django_evolution/mutations.py", >>>>>> > line 450, in add_column >>>>>> > self.field_type, self.field_attrs, model) >>>>>> > File >>>>>> > >>>>>> "/usr/local/lib/python2.7/dist-packages/django_evolution-0.7.5-py2.7.egg/django_evolution/mutations.py", >>>>>> > line 37, in create_field >>>>>> > related_model_sig = proj_sig[related_app_name][related_model_name] >>>>>> > KeyError: u'FileDiffData' >>>>>> > >>>>>> > What am I missing ? Does anyone know how to get around this ? >>>>>> > >>>>>> > Thanks, >>>>>> > Risha >>>>>> > >>>>>> > -- >>>>>> > 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. >>>>>> > >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Regards, >>>>> Risha Chheda >>>>> >>>> >>>> >>> >>> >>> -- >>> Regards, >>> Risha Chheda >>> >> >> > > > -- > Regards, > Risha Chheda > -- 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.
