Thanks, that solved the issue. Looks like mysql 5.5 defaults to InnoDB but our original tables were in the older format. I altered them to InnoDB and everything works now. Thanks, --Erik
On Tuesday, June 25, 2013 4:26:12 PM UTC-4, Christian Hammond wrote: > > 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] <javascript:> > 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]<javascript:> > > 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] <javascript:> >> 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] <javascript:>. >> 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.
