Migration from havana to icehouse takes forever if large subset of data is present

[David Hill]

Hi guys,

    I think the upgrade documentation from Havana to Icehouse should be updated so keystone-manage token_flush is used before anything else. If keystone token_flush is present in Havana, it should definitely be ran before doing anything else too.

Still runing after 30 minutes:

mysql> show processlist;
+--------+------+-----------+----------+---------+------+-------------------+------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------+-----------+----------+---------+------+-------------------+------------------------------------------------------------+
| 547285 | root | localhost | keystone | Query | 0 | NULL | show processlist |
| 547349 | root | localhost | keystone | Query | 1899 | copy to tmp table | ALTER TABLE keystone.token CONVERT TO CHARACTER SET 'utf8' |
+--------+------+-----------+----------+---------+------+-------------------+------------------------------------------------------------+
2 rows in set (0.00 sec)

Dave

[Lance Bragstad (lbragstad)]

Hi Dave,

Do you have a link to the specific upgrade documentation you're referencing?

[Dolph Mathews (dolph)]

keystone-manage token_flush should be used on a regular basis (for example, hourly cron), regardless of whether you're upgrading or not.

[Christina Darretta (darrettac)]

It's listed as a step in these upgrade docs:
http://docs.openstack.org/openstack-ops/content/upgrades_havana-icehouse-ubuntu.html
http://docs.openstack.org/openstack-ops/content/upgrades_havana-icehouse-rhel.html

# service openstack-keystone stop
# keystone-manage token_flush
# keystone-manage db_sync
# service openstack-keystone start

[David Hill (david-hill-ubisoft)]

Yep my bad.

Sorry about this.