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
