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 < christ...@beanbaginc.com> 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 - christ...@beanbaginc.com > Review Board - https://www.reviewboard.org > Beanbag, Inc. - https://www.beanbaginc.com > > On Tue, Jul 14, 2015 at 10:14 AM, Risha Chheda <rishachh...@gmail.com> > 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 < >> christ...@beanbaginc.com> 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 - christ...@beanbaginc.com >>> Review Board - https://www.reviewboard.org >>> Beanbag, Inc. - https://www.beanbaginc.com >>> >>> On Mon, Jul 13, 2015 at 3:58 PM, Risha Chheda <rishachh...@gmail.com> >>> 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 < >>>> christ...@beanbaginc.com> 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 - christ...@beanbaginc.com >>>>> Review Board - https://www.reviewboard.org >>>>> Beanbag, Inc. - https://www.beanbaginc.com >>>>> >>>>> -----Original Message----- >>>>> From: Risha Chheda <rishachh...@gmail.com> >>>>> Reply: reviewboard@googlegroups.com <reviewboard@googlegroups.com>> >>>>> Date: July 13, 2015 at 3:24:20 PM >>>>> To: reviewboard@googlegroups.com <reviewboard@googlegroups.com>> >>>>> 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 reviewboard+unsubscr...@googlegroups.com. >>>>> > 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 reviewboard+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Dumping mysql db and converting tables to Innodb.rtf
Description: RTF file
