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.


Reply via email to