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.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to