Hi Chris, Yeah, that's not a particularly helpful error (though, more helpful than some of MySQL's).
One possibility is that your database was using MyISAM tables (default on older versions of MySQL) and your new database is defaulting to InnoDB tables. If this is the case, you'll need to convert them. This can be done one-at-a-time in the MySQL shell, or it can be done by hand-editing a database dump from the old database (changing MyISAM to InnoDB in the file) and then re-importing it. Do you have a backup of the database pre-upgrade? I assume so with the clone, but want to check. Christian On Fri, Mar 16, 2018 at 12:31 PM, Chris Kast <[email protected]> wrote: > Hi all- > > I'm testing out upgrading our RB instance from 2.5.16 to the latest > (3.0.3). We're running in an AWS instance and our database is an RDS > instance running the MySQL 5.6.35 engine. I cloned both of those and got it > into a running state. Following the documentation, I ran "easy_install -U > ReviewBoard" and that succeeded. When I ran "rb-site upgrade" to upgrade > our site, I got the following output/stacktrace: > > # rb-site upgrade /var/www/reviews.mycompany.com/ > Rebuilding directory structure > Upgrading site settings_local.py > Updating database. This may take a while. > > The log output below, including warnings and errors, > can be ignored unless upgrade fails. > > ------------------ <begin log output> ------------------ > Creating tables ... > Creating table oauth2_provider_grant > Traceback (most recent call last): > File "/usr/local/bin/rb-site", line 11, in <module> > load_entry_point('ReviewBoard==3.0.3', 'console_scripts', 'rb-site')() > File "/usr/local/lib/python2.7/dist-packages/ReviewBoard-3.0. > 3-py2.7.egg/reviewboard/cmdline/rbsite.py", line 1965, in main > command.run() > File "/usr/local/lib/python2.7/dist-packages/ReviewBoard-3.0. > 3-py2.7.egg/reviewboard/cmdline/rbsite.py", line 1761, in run > site.sync_database() > File "/usr/local/lib/python2.7/dist-packages/ReviewBoard-3.0. > 3-py2.7.egg/reviewboard/cmdline/rbsite.py", line 454, in sync_database > self.run_manage_command("syncdb", params) > File "/usr/local/lib/python2.7/dist-packages/ReviewBoard-3.0. > 3-py2.7.egg/reviewboard/cmdline/rbsite.py", line 713, in > run_manage_command > execute_from_command_line([__file__, cmd] + params) > File > "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", > line 399, in execute_from_command_line > utility.execute() > File > "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", > line 392, in execute > self.fetch_command(subcommand).run_from_argv(self.argv) > File > "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", > line 242, in run_from_argv > self.execute(*args, **options.__dict__) > File > "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", > line 285, in execute > output = self.handle(*args, **options) > File > "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", > line 415, in handle > return self.handle_noargs(**options) > File "/usr/local/lib/python2.7/dist-packages/django/core/ > management/commands/syncdb.py", line 107, in handle_noargs > cursor.execute(statement) > File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py", > line 69, in execute > return super(CursorDebugWrapper, self).execute(sql, params) > File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py", > line 53, in execute > return self.cursor.execute(sql, params) > File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line > 99, in __exit__ > six.reraise(dj_exc_type, dj_exc_value, traceback) > File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py", > line 51, in execute > return self.cursor.execute(sql) > File > "/usr/local/lib/python2.7/dist-packages/django/db/backends/mysql/base.py", > line 124, in execute > return self.cursor.execute(query, args) > File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 226, > in execute > self.errorhandler(self, exc, value) > File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line > 36, in defaulterrorhandler > raise errorvalue > django.db.utils.IntegrityError: (1215, 'Cannot add foreign key > constraint') > > Any thoughts? Not sure where to go from here. Thanks! > > -- > Supercharge your Review Board with Power Pack: > https://www.reviewboard.org/powerpack/ > Want us to host Review Board for you? Check out RBCommons: > https://rbcommons.com/ > Happy user? Let us know! https://www.reviewboard.org/users/ > --- > You received this message because you are subscribed to the Google Groups > "Review Board Community" 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/d/optout. > -- Christian Hammond President/CEO of Beanbag <https://www.beanbaginc.com/> Makers of Review Board <https://www.reviewboard.org/> -- Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/ Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/ Happy user? Let us know! https://www.reviewboard.org/users/ --- You received this message because you are subscribed to the Google Groups "Review Board Community" 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/d/optout.
