Hmm, we tried to avoid indexes that would trigger this. Do you have any idea which table/index this was having problems with?
Christian On Monday, November 18, 2013, Vlad S. wrote: > Hi, > > Just share my upgrade experience here with mysql 5.6 nd RB 1.7.14. > Upgrade to 2.0 beta might require some InnoDB magic. > > Initial upgrade fails like this: > > $ rb-site upgrade /home/rb/www/rb-dev > [..] > Rebuilding directory structure > Updating database. This may take a while. > > The log output below, including warnings and errors, > can be ignored unless upgrade fails. > > ------------------ <begin log output> ------------------ > /home/rb/envs/rb-dev/lib/python2.6/site-packages/Django-1.5.5-py2.6.egg/django/core/management/__init__.py:465: > DeprecationWarning: The 'execute_manager' function is deprecated, you > likely need to update your 'manage.py'; please see the Django 1.4 release > notes (https://docs.djangoproject.com/en/dev/releases/1.4/). > DeprecationWarning) > /home/rb/envs/rb-dev/lib/python2.6/site-packages/Django-1.5.5-py2.6.egg/django/core/management/__init__.py:409: > DeprecationWarning: The 'setup_environ' function is deprecated, you likely > need to update your 'manage.py'; please see the Django 1.4 release notes ( > https://docs.djangoproject.com/en/dev/releases/1.4/). > DeprecationWarning) > Creating tables ... > Upgrading Review Board from 1.7.14 to 2.0 beta 1 > There are unapplied evolutions for accounts. > There are unapplied evolutions for attachments. > There are unapplied evolutions for changedescs. > There are unapplied evolutions for diffviewer. > There are unapplied evolutions for reviews. > Project signature has changed - an evolution is required > Installing custom SQL ... > Installing indexes ... > Installed 0 object(s) from 0 fixture(s) > CommandError: Error applying evolution: Specified key was too long; max > key length is 767 bytes > > This is mysql (django) issue, so the database needs a minor fixes. > > See recommendation here https://code.djangoproject.com/ticket/18392. > Basically your stage database would require these InnoDB options to be > enabled. > > > <http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_large_prefix> > innodb_large_prefix=ON > innodb_file_per_table=ON > innodb_file_format=Barracuda > and ALTER TABLE all tables with ROW_FORMAT=DYNAMIC attribute. > > > To alter all tables to ROW_FORMAT=DYNAMIC I used this script to generate > SQL commands. > > #!/bin/sh > > DB_NAME="rb_dev"; > > mysql --user=rb_dev -h localhost --password='<password>' --execute="USE > information_schema; SELECT CONCAT(\"ALTER TABLE \`\", > TABLE_SCHEMA,\"\`.\`\", TABLE_NAME, \"\` ROW_FORMAT=DYNAMIC;\") as MySQLCMD > from TABLES where TABLE_SCHEMA = \""${DB_NAME}"\";" > ${DB_NAME}-temp.sql; > > then applied rb_dev-temp.sql file (remove the first line "MySQLCMD" in > the file.) > > After the tricks above the rb-site upgrade went fine. > > /v > > > > -- > Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/ > --- > Sign up for Review Board hosting at RBCommons: https://rbcommons.com/ > --- > Happy user? Let us know at http://www.reviewboard.org/users/ > --- > 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:_e({}, > 'cvml', 'reviewboard%[email protected]');>. > For more options, visit https://groups.google.com/groups/opt_out. > -- -- Christian Hammond - [email protected] Review Board - http://www.reviewboard.org Beanbag, Inc. - http://www.beanbaginc.com -- Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/ --- Sign up for Review Board hosting at RBCommons: https://rbcommons.com/ --- Happy user? Let us know at http://www.reviewboard.org/users/ --- 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.
