[Bug 1062277] [NEW] 092_add_instance_system_metadata migration fails when upgrading

Andrew Glen-Young 1062277 at bugs.launchpad.net
Fri Oct 5 13:16:53 UTC 2012 

Public bug reported:

The upgrade from Precise+Essex to Precise+Folsom using the ubuntu-cloud
archive fails while running the 092_add_instance_system_metadata
migration. The migration fails while creating the
`instance_system_metadata` table (see below).

The '1005' MySQL error indicates that a foreign key is failing to apply.
After changing the table definition in the table to include
`mysql_charset='utf8'` the migration succeeds (see attached bug). This
is a similar bug that the `dns_domains` table had previously.


Error message received during package upgrade:

2012-10-04 10:59:55 INFO sqlalchemy.engine.base.Engine [-] SHOW CREATE TABLE `instances`
2012-10-04 10:59:55 INFO sqlalchemy.engine.base.Engine [-] ()
2012-10-04 10:59:55 DEBUG sqlalchemy.engine.base.Engine [-] Col ('Table', 'Create Table') from (pid=24755) __init__ /usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py:2789
2012-10-04 10:59:55 DEBUG sqlalchemy.engine.base.Engine [-] Row ('instances', 'CREATE TABLE `instances` (\n  `created_at` datetime DEFAULT NULL,\n  `updated_at` datetime DEFAULT NULL,\n  `deleted_at` datetime DEFAULT NULL,\n  `deleted` tinyint(1) DEFAULT NULL,\n  `id` int(11) NOT NULL AUTO_INCREMENT,\n  `internal_id` int(11) DEFAULT NULL,\n`user_id` varchar(255) DEFAULT NULL,\n  `project_id` varchar(255) DEFAULT NULL,\n  `image_ref` varchar(255) DEFAULT NULL,\n  `kernel_id` varchar(255) DEFAULT NULL,\n  `ramdisk_id` varchar(255) DEFAULT NULL,\n  `server_name` varchar(255) DEFAULT NULL,\n  `launch_index` int(11) DEFAULT NULL,\n  `key_name` varchar(255) DEFAULT NULL,\n  `key_data` mediumtext,\n  `power_state` int(11) DEFAULT NULL,\n  `vm_state` varchar(255) DEFAULT NULL,\n  `memory_mb` int(11) DEFAULT NULL,\n  `vcpus` int(11) DEFAULT NULL,\n  `hostname` varchar(255) DEFAULT NULL,\n  `host` varchar(255) DEFAULT NULL,\n  `user_data` mediumtext,\n  `reservation_id` varchar(255) DEFAULT NULL,\n  `scheduled_at` datetime DEFAULT NULL,\n  `launched_at` datetime DEFAULT NULL,\n  `terminated_at` datetime DEFAULT NULL,\n  `display_name` varchar(255) DEFAULT NULL,\n  `display_description` varchar(255) DEFAULT NULL,\n  `availability_zone` varchar(255) DEFAULT NULL,\n  `locked` tinyint(1) DEFAULT NULL,\n  `os_type` varchar(255) DEFAULT NULL,\n  `launched_on` ediumtext,\n  `instance_type_id` int(11) DEFAULT NULL,\n  `vm_mode` varchar(255) DEFAULT NULL,\n  `uuid` varchar(36) DEFAULT NULL,\n  `architecture` varchar(255) DEFAULT NULL,\n  `root_device_name` varchar(255) DEFAULT NULL,\n access_ip_v4` varchar(255) DEFAULT NULL,\n  `access_ip_v6` varchar(255) DEFAULT NULL,\n  `config_drive` varchar(255) DEFAULT NULL,\n  `task_state` varchar(255) DEFAULT NULL,\n  `default_ephemeral_device` varchar(255) DEFAULT NULL,\n  `default_swap_device` varchar(255) DEFAULT NULL,\n  `progress` int(11) DEFAULT NULL,\n  `auto_disk_config` tinyint(1) DEFAULT NULL,\n  `shutdown_terminate` tinyint(1) DEFAULT NULL,\n  `disable_terminate` tinyint(1) DEFAULT NULL,\n  `root_gb` int(11) DEFAULT NULL,\n  `ephemeral_gb` int(11) DEFAULT NULL,\n  `cell_name` varchar(255) DEFAULT NULL,\n  PRIMARY KEY (`id`),\n  UNIQUE KEY `uuid` (`uuid`),\n  KEY `project_id` (`project_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=17623 DEFAULT CHARSET=utf8') from (pid=24755) process_rows /usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py:3194
2012-10-04 10:59:55 DEBUG sqlalchemy.pool.QueuePool [-] Connection <_mysql.connection open to '10.55.58.1' at 28b0ed0> being returned to pool from (pid=24755) _finalize_fairy /usr/lib/python2.7/dist-packages/sqlalchemy/pool.py:3
64
2012-10-04 10:59:55 DEBUG sqlalchemy.pool.QueuePool [-] Connection <_mysql.connection open to '10.55.58.1' at 28b0ed0> checked out from pool from (pid=24755) __init__ /usr/lib/python2.7/dist-packages/sqlalchemy/pool.py:401
2012-10-04 10:59:55 INFO sqlalchemy.engine.base.Engine [-]
CREATE TABLE instance_system_metadata (
        created_at DATETIME,
        updated_at DATETIME,
        deleted_at DATETIME,
        deleted BOOL,
        id INTEGER NOT NULL AUTO_INCREMENT,
        instance_uuid VARCHAR(36) NOT NULL,
        `key` VARCHAR(255) NOT NULL,
        value VARCHAR(255),
        PRIMARY KEY (id),
        CHECK (deleted IN (0, 1)),
        FOREIGN KEY(instance_uuid) REFERENCES instances (uuid)
)ENGINE=InnoDB


2012-10-04 10:59:55 INFO sqlalchemy.engine.base.Engine [-] ()
2012-10-04 10:59:55 INFO sqlalchemy.engine.base.Engine [-] ROLLBACK
2012-10-04 10:59:55 DEBUG sqlalchemy.pool.QueuePool [-] Connection <_mysql.connection open to '10.55.58.1' at 28b0ed0> being returned to pool from (pid=24755) _finalize_fairy /usr/lib/python2.7/dist-packages/sqlalchemy/pool.py:364
No handlers could be found for logger "092_add_instance_system_metadata"
Command failed, please check log for more info
2012-10-04 10:59:55 CRITICAL nova [-] (OperationalError) (1005, "Can't create table 'nova.instance_system_metadata' (errno: 150)") '\nCREATE TABLE instance_system_metadata (\n\tcreated_at DATETIME, \n\tupdated_at DATETIME, \n\tdeleted_at DATETIME, \n\tdeleted BOOL, \n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\tinstance_uuid VARCHAR(36) NOT NULL, \n\t`key` VARCHAR(255) NOT NULL, \n\tvalue VARCHAR(255), \n\tPRIMARY KEY (id), \n\tCHECK (deleted IN (0, 1)), \n\tFOREIGN KEY(instance_uuid) REFERENCES instances (uuid)\n)ENGINE=InnoDB\n\n' ()

System information:

$ cat /etc/lsb-release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=12.04
DISTRIB_CODENAME=precise
DISTRIB_DESCRIPTION="Ubuntu 12.04.1 LTS"

$ dpkg -l | grep nova
ii  nova-api                         2012.2-0ubuntu3~cloud0                        OpenStack Compute - API frontend
ii  nova-cert                        2012.2-0ubuntu3~cloud0                        OpenStack Compute - certificate management
ii  nova-common                      2012.2-0ubuntu3~cloud0                        OpenStack Compute - common files
ii  nova-doc                         2012.2-0ubuntu3~cloud0                        OpenStack Compute - documentation
ii  nova-network                     2012.2-0ubuntu3~cloud0                        OpenStack Compute - Network manager
ii  nova-objectstore                 2012.2-0ubuntu3~cloud0                        OpenStack Compute - object store
ii  nova-scheduler                   2012.2-0ubuntu3~cloud0                        OpenStack Compute - virtual machine scheduler
ii  python-nova                      2012.2-0ubuntu3~cloud0                        OpenStack Compute Python libraries
ii  python-novaclient                1:2.9.0-0ubuntu1~cloud0                       client library for OpenStack Compute API

** Affects: nova (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: canonistack

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to nova in Ubuntu.
https://bugs.launchpad.net/bugs/1062277

Title:
  092_add_instance_system_metadata migration fails when upgrading

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/nova/+bug/1062277/+subscriptions

More information about the Ubuntu-server-bugs mailing list