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 - chip...@chipx86.com
Review Board - http://www.reviewboard.org
Beanbag, Inc. - http://www.beanbaginc.com


On Tue, Jun 25, 2013 at 12:44 PM, Erik Lattimore <erik.l...@gmail.com>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
> reviewboard+unsubscr...@googlegroups.com
> 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 reviewboard+unsubscr...@googlegroups.com.
> 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 
reviewboard+unsubscr...@googlegroups.com
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 reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to