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 reviewboard+unsubscr...@googlegroups.com <javascript:_e({},
> 'cvml', 'reviewboard%2bunsubscr...@googlegroups.com');>.
> For more options, visit https://groups.google.com/groups/opt_out.
>


-- 
-- 
Christian Hammond - chip...@chipx86.com
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 reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to