That error has to do with having a mix of InnoDB and MyISAM tables. You need to make sure all tables are the same format. If MySQL is creating new tables with one, then you should convert the rest.
Christian -- Christian Hammond - [email protected] Review Board - http://www.reviewboard.org Beanbag, Inc. - http://www.beanbaginc.com On Tue, Jun 25, 2013 at 12:44 PM, Erik Lattimore <[email protected]>wrote: > I'm getting the exact same error. I'm trying to test an upgrade before > actually performing one on the live server and am getting the same Django > stack trace. > > We are running RB 1.5.2 in production on Ubuntu 12.04. I've been using > easy_install to install ReviewBoard and made sure to force the Django > dependency(1.3.3) since the 1.5.2 package pulls in too new of a version. I > used mysqldump to dump the db from the live server and installed a site by > running rb-site install ... and then seeding the database with the > production data through mysql reviewboard < dump.sql. I then use > easy_install to upgrade to 1.7.1, which completes but the rb-site upgrade > command fails. However, one thing that I did notice is that I have no issue > upgrading an empty install by doing the same steps as before, but not > seeding the backup database and only upgrading an empty site. > > > > > On Tuesday, January 8, 2013 4:34:42 PM UTC-5, virtualAdmin wrote: >> >> We've been making regular backups of our RB 1.5.5 database, and I decided >> it was time to verify that we can restore the DB to a new install in case >> our server fails. The backups are made with mysqlhotcopy, so I understand >> they can be restored by simply stopping the mysql service, copying the >> backup files into the appropriate folder (/var/lib/mysql/reviewboard), and >> starting mysql. >> >> I installed RB 1.7 on an Ubuntu 12.04 LTS VM. I got the software all >> installed and removed the fresh 1.7 database, replacing it with our >> backed-up 1.5.5 DB, making sure to set proper privileges on the db files >> and in mysql itself. >> >> I ran: >> >> rb-site upgrade -d /var/www/mysite >> >> Which failed, giving this output: >> >> ------------------ <begin log output> ------------------ >> Creating tables ... >> Creating table attachments_fileattachment >> Creating table diffviewer_filediffdata >> Creating table hostingsvcs_**hostingserviceaccount >> Creating table reviews_fileattachmentcomment >> Creating table site_localsite_users >> Traceback (most recent call last): >> File "/usr/local/bin/rb-site", line 9, in <module> >> load_entry_point('ReviewBoard=**=1.7.1', 'console_scripts', >> 'rb-site')() >> File "/usr/local/lib/python2.7/**dist-packages/ReviewBoard-1.7.** >> 1-py2.7.egg/reviewboard/**cmdline/rbsite.py", line 1937, in main >> command.run() >> File "/usr/local/lib/python2.7/**dist-packages/ReviewBoard-1.7.** >> 1-py2.7.egg/reviewboard/**cmdline/rbsite.py", line 1778, in run >> site.sync_database() >> File "/usr/local/lib/python2.7/**dist-packages/ReviewBoard-1.7.** >> 1-py2.7.egg/reviewboard/**cmdline/rbsite.py", line 366, in sync_database >> self.run_manage_command("**syncdb", params) >> File "/usr/local/lib/python2.7/**dist-packages/ReviewBoard-1.7.** >> 1-py2.7.egg/reviewboard/**cmdline/rbsite.py", line 556, in >> run_manage_command >> execute_manager(reviewboard.**settings, [__file__, cmd] + params) >> File "/usr/local/lib/python2.7/**dist-packages/Django-1.4.3-** >> py2.7.egg/django/core/**management/__init__.py", line 459, in >> execute_manager >> utility.execute() >> File "/usr/local/lib/python2.7/**dist-packages/Django-1.4.3-** >> py2.7.egg/django/core/**management/__init__.py", line 382, in execute >> self.fetch_command(subcommand)**.run_from_argv(self.argv) >> File "/usr/local/lib/python2.7/**dist-packages/Django-1.4.3-** >> py2.7.egg/django/core/**management/base.py", line 196, in run_from_argv >> self.execute(*args, **options.__dict__) >> File "/usr/local/lib/python2.7/**dist-packages/Django-1.4.3-** >> py2.7.egg/django/core/**management/base.py", line 232, in execute >> output = self.handle(*args, **options) >> File "/usr/local/lib/python2.7/**dist-packages/Django-1.4.3-** >> py2.7.egg/django/core/**management/base.py", line 371, in handle >> return self.handle_noargs(**options) >> File "/usr/local/lib/python2.7/**dist-packages/Django-1.4.3-** >> py2.7.egg/django/core/**management/commands/syncdb.py"**, line 102, in >> handle_noargs >> cursor.execute(statement) >> File "/usr/local/lib/python2.7/**dist-packages/Django-1.4.3-** >> py2.7.egg/django/db/backends/**mysql/base.py", line 114, in execute >> return self.cursor.execute(query, args) >> File "/usr/lib/python2.7/dist-**packages/MySQLdb/cursors.py", line >> 174, in execute >> self.errorhandler(self, exc, value) >> File "/usr/lib/python2.7/dist-**packages/MySQLdb/connections.**py", >> line 36, in defaulterrorhandler >> raise errorclass, errorvalue >> django.db.utils.DatabaseError: (1005, "Can't create table >> 'reviewboard.#sql-5a2b_5b' (errno: 150)") >> >> Any ideas? >> > -- > Want to help the Review Board project? Donate today at > http://www.reviewboard.org/donate/ > Happy user? Let us know at http://www.reviewboard.org/users/ > -~----------~----~----~----~------~----~------~--~--- > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/reviewboard?hl=en > --- > 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/groups/opt_out. > > > -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~----------~----~----~----~------~----~------~--~--- To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en --- 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/groups/opt_out.
