Re: Upgrade from 1.6.22 to 2.5.2 fails, using PostgreSQL / Ubuntu 12.04.4
Hi Chris, Just checking in. Thanks, Oliver On Monday, December 14, 2015 at 5:56:16 PM UTC-6, Christian Hammond wrote: > > I'm sorry, Oliver. With the holidays coming up and some premium support > stuff on my plate, I've had absolutely no time to look at this. I'll try > soon, but I'm so swamped. > > Christian > > -- > Christian Hammond - chri...@beanbaginc.com > Review Board - https://www.reviewboard.org > Beanbag, Inc. - https://www.beanbaginc.com > > On Mon, Dec 14, 2015 at 9:44 AM, Oliver Fasterling <ofast...@gmail.com > > wrote: > >> Hi Christian, >> >> Just checking in. Were the dumps that you requested helpful? >> >> Thanks, >> >> Oliver >> >> >> On Thursday, December 10, 2015 at 10:47:57 AM UTC-6, Oliver Fasterling >> wrote: >> >>> Attached are the dumps you requested. Thank you for looking into this. >>> >>> Oliver >>> >>> On Tuesday, December 8, 2015 at 4:09:05 PM UTC-6, Christian Hammond >>> wrote: >>> >>> Hi Oliver, >>> >>> This is definitely a different problem than the ones you found, but it >>> is strange.. The stored schema should have had some state in there for the >>> new FileDiffData table, but it's not there I guess. >>> >>> Can you send me a dump of the schema of your database (no content), and >>> a second dump containing the content of your django_project_version and >>> django_evolution tables? >>> >>> Christian >>> >>> -- >>> Christian Hammond - chri...@beanbaginc.com >>> Review Board - https://www.reviewboard.org >>> Beanbag, Inc. - https://www.beanbaginc.com >>> >>> On Tue, Dec 8, 2015 at 10:15 AM, Oliver Fasterling <ofast...@gmail.com> >>> wrote: >>> >>> I attempted to upgrade our Reviewboard 1.6.22 to 2.5.2 (latest version). >>> I followed the steps documented in the upgrade guide, but failed with some >>> errors. >>> >>> I searched the mailing lists and found two articles which seem to match >>> the errors that I am getting. >>> >>> https://goo.gl/VSbjds >>> >>> https://goo.gl/EpoghP >>> >>> The first article seems to isolate the culprit as a discrepancy of the >>> engine type found on MySQL tables, where there is a mix of MyISAM and >>> InnoDB types. Normalizing these to a single type fixed the issue. Found a >>> few other articles with that suggest the same fix. However, we use >>> PostgresSQL. From my understanding, there is a single engine type in >>> postgresql, and so the fix above does not apply. >>> >>> The second article talks about a bug in the Django Evolution package. I >>> ran the update command, but it was a moot action since it had already >>> downloaded the most recent version during the full upgrade. >>> >>> I considered running an upgrade to an earlier version, like 2.0.x but >>> then I found more articles where the upgrade also fails for them. >>> >>> Any assistance would be much appreciated. >>> >>> The output of my upgrade is shown below. >>> >>> >>> root@reviewboard:~# easy_install -U ReviewBoard >>> Searching for ReviewBoard >>> Reading http://pypi.python.org/simple/ReviewBoard/ >>> Best match: ReviewBoard 2.5.2 >>> Downloading https:// >>> pypi.python.org/packages/2.7/R/ReviewBoard/ReviewBoard-2.5.2-py2.7.egg#md5=58b2dbe01761a1f3d398381130e75d26 >>> Processing ReviewBoard-2.5.2-py2.7.egg >>> creating /usr/local/lib/python2.7/dist-packages/ReviewBoard-2.5.2-py2. >>> 7.egg >>> Extracting ReviewBoard-2.5.2-py2.7.egg to /usr/local/lib/python2.7/dist- >>> packages >>> Removing ReviewBoard 1.6.22.dev from easy-install.pth file >>> Adding ReviewBoard 2.5.2 to easy-install.pth file >>> Installing rbssh script to /usr/local/bin >>> Installing rb-site script to /usr/local/bin >>> >>> >>> Installed /usr/local/lib/python2.7/dist-packages/ReviewBoard-2.5.2-py2. >>> 7.egg >>> Reading http://downloads.reviewboard.org/mirror/ >>> Reading http://downloads.reviewboard.org/releases/Djblets/0.9/ >>> Reading http://downloads.reviewboard.org/releases/django-evolution/0.7/ >>> Processing dependencies for ReviewBoard >>> Searching for Whoosh>=2.6 >>> Reading http://pypi.python.org/simple/Whoosh/ >>> Best match: Whoosh 2.7.0 >>> Downloading https:// >>> pypi.python.or
Re: Upgrade from 1.6.22 to 2.5.2 fails, using PostgreSQL / Ubuntu 12.04.4
Hi Christian, Just checking in. Were the dumps that you requested helpful? Thanks, Oliver On Thursday, December 10, 2015 at 10:47:57 AM UTC-6, Oliver Fasterling wrote: > > Attached are the dumps you requested. Thank you for looking into this. > > Oliver > > On Tuesday, December 8, 2015 at 4:09:05 PM UTC-6, Christian Hammond wrote: > > Hi Oliver, > > This is definitely a different problem than the ones you found, but it is > strange.. The stored schema should have had some state in there for the new > FileDiffData table, but it's not there I guess. > > Can you send me a dump of the schema of your database (no content), and a > second dump containing the content of your django_project_version and > django_evolution tables? > > Christian > > -- > Christian Hammond - chri...@beanbaginc.com > Review Board - https://www.reviewboard.org > Beanbag, Inc. - https://www.beanbaginc.com > > On Tue, Dec 8, 2015 at 10:15 AM, Oliver Fasterling <ofast...@gmail.com> > wrote: > > I attempted to upgrade our Reviewboard 1.6.22 to 2.5.2 (latest version). I > followed the steps documented in the upgrade guide, but failed with some > errors. > > I searched the mailing lists and found two articles which seem to match > the errors that I am getting. > > https://goo.gl/VSbjds > > https://goo.gl/EpoghP > > The first article seems to isolate the culprit as a discrepancy of the > engine type found on MySQL tables, where there is a mix of MyISAM and > InnoDB types. Normalizing these to a single type fixed the issue. Found a > few other articles with that suggest the same fix. However, we use > PostgresSQL. From my understanding, there is a single engine type in > postgresql, and so the fix above does not apply. > > The second article talks about a bug in the Django Evolution package. I > ran the update command, but it was a moot action since it had already > downloaded the most recent version during the full upgrade. > > I considered running an upgrade to an earlier version, like 2.0.x but then > I found more articles where the upgrade also fails for them. > > Any assistance would be much appreciated. > > The output of my upgrade is shown below. > > > root@reviewboard:~# easy_install -U ReviewBoard > Searching for ReviewBoard > Reading http://pypi.python.org/simple/ReviewBoard/ > Best match: ReviewBoard 2.5.2 > Downloading https:// > pypi.python.org/packages/2.7/R/ReviewBoard/ReviewBoard-2.5.2-py2.7.egg#md5=58b2dbe01761a1f3d398381130e75d26 > Processing ReviewBoard-2.5.2-py2.7.egg > creating /usr/local/lib/python2.7/dist-packages/ReviewBoard-2.5.2-py2. > 7.egg > Extracting ReviewBoard-2.5.2-py2.7.egg to /usr/local/lib/python2.7/dist- > packages > Removing ReviewBoard 1.6.22.dev from easy-install.pth file > Adding ReviewBoard 2.5.2 to easy-install.pth file > Installing rbssh script to /usr/local/bin > Installing rb-site script to /usr/local/bin > > > Installed /usr/local/lib/python2.7/dist-packages/ReviewBoard-2.5.2-py2. > 7.egg > Reading http://downloads.reviewboard.org/mirror/ > Reading http://downloads.reviewboard.org/releases/Djblets/0.9/ > Reading http://downloads.reviewboard.org/releases/django-evolution/0.7/ > Processing dependencies for ReviewBoard > Searching for Whoosh>=2.6 > Reading http://pypi.python.org/simple/Whoosh/ > Best match: Whoosh 2.7.0 > Downloading https:// > pypi.python.org/packages/source/W/Whoosh/Whoosh-2.7.0.zip#md5=7abfd970f16fadc7311960f3fa0bc7a9 > Processing Whoosh-2.7.0.zip > Running Whoosh-2.7.0/setup.py -q bdist_egg --dist-dir /tmp/easy_install- > 0wY0qe/Whoosh-2.7.0/egg-dist-tmp-yeD4wW > warning: no files found matching '*.txt' under directory 'tests' > warning: no files found matching '*.txt' under directory 'benchmark' > warning: no files found matching '*.txt' under directory 'docs' > warning: no files found matching '*.txt' under directory 'files' > warning: no files found matching '*.py' under directory 'files' > warning: no files found matching '*.jpg' under directory 'files' > Adding Whoosh 2.7.0 to easy-install.pth file > > > Installed /usr/local/lib/python2.7/dist-packages/Whoosh-2.7.0-py2.7.egg > Searching for Pygments>=1.6 > Reading http://pypi.python.org/simple/Pygments/ > Best match: Pygments 2.0.2 > Downloading https:// > pypi.python.org/packages/source/P/Pygments/Pygments-2.0.2.tar.gz#md5=238587a1370d62405edabd0794b3ec4a > Processing Pygments-2.0.2.tar.gz > Running Pygments-2.0.2/setup.py -q bdist_egg --dist-dir /tmp/easy_install- > MT7Fm3/Pygments-2.0.2/egg-dist-tmp-WGJV2n > Removing Pygments 1.5 from easy-install.pth file > Adding Pygments 2.0.2 to easy-install.pth file > Installing pygmentize script to /usr/local/bin > > &
Re: Upgrade from 1.6.22 to 2.5.2 fails, using PostgreSQL / Ubuntu 12.04.4
Attached are the dumps you requested. Thank you for looking into this. Oliver On Tuesday, December 8, 2015 at 4:09:05 PM UTC-6, Christian Hammond wrote: > > Hi Oliver, > > This is definitely a different problem than the ones you found, but it is > strange.. The stored schema should have had some state in there for the new > FileDiffData table, but it's not there I guess. > > Can you send me a dump of the schema of your database (no content), and a > second dump containing the content of your django_project_version and > django_evolution tables? > > Christian > > -- > Christian Hammond - chri...@beanbaginc.com > Review Board - https://www.reviewboard.org > Beanbag, Inc. - https://www.beanbaginc.com > > On Tue, Dec 8, 2015 at 10:15 AM, Oliver Fasterling <ofast...@gmail.com > > wrote: > > I attempted to upgrade our Reviewboard 1.6.22 to 2.5.2 (latest version). I > followed the steps documented in the upgrade guide, but failed with some > errors. > > I searched the mailing lists and found two articles which seem to match > the errors that I am getting. > > https://goo.gl/VSbjds > > https://goo.gl/EpoghP > > The first article seems to isolate the culprit as a discrepancy of the > engine type found on MySQL tables, where there is a mix of MyISAM and > InnoDB types. Normalizing these to a single type fixed the issue. Found a > few other articles with that suggest the same fix. However, we use > PostgresSQL. From my understanding, there is a single engine type in > postgresql, and so the fix above does not apply. > > The second article talks about a bug in the Django Evolution package. I > ran the update command, but it was a moot action since it had already > downloaded the most recent version during the full upgrade. > > I considered running an upgrade to an earlier version, like 2.0.x but then > I found more articles where the upgrade also fails for them. > > Any assistance would be much appreciated. > > The output of my upgrade is shown below. > > > root@reviewboard:~# easy_install -U ReviewBoard > Searching for ReviewBoard > Reading http://pypi.python.org/simple/ReviewBoard/ > Best match: ReviewBoard 2.5.2 > Downloading https:// > pypi.python.org/packages/2.7/R/ReviewBoard/ReviewBoard-2.5.2-py2.7.egg#md5=58b2dbe01761a1f3d398381130e75d26 > Processing ReviewBoard-2.5.2-py2.7.egg > creating /usr/local/lib/python2.7/dist-packages/ReviewBoard-2.5.2-py2. > 7.egg > Extracting ReviewBoard-2.5.2-py2.7.egg to /usr/local/lib/python2.7/dist- > packages > Removing ReviewBoard 1.6.22.dev from easy-install.pth file > Adding ReviewBoard 2.5.2 to easy-install.pth file > Installing rbssh script to /usr/local/bin > Installing rb-site script to /usr/local/bin > > > Installed /usr/local/lib/python2.7/dist-packages/ReviewBoard-2.5.2-py2. > 7.egg > Reading http://downloads.reviewboard.org/mirror/ > Reading http://downloads.reviewboard.org/releases/Djblets/0.9/ > Reading http://downloads.reviewboard.org/releases/django-evolution/0.7/ > Processing dependencies for ReviewBoard > Searching for Whoosh>=2.6 > Reading http://pypi.python.org/simple/Whoosh/ > Best match: Whoosh 2.7.0 > Downloading https:// > pypi.python.org/packages/source/W/Whoosh/Whoosh-2.7.0.zip#md5=7abfd970f16fadc7311960f3fa0bc7a9 > Processing Whoosh-2.7.0.zip > Running Whoosh-2.7.0/setup.py -q bdist_egg --dist-dir /tmp/easy_install- > 0wY0qe/Whoosh-2.7.0/egg-dist-tmp-yeD4wW > warning: no files found matching '*.txt' under directory 'tests' > warning: no files found matching '*.txt' under directory 'benchmark' > warning: no files found matching '*.txt' under directory 'docs' > warning: no files found matching '*.txt' under directory 'files' > warning: no files found matching '*.py' under directory 'files' > warning: no files found matching '*.jpg' under directory 'files' > Adding Whoosh 2.7.0 to easy-install.pth file > > > Installed /usr/local/lib/python2.7/dist-packages/Whoosh-2.7.0-py2.7.egg > Searching for Pygments>=1.6 > Reading http://pypi.python.org/simple/Pygments/ > Best match: Pygments 2.0.2 > Downloading https:// > pypi.python.org/packages/source/P/Pygments/Pygments-2.0.2.tar.gz#md5=238587a1370d62405edabd0794b3ec4a > Processing Pygments-2.0.2.tar.gz > Running Pygments-2.0.2/setup.py -q bdist_egg --dist-dir /tmp/easy_install- > MT7Fm3/Pygments-2.0.2/egg-dist-tmp-WGJV2n > Removing Pygments 1.5 from easy-install.pth file > Adding Pygments 2.0.2 to easy-install.pth file > Installing pygmentize script to /usr/local/bin > > > Installed /usr/local/lib/python2.7/dist-packages/Pygments-2.0.2-py2.7.egg > Searching for pycrypto>=2.6 > Reading http://pypi.python.org/simple/pycrypto/ > Best match: pycrypto 2