Role table not upgraded to grizzly cleanly
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Identity (keystone) |
Fix Released
|
Critical
|
William Kelly |
Bug Description
The role table has two problems in a folsom -> grizzly database migration.
Starting with a folsom keystone database (version 4) and running the grizzly keystone-manage db_sync results in a database of version 15 but the role table doesn't match a freshly created version 15 database. There are two problems...the examples below are from comparing a folsom devstack manually upgraded to grizzly and a current grizzly run so they contain the default devstack data.
The first is that the new extra column does not get properly initialized for the existing rows. It should be ampty JSON '{}'.
LOCK TABLES `role` WRITE;
/*!40000 ALTER TABLE `role` DISABLE KEYS */;
-INSERT INTO `role` VALUES
('1c77b6a292c
('270d14dba2b
('43831b701e2
('55982562e10
('72e19319d1d
('cf14b1e56d3
;
+INSERT INTO `role` VALUES
('3ffc20b5518
('aae61252208
('e680c6a7ed7
('f325f1de369
;
/*!40000 ALTER TABLE `role` ENABLE KEYS */;
UNLOCK TABLES;
The second is more minor in that the size of the name column is different. This is a minor issue and will only cause problems with names > 64 chars.
# Role table actually is different
/*!40101 SET character_
CREATE TABLE `role` (
`id` varchar(64) NOT NULL,
- `name` varchar(64) NOT NULL,
+ `name` varchar(255) NOT NULL,
`extra` text,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
Changed in keystone: | |
milestone: | none → grizzly-rc1 |
Changed in keystone: | |
importance: | Undecided → Critical |
tags: | added: cloud-archive |
Changed in keystone: | |
assignee: | nobody → Will Kelly (wkelly9875) |
Changed in keystone: | |
status: | Fix Committed → Fix Released |
Changed in keystone: | |
milestone: | grizzly-rc1 → 2013.1 |
See also bug #1131087