Activity log for bug #1713059

Date Who What changed Old value New value Message
2017-08-25 13:11:07 Felipe Reyes bug added bug
2017-08-27 11:38:57 Dominique Poulain bug added subscriber Dominique Poulain
2017-08-28 13:19:24 Felipe Reyes nominated for series Ubuntu Xenial
2017-08-28 13:19:24 Felipe Reyes nominated for series Ubuntu Artful
2017-08-28 13:19:24 Felipe Reyes nominated for series Ubuntu Zesty
2017-08-28 14:24:34 Felipe Reyes bug added subscriber James Page
2017-08-28 15:37:55 Felipe Reyes attachment added lp1713059_artful.debdiff https://bugs.launchpad.net/ubuntu/+source/nova/+bug/1713059/+attachment/4940264/+files/lp1713059_artful.debdiff
2017-08-28 16:19:56 Ubuntu Foundations Team Bug Bot tags sts patch sts
2017-08-28 16:20:04 Ubuntu Foundations Team Bug Bot bug added subscriber Ubuntu Sponsors Team
2017-08-28 19:21:31 Launchpad Janitor nova (Ubuntu): status New Confirmed
2017-08-29 14:28:01 Corey Bryant summary nova db sync is executed when the 'connection' is not defined drop db sync commands from OpenStack packages
2017-08-29 14:29:03 Corey Bryant description When the 'connection' configuration key is NOT defined in /etc/nova/nova.conf the nova-common.postinst script still tries to run 'nova-manage db sync' root@juju-b24bc9-mno-18:~# grep connection /etc/nova/nova.conf root@juju-b24bc9-mno-18:~# dpkg-reconfigure nova-common Option "logdir" from group "DEFAULT" is deprecated. Use option "log-dir" from group "DEFAULT". Option "verbose" from group "DEFAULT" is deprecated for removal. Its value may be silently ignored in the future. ERROR: could not access cell mapping database - has api db been created? An error has occurred: Traceback (most recent call last): File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 1602, in main ret = fn(*fn_args, **fn_kwargs) File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 645, in sync return migration.db_sync(version) File "/usr/lib/python2.7/dist-packages/nova/db/migration.py", line 26, in db_sync return IMPL.db_sync(version=version, database=database, context=context) File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migration.py", line 57, in db_sync repository, version) File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade return _migrate(url, repository, version, upgrade=True, err=err, **opts) File "<decorator-gen-15>", line 2, in _migrate File "/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 160, in with_engine return f(*a, **kw) File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate schema.runchange(ver, change, changeset.step) File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 93, in runchange change.run(self.engine, step) File "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 148, in run script_func(engine) File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migrate_repo/versions/345_require_online_migration_completion.py", line 44, in upgrade raise exception.ValidationError(detail=msg) ValidationError: Migration cannot continue until all these have been migrated to the api database. Please run `nova-manage db online_migrations' on Newton code before continuing.There are still 5 unmigrated flavors. Running the postinst script manually with -x root@juju-b24bc9-mno-18:~# bash -ex /var/lib/dpkg/info/nova-common.postinst configure + '[' configure = configure ']' + getent group nova + getent passwd nova + '[' -z '' ']' + chown -R nova:nova /var/lib/nova/ + chown -R nova:nova /etc/nova + chown -R nova:adm /var/log/nova + '[' -z '' ']' + chown -R nova:nova /var/lib/nova/ + chmod 0640 /etc/nova/nova.conf + chmod 0640 /etc/nova/api-paste.ini + chmod 0750 /etc/nova + chmod 0750 /var/log/nova + chown root:root /etc/nova/rootwrap.conf + chown root:root /etc/nova/rootwrap.d + chmod 0755 /etc/nova/rootwrap.d + grep -qE '^(sql_)?connection( )?=.*' /etc/nova/nova.conf + su -s /bin/sh -c 'nova-manage db sync' nova Option "logdir" from group "DEFAULT" is deprecated. Use option "log-dir" from group "DEFAULT". Option "verbose" from group "DEFAULT" is deprecated for removal. Its value may be silently ignored in the future. ERROR: could not access cell mapping database - has api db been created? An error has occurred: Traceback (most recent call last): ... ValidationError: Migration cannot continue until all these have been migrated to the api database. Please run `nova-manage db online_migrations' on Newton code before continuing.There are still 5 unmigrated flavors. The condition to run the sync operation should be that the connection config key is defined in nova.conf # diff -u /var/lib/dpkg/info/nova-common.postinst ./nova-common.postinst --- /var/lib/dpkg/info/nova-common.postinst 2017-06-19 08:12:49.000000000 +0000 +++ ./nova-common.postinst 2017-08-25 13:08:48.852744427 +0000 @@ -47,8 +47,8 @@ chown root:root /etc/nova/rootwrap.d chmod 0755 /etc/nova/rootwrap.d - if ! grep -qE "^(sql_)?connection( )?=.*" /etc/nova/nova.conf || \ - grep -qE "^(sql_)?connection.*sqlite.*" /etc/nova/nova.conf + if grep -qE "^(sql_)?connection( )?=.*" /etc/nova/nova.conf || \ + grep -qE "^(sql_)?connection.*sqlite.*" /etc/nova/nova.conf then su -s /bin/sh -c 'nova-manage db sync' nova fi The original reason this bug was opened is that nova db sync is executed when the 'connection' is not defined. Let's fix that and at the same time drop all db syncs from OpenStack packages in Pike. When the 'connection' configuration key is NOT defined in /etc/nova/nova.conf the nova-common.postinst script still tries to run 'nova-manage db sync' root@juju-b24bc9-mno-18:~# grep connection /etc/nova/nova.conf root@juju-b24bc9-mno-18:~# dpkg-reconfigure nova-common Option "logdir" from group "DEFAULT" is deprecated. Use option "log-dir" from group "DEFAULT". Option "verbose" from group "DEFAULT" is deprecated for removal. Its value may be silently ignored in the future. ERROR: could not access cell mapping database - has api db been created? An error has occurred: Traceback (most recent call last):   File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 1602, in main     ret = fn(*fn_args, **fn_kwargs)   File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 645, in sync     return migration.db_sync(version)   File "/usr/lib/python2.7/dist-packages/nova/db/migration.py", line 26, in db_sync     return IMPL.db_sync(version=version, database=database, context=context)   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migration.py", line 57, in db_sync     repository, version)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade     return _migrate(url, repository, version, upgrade=True, err=err, **opts)   File "<decorator-gen-15>", line 2, in _migrate   File "/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 160, in with_engine     return f(*a, **kw)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate     schema.runchange(ver, change, changeset.step)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 93, in runchange     change.run(self.engine, step)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 148, in run     script_func(engine)   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migrate_repo/versions/345_require_online_migration_completion.py", line 44, in upgrade     raise exception.ValidationError(detail=msg) ValidationError: Migration cannot continue until all these have been migrated to the api database. Please run `nova-manage db online_migrations' on Newton code before continuing.There are still 5 unmigrated flavors. Running the postinst script manually with -x root@juju-b24bc9-mno-18:~# bash -ex /var/lib/dpkg/info/nova-common.postinst configure + '[' configure = configure ']' + getent group nova + getent passwd nova + '[' -z '' ']' + chown -R nova:nova /var/lib/nova/ + chown -R nova:nova /etc/nova + chown -R nova:adm /var/log/nova + '[' -z '' ']' + chown -R nova:nova /var/lib/nova/ + chmod 0640 /etc/nova/nova.conf + chmod 0640 /etc/nova/api-paste.ini + chmod 0750 /etc/nova + chmod 0750 /var/log/nova + chown root:root /etc/nova/rootwrap.conf + chown root:root /etc/nova/rootwrap.d + chmod 0755 /etc/nova/rootwrap.d + grep -qE '^(sql_)?connection( )?=.*' /etc/nova/nova.conf + su -s /bin/sh -c 'nova-manage db sync' nova Option "logdir" from group "DEFAULT" is deprecated. Use option "log-dir" from group "DEFAULT". Option "verbose" from group "DEFAULT" is deprecated for removal. Its value may be silently ignored in the future. ERROR: could not access cell mapping database - has api db been created? An error has occurred: Traceback (most recent call last): ... ValidationError: Migration cannot continue until all these have been migrated to the api database. Please run `nova-manage db online_migrations' on Newton code before continuing.There are still 5 unmigrated flavors. The condition to run the sync operation should be that the connection config key is defined in nova.conf # diff -u /var/lib/dpkg/info/nova-common.postinst ./nova-common.postinst --- /var/lib/dpkg/info/nova-common.postinst 2017-06-19 08:12:49.000000000 +0000 +++ ./nova-common.postinst 2017-08-25 13:08:48.852744427 +0000 @@ -47,8 +47,8 @@      chown root:root /etc/nova/rootwrap.d      chmod 0755 /etc/nova/rootwrap.d - if ! grep -qE "^(sql_)?connection( )?=.*" /etc/nova/nova.conf || \ - grep -qE "^(sql_)?connection.*sqlite.*" /etc/nova/nova.conf + if grep -qE "^(sql_)?connection( )?=.*" /etc/nova/nova.conf || \ + grep -qE "^(sql_)?connection.*sqlite.*" /etc/nova/nova.conf      then        su -s /bin/sh -c 'nova-manage db sync' nova      fi
2017-08-29 14:29:22 Corey Bryant description The original reason this bug was opened is that nova db sync is executed when the 'connection' is not defined. Let's fix that and at the same time drop all db syncs from OpenStack packages in Pike. When the 'connection' configuration key is NOT defined in /etc/nova/nova.conf the nova-common.postinst script still tries to run 'nova-manage db sync' root@juju-b24bc9-mno-18:~# grep connection /etc/nova/nova.conf root@juju-b24bc9-mno-18:~# dpkg-reconfigure nova-common Option "logdir" from group "DEFAULT" is deprecated. Use option "log-dir" from group "DEFAULT". Option "verbose" from group "DEFAULT" is deprecated for removal. Its value may be silently ignored in the future. ERROR: could not access cell mapping database - has api db been created? An error has occurred: Traceback (most recent call last):   File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 1602, in main     ret = fn(*fn_args, **fn_kwargs)   File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 645, in sync     return migration.db_sync(version)   File "/usr/lib/python2.7/dist-packages/nova/db/migration.py", line 26, in db_sync     return IMPL.db_sync(version=version, database=database, context=context)   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migration.py", line 57, in db_sync     repository, version)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade     return _migrate(url, repository, version, upgrade=True, err=err, **opts)   File "<decorator-gen-15>", line 2, in _migrate   File "/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 160, in with_engine     return f(*a, **kw)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate     schema.runchange(ver, change, changeset.step)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 93, in runchange     change.run(self.engine, step)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 148, in run     script_func(engine)   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migrate_repo/versions/345_require_online_migration_completion.py", line 44, in upgrade     raise exception.ValidationError(detail=msg) ValidationError: Migration cannot continue until all these have been migrated to the api database. Please run `nova-manage db online_migrations' on Newton code before continuing.There are still 5 unmigrated flavors. Running the postinst script manually with -x root@juju-b24bc9-mno-18:~# bash -ex /var/lib/dpkg/info/nova-common.postinst configure + '[' configure = configure ']' + getent group nova + getent passwd nova + '[' -z '' ']' + chown -R nova:nova /var/lib/nova/ + chown -R nova:nova /etc/nova + chown -R nova:adm /var/log/nova + '[' -z '' ']' + chown -R nova:nova /var/lib/nova/ + chmod 0640 /etc/nova/nova.conf + chmod 0640 /etc/nova/api-paste.ini + chmod 0750 /etc/nova + chmod 0750 /var/log/nova + chown root:root /etc/nova/rootwrap.conf + chown root:root /etc/nova/rootwrap.d + chmod 0755 /etc/nova/rootwrap.d + grep -qE '^(sql_)?connection( )?=.*' /etc/nova/nova.conf + su -s /bin/sh -c 'nova-manage db sync' nova Option "logdir" from group "DEFAULT" is deprecated. Use option "log-dir" from group "DEFAULT". Option "verbose" from group "DEFAULT" is deprecated for removal. Its value may be silently ignored in the future. ERROR: could not access cell mapping database - has api db been created? An error has occurred: Traceback (most recent call last): ... ValidationError: Migration cannot continue until all these have been migrated to the api database. Please run `nova-manage db online_migrations' on Newton code before continuing.There are still 5 unmigrated flavors. The condition to run the sync operation should be that the connection config key is defined in nova.conf # diff -u /var/lib/dpkg/info/nova-common.postinst ./nova-common.postinst --- /var/lib/dpkg/info/nova-common.postinst 2017-06-19 08:12:49.000000000 +0000 +++ ./nova-common.postinst 2017-08-25 13:08:48.852744427 +0000 @@ -47,8 +47,8 @@      chown root:root /etc/nova/rootwrap.d      chmod 0755 /etc/nova/rootwrap.d - if ! grep -qE "^(sql_)?connection( )?=.*" /etc/nova/nova.conf || \ - grep -qE "^(sql_)?connection.*sqlite.*" /etc/nova/nova.conf + if grep -qE "^(sql_)?connection( )?=.*" /etc/nova/nova.conf || \ + grep -qE "^(sql_)?connection.*sqlite.*" /etc/nova/nova.conf      then        su -s /bin/sh -c 'nova-manage db sync' nova      fi The original reason this bug was opened is that nova db sync is executed when the 'connection' is not defined. Let's fix that and at the same time drop all db syncs from OpenStack packages in Pike. More on the nova issue: When the 'connection' configuration key is NOT defined in /etc/nova/nova.conf the nova-common.postinst script still tries to run 'nova-manage db sync' root@juju-b24bc9-mno-18:~# grep connection /etc/nova/nova.conf root@juju-b24bc9-mno-18:~# dpkg-reconfigure nova-common Option "logdir" from group "DEFAULT" is deprecated. Use option "log-dir" from group "DEFAULT". Option "verbose" from group "DEFAULT" is deprecated for removal. Its value may be silently ignored in the future. ERROR: could not access cell mapping database - has api db been created? An error has occurred: Traceback (most recent call last):   File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 1602, in main     ret = fn(*fn_args, **fn_kwargs)   File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 645, in sync     return migration.db_sync(version)   File "/usr/lib/python2.7/dist-packages/nova/db/migration.py", line 26, in db_sync     return IMPL.db_sync(version=version, database=database, context=context)   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migration.py", line 57, in db_sync     repository, version)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade     return _migrate(url, repository, version, upgrade=True, err=err, **opts)   File "<decorator-gen-15>", line 2, in _migrate   File "/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 160, in with_engine     return f(*a, **kw)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate     schema.runchange(ver, change, changeset.step)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 93, in runchange     change.run(self.engine, step)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 148, in run     script_func(engine)   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migrate_repo/versions/345_require_online_migration_completion.py", line 44, in upgrade     raise exception.ValidationError(detail=msg) ValidationError: Migration cannot continue until all these have been migrated to the api database. Please run `nova-manage db online_migrations' on Newton code before continuing.There are still 5 unmigrated flavors. Running the postinst script manually with -x root@juju-b24bc9-mno-18:~# bash -ex /var/lib/dpkg/info/nova-common.postinst configure + '[' configure = configure ']' + getent group nova + getent passwd nova + '[' -z '' ']' + chown -R nova:nova /var/lib/nova/ + chown -R nova:nova /etc/nova + chown -R nova:adm /var/log/nova + '[' -z '' ']' + chown -R nova:nova /var/lib/nova/ + chmod 0640 /etc/nova/nova.conf + chmod 0640 /etc/nova/api-paste.ini + chmod 0750 /etc/nova + chmod 0750 /var/log/nova + chown root:root /etc/nova/rootwrap.conf + chown root:root /etc/nova/rootwrap.d + chmod 0755 /etc/nova/rootwrap.d + grep -qE '^(sql_)?connection( )?=.*' /etc/nova/nova.conf + su -s /bin/sh -c 'nova-manage db sync' nova Option "logdir" from group "DEFAULT" is deprecated. Use option "log-dir" from group "DEFAULT". Option "verbose" from group "DEFAULT" is deprecated for removal. Its value may be silently ignored in the future. ERROR: could not access cell mapping database - has api db been created? An error has occurred: Traceback (most recent call last): ... ValidationError: Migration cannot continue until all these have been migrated to the api database. Please run `nova-manage db online_migrations' on Newton code before continuing.There are still 5 unmigrated flavors. The condition to run the sync operation should be that the connection config key is defined in nova.conf # diff -u /var/lib/dpkg/info/nova-common.postinst ./nova-common.postinst --- /var/lib/dpkg/info/nova-common.postinst 2017-06-19 08:12:49.000000000 +0000 +++ ./nova-common.postinst 2017-08-25 13:08:48.852744427 +0000 @@ -47,8 +47,8 @@      chown root:root /etc/nova/rootwrap.d      chmod 0755 /etc/nova/rootwrap.d - if ! grep -qE "^(sql_)?connection( )?=.*" /etc/nova/nova.conf || \ - grep -qE "^(sql_)?connection.*sqlite.*" /etc/nova/nova.conf + if grep -qE "^(sql_)?connection( )?=.*" /etc/nova/nova.conf || \ + grep -qE "^(sql_)?connection.*sqlite.*" /etc/nova/nova.conf      then        su -s /bin/sh -c 'nova-manage db sync' nova      fi
2017-08-29 14:36:52 Corey Bryant bug task added ironic (Ubuntu)
2017-08-29 14:37:15 Corey Bryant bug task added nova (Ubuntu Artful)
2017-08-29 14:37:15 Corey Bryant bug task added ironic (Ubuntu Artful)
2017-08-29 14:37:30 Corey Bryant bug task added nova (Ubuntu Xenial)
2017-08-29 14:37:30 Corey Bryant bug task added ironic (Ubuntu Xenial)
2017-08-29 14:37:38 Corey Bryant bug task added nova (Ubuntu Zesty)
2017-08-29 14:37:38 Corey Bryant bug task added ironic (Ubuntu Zesty)
2017-08-29 14:38:09 Corey Bryant ironic (Ubuntu Zesty): status New Invalid
2017-08-29 14:38:12 Corey Bryant ironic (Ubuntu Xenial): status New Invalid
2017-08-29 14:38:20 Corey Bryant ironic (Ubuntu Artful): status New Triaged
2017-08-29 14:38:24 Corey Bryant ironic (Ubuntu Artful): importance Undecided Medium
2017-08-29 14:38:29 Corey Bryant nova (Ubuntu Artful): importance Undecided High
2017-08-29 14:38:34 Corey Bryant nova (Ubuntu Zesty): status New Triaged
2017-08-29 14:38:37 Corey Bryant nova (Ubuntu Xenial): status New Triaged
2017-08-29 14:38:39 Corey Bryant nova (Ubuntu Xenial): importance Undecided Critical
2017-08-29 14:38:42 Corey Bryant nova (Ubuntu Xenial): importance Critical High
2017-08-29 14:38:44 Corey Bryant nova (Ubuntu Zesty): importance Undecided High
2017-08-29 14:42:40 Corey Bryant bug task added ceilometer (Ubuntu)
2017-08-29 14:42:51 Corey Bryant ceilometer (Ubuntu Artful): importance Undecided Medium
2017-08-29 14:42:51 Corey Bryant ceilometer (Ubuntu Artful): status New Triaged
2017-08-29 14:43:00 Corey Bryant ceilometer (Ubuntu Zesty): status New Invalid
2017-08-29 14:43:09 Corey Bryant ceilometer (Ubuntu Xenial): status New Invalid
2017-08-29 14:45:40 Corey Bryant bug task added cinder (Ubuntu)
2017-08-29 14:45:49 Corey Bryant cinder (Ubuntu Xenial): status New Invalid
2017-08-29 14:46:17 Corey Bryant cinder (Ubuntu Zesty): status New Invalid
2017-08-29 14:46:31 Corey Bryant cinder (Ubuntu Artful): importance Undecided Medium
2017-08-29 14:46:31 Corey Bryant cinder (Ubuntu Artful): status New Triaged
2017-08-29 14:49:17 Corey Bryant bug task added panko (Ubuntu)
2017-08-29 14:49:26 Corey Bryant panko (Ubuntu Xenial): status New Invalid
2017-08-29 14:49:36 Corey Bryant panko (Ubuntu Zesty): status New Invalid
2017-08-29 14:50:01 Corey Bryant panko (Ubuntu Artful): importance Undecided Medium
2017-08-29 14:50:01 Corey Bryant panko (Ubuntu Artful): status New Triaged
2017-08-29 14:51:48 Corey Bryant bug task added openstack-trove (Ubuntu)
2017-08-29 14:51:58 Corey Bryant openstack-trove (Ubuntu Xenial): status New Invalid
2017-08-29 14:52:07 Corey Bryant openstack-trove (Ubuntu Zesty): status New Invalid
2017-08-29 14:52:18 Corey Bryant openstack-trove (Ubuntu Artful): importance Undecided Medium
2017-08-29 14:52:18 Corey Bryant openstack-trove (Ubuntu Artful): status New Triaged
2017-08-29 14:55:27 Corey Bryant bug task added glance (Ubuntu)
2017-08-29 14:55:38 Corey Bryant glance (Ubuntu Xenial): status New Invalid
2017-08-29 14:55:50 Corey Bryant glance (Ubuntu Zesty): status New Invalid
2017-08-29 14:56:20 Corey Bryant glance (Ubuntu Artful): importance Undecided Medium
2017-08-29 14:56:20 Corey Bryant glance (Ubuntu Artful): status New Triaged
2017-08-29 14:58:19 Corey Bryant bug task added aodh (Ubuntu)
2017-08-29 14:58:27 Corey Bryant aodh (Ubuntu Xenial): status New Invalid
2017-08-29 14:58:41 Corey Bryant aodh (Ubuntu Zesty): status New Invalid
2017-08-29 14:59:07 Corey Bryant aodh (Ubuntu Artful): importance Undecided Medium
2017-08-29 14:59:07 Corey Bryant aodh (Ubuntu Artful): status New Triaged
2017-08-29 15:19:50 Corey Bryant bug task added manila (Ubuntu)
2017-08-29 15:20:00 Corey Bryant manila (Ubuntu Xenial): status New Invalid
2017-08-29 15:20:10 Corey Bryant manila (Ubuntu Zesty): status New Invalid
2017-08-29 15:20:23 Corey Bryant manila (Ubuntu Artful): importance Undecided Medium
2017-08-29 15:20:23 Corey Bryant manila (Ubuntu Artful): status New Triaged
2017-08-29 15:22:09 Launchpad Janitor ironic (Ubuntu Artful): status Triaged Fix Released
2017-08-29 15:23:05 Corey Bryant bug task added keystone (Ubuntu)
2017-08-29 15:23:14 Corey Bryant keystone (Ubuntu Xenial): status New Invalid
2017-08-29 15:23:26 Corey Bryant keystone (Ubuntu Zesty): status New Invalid
2017-08-29 15:23:38 Corey Bryant keystone (Ubuntu Artful): importance Undecided Medium
2017-08-29 15:23:38 Corey Bryant keystone (Ubuntu Artful): status New Triaged
2017-08-29 15:36:03 Launchpad Janitor aodh (Ubuntu Artful): status Triaged Fix Released
2017-08-29 15:36:10 Launchpad Janitor ceilometer (Ubuntu Artful): status Triaged Fix Released
2017-08-29 15:46:09 Launchpad Janitor panko (Ubuntu Artful): status Triaged Fix Released
2017-08-29 15:46:14 Launchpad Janitor glance (Ubuntu Artful): status Triaged Fix Released
2017-08-29 15:51:49 Launchpad Janitor openstack-trove (Ubuntu Artful): status Triaged Fix Released
2017-08-29 16:14:34 Launchpad Janitor manila (Ubuntu Artful): status Triaged Fix Released
2017-08-29 16:35:53 Launchpad Janitor keystone (Ubuntu Artful): status Triaged Fix Released
2017-08-29 19:20:46 Felipe Reyes nova (Ubuntu Zesty): assignee Felipe Reyes (freyes)
2017-08-29 19:21:09 Felipe Reyes nova (Ubuntu Xenial): assignee Felipe Reyes (freyes)
2017-08-29 19:22:13 Felipe Reyes bug task added cloud-archive
2017-08-29 19:26:43 Billy Olsen nominated for series cloud-archive/newton
2017-08-29 19:26:43 Billy Olsen nominated for series cloud-archive/ocata
2017-08-29 19:26:43 Billy Olsen nominated for series cloud-archive/pike
2017-08-29 19:31:24 Felipe Reyes attachment added lp1713059_zesty.debdiff https://bugs.launchpad.net/cloud-archive/+bug/1713059/+attachment/4941000/+files/lp1713059_zesty.debdiff
2017-08-29 19:31:45 Felipe Reyes attachment added lp1713059_newton.debdiff https://bugs.launchpad.net/cloud-archive/+bug/1713059/+attachment/4941001/+files/lp1713059_newton.debdiff
2017-08-29 19:32:03 Felipe Reyes attachment added lp1713059_xenial.debdiff https://bugs.launchpad.net/cloud-archive/+bug/1713059/+attachment/4941002/+files/lp1713059_xenial.debdiff
2017-08-29 19:32:33 Felipe Reyes attachment removed lp1713059_artful.debdiff https://bugs.launchpad.net/cloud-archive/+bug/1713059/+attachment/4940264/+files/lp1713059_artful.debdiff
2017-08-29 19:44:03 Felipe Reyes description The original reason this bug was opened is that nova db sync is executed when the 'connection' is not defined. Let's fix that and at the same time drop all db syncs from OpenStack packages in Pike. More on the nova issue: When the 'connection' configuration key is NOT defined in /etc/nova/nova.conf the nova-common.postinst script still tries to run 'nova-manage db sync' root@juju-b24bc9-mno-18:~# grep connection /etc/nova/nova.conf root@juju-b24bc9-mno-18:~# dpkg-reconfigure nova-common Option "logdir" from group "DEFAULT" is deprecated. Use option "log-dir" from group "DEFAULT". Option "verbose" from group "DEFAULT" is deprecated for removal. Its value may be silently ignored in the future. ERROR: could not access cell mapping database - has api db been created? An error has occurred: Traceback (most recent call last):   File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 1602, in main     ret = fn(*fn_args, **fn_kwargs)   File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 645, in sync     return migration.db_sync(version)   File "/usr/lib/python2.7/dist-packages/nova/db/migration.py", line 26, in db_sync     return IMPL.db_sync(version=version, database=database, context=context)   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migration.py", line 57, in db_sync     repository, version)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade     return _migrate(url, repository, version, upgrade=True, err=err, **opts)   File "<decorator-gen-15>", line 2, in _migrate   File "/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 160, in with_engine     return f(*a, **kw)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate     schema.runchange(ver, change, changeset.step)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 93, in runchange     change.run(self.engine, step)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 148, in run     script_func(engine)   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migrate_repo/versions/345_require_online_migration_completion.py", line 44, in upgrade     raise exception.ValidationError(detail=msg) ValidationError: Migration cannot continue until all these have been migrated to the api database. Please run `nova-manage db online_migrations' on Newton code before continuing.There are still 5 unmigrated flavors. Running the postinst script manually with -x root@juju-b24bc9-mno-18:~# bash -ex /var/lib/dpkg/info/nova-common.postinst configure + '[' configure = configure ']' + getent group nova + getent passwd nova + '[' -z '' ']' + chown -R nova:nova /var/lib/nova/ + chown -R nova:nova /etc/nova + chown -R nova:adm /var/log/nova + '[' -z '' ']' + chown -R nova:nova /var/lib/nova/ + chmod 0640 /etc/nova/nova.conf + chmod 0640 /etc/nova/api-paste.ini + chmod 0750 /etc/nova + chmod 0750 /var/log/nova + chown root:root /etc/nova/rootwrap.conf + chown root:root /etc/nova/rootwrap.d + chmod 0755 /etc/nova/rootwrap.d + grep -qE '^(sql_)?connection( )?=.*' /etc/nova/nova.conf + su -s /bin/sh -c 'nova-manage db sync' nova Option "logdir" from group "DEFAULT" is deprecated. Use option "log-dir" from group "DEFAULT". Option "verbose" from group "DEFAULT" is deprecated for removal. Its value may be silently ignored in the future. ERROR: could not access cell mapping database - has api db been created? An error has occurred: Traceback (most recent call last): ... ValidationError: Migration cannot continue until all these have been migrated to the api database. Please run `nova-manage db online_migrations' on Newton code before continuing.There are still 5 unmigrated flavors. The condition to run the sync operation should be that the connection config key is defined in nova.conf # diff -u /var/lib/dpkg/info/nova-common.postinst ./nova-common.postinst --- /var/lib/dpkg/info/nova-common.postinst 2017-06-19 08:12:49.000000000 +0000 +++ ./nova-common.postinst 2017-08-25 13:08:48.852744427 +0000 @@ -47,8 +47,8 @@      chown root:root /etc/nova/rootwrap.d      chmod 0755 /etc/nova/rootwrap.d - if ! grep -qE "^(sql_)?connection( )?=.*" /etc/nova/nova.conf || \ - grep -qE "^(sql_)?connection.*sqlite.*" /etc/nova/nova.conf + if grep -qE "^(sql_)?connection( )?=.*" /etc/nova/nova.conf || \ + grep -qE "^(sql_)?connection.*sqlite.*" /etc/nova/nova.conf      then        su -s /bin/sh -c 'nova-manage db sync' nova      fi [Impact] nova-compute service does not need access to the database, systems where nova.conf is configured without a database connection the nova-common package will fail to get configured [Test Case] Using this deployer bundle -> http://paste.ubuntu.com/25426891/ juju-deployer -c bundle.yaml -d -v -s 10 xenial-mitaka # once everything is installed git clone https://github.com/openstack-charmers/openstack-charms-tools.git cd openstack-charms-tools/ ./os-upgrade.py -o cloud:xenial-newton Expected result: nova-compute units upgrade their packages to newton without errors Actual result: nova-common fails to configure itself in the nova-compute units [Regression Potential] This change was tested in a staging environment and no regressions were detected, but any possible regression will express itself as a failure running "nova-manage db sync". [Other Info] The original reason this bug was opened is that nova db sync is executed when the 'connection' is not defined. Let's fix that and at the same time drop all db syncs from OpenStack packages in Pike. More on the nova issue: When the 'connection' configuration key is NOT defined in /etc/nova/nova.conf the nova-common.postinst script still tries to run 'nova-manage db sync' root@juju-b24bc9-mno-18:~# grep connection /etc/nova/nova.conf root@juju-b24bc9-mno-18:~# dpkg-reconfigure nova-common Option "logdir" from group "DEFAULT" is deprecated. Use option "log-dir" from group "DEFAULT". Option "verbose" from group "DEFAULT" is deprecated for removal. Its value may be silently ignored in the future. ERROR: could not access cell mapping database - has api db been created? An error has occurred: Traceback (most recent call last):   File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 1602, in main     ret = fn(*fn_args, **fn_kwargs)   File "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 645, in sync     return migration.db_sync(version)   File "/usr/lib/python2.7/dist-packages/nova/db/migration.py", line 26, in db_sync     return IMPL.db_sync(version=version, database=database, context=context)   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migration.py", line 57, in db_sync     repository, version)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade     return _migrate(url, repository, version, upgrade=True, err=err, **opts)   File "<decorator-gen-15>", line 2, in _migrate   File "/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 160, in with_engine     return f(*a, **kw)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate     schema.runchange(ver, change, changeset.step)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 93, in runchange     change.run(self.engine, step)   File "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 148, in run     script_func(engine)   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migrate_repo/versions/345_require_online_migration_completion.py", line 44, in upgrade     raise exception.ValidationError(detail=msg) ValidationError: Migration cannot continue until all these have been migrated to the api database. Please run `nova-manage db online_migrations' on Newton code before continuing.There are still 5 unmigrated flavors. Running the postinst script manually with -x root@juju-b24bc9-mno-18:~# bash -ex /var/lib/dpkg/info/nova-common.postinst configure + '[' configure = configure ']' + getent group nova + getent passwd nova + '[' -z '' ']' + chown -R nova:nova /var/lib/nova/ + chown -R nova:nova /etc/nova + chown -R nova:adm /var/log/nova + '[' -z '' ']' + chown -R nova:nova /var/lib/nova/ + chmod 0640 /etc/nova/nova.conf + chmod 0640 /etc/nova/api-paste.ini + chmod 0750 /etc/nova + chmod 0750 /var/log/nova + chown root:root /etc/nova/rootwrap.conf + chown root:root /etc/nova/rootwrap.d + chmod 0755 /etc/nova/rootwrap.d + grep -qE '^(sql_)?connection( )?=.*' /etc/nova/nova.conf + su -s /bin/sh -c 'nova-manage db sync' nova Option "logdir" from group "DEFAULT" is deprecated. Use option "log-dir" from group "DEFAULT". Option "verbose" from group "DEFAULT" is deprecated for removal. Its value may be silently ignored in the future. ERROR: could not access cell mapping database - has api db been created? An error has occurred: Traceback (most recent call last): ... ValidationError: Migration cannot continue until all these have been migrated to the api database. Please run `nova-manage db online_migrations' on Newton code before continuing.There are still 5 unmigrated flavors. The condition to run the sync operation should be that the connection config key is defined in nova.conf # diff -u /var/lib/dpkg/info/nova-common.postinst ./nova-common.postinst --- /var/lib/dpkg/info/nova-common.postinst 2017-06-19 08:12:49.000000000 +0000 +++ ./nova-common.postinst 2017-08-25 13:08:48.852744427 +0000 @@ -47,8 +47,8 @@      chown root:root /etc/nova/rootwrap.d      chmod 0755 /etc/nova/rootwrap.d - if ! grep -qE "^(sql_)?connection( )?=.*" /etc/nova/nova.conf || \ - grep -qE "^(sql_)?connection.*sqlite.*" /etc/nova/nova.conf + if grep -qE "^(sql_)?connection( )?=.*" /etc/nova/nova.conf || \ + grep -qE "^(sql_)?connection.*sqlite.*" /etc/nova/nova.conf      then        su -s /bin/sh -c 'nova-manage db sync' nova      fi
2017-08-29 22:14:41 Launchpad Janitor nova (Ubuntu Artful): status Confirmed Fix Released
2017-08-30 12:32:31 Launchpad Janitor cinder (Ubuntu Artful): status Triaged Fix Released
2017-08-31 18:11:23 Corey Bryant bug task added cloud-archive/pike
2017-08-31 18:11:33 Corey Bryant bug task added cloud-archive/ocata
2017-08-31 18:11:56 Corey Bryant bug task added cloud-archive/newton
2017-08-31 18:12:22 Corey Bryant nominated for series cloud-archive/mitaka
2017-08-31 18:12:22 Corey Bryant bug task added cloud-archive/mitaka
2017-08-31 18:13:56 Corey Bryant cloud-archive/mitaka: importance Undecided High
2017-08-31 18:13:56 Corey Bryant cloud-archive/mitaka: status New Triaged
2017-08-31 18:14:13 Corey Bryant cloud-archive/newton: importance Undecided High
2017-08-31 18:14:13 Corey Bryant cloud-archive/newton: status New Triaged
2017-08-31 18:14:27 Corey Bryant cloud-archive/ocata: importance Undecided High
2017-08-31 18:14:27 Corey Bryant cloud-archive/ocata: status New Triaged
2017-08-31 18:14:41 Corey Bryant cloud-archive/pike: importance Undecided High
2017-08-31 18:14:41 Corey Bryant cloud-archive/pike: status New Triaged
2017-09-01 13:32:18 James Page cloud-archive/pike: status Triaged Fix Released
2017-09-07 20:41:45 Brian Murray nova (Ubuntu Xenial): status Triaged Fix Committed
2017-09-07 20:41:56 Brian Murray bug added subscriber Ubuntu Stable Release Updates Team
2017-09-07 20:41:59 Brian Murray bug added subscriber SRU Verification
2017-09-07 20:42:02 Brian Murray tags patch sts patch sts verification-needed verification-needed-xenial
2017-09-07 20:43:09 Brian Murray removed subscriber Ubuntu Sponsors Team
2017-09-14 17:51:57 Brian Murray nova (Ubuntu Zesty): status Triaged Fix Committed
2017-09-14 17:52:12 Brian Murray tags patch sts verification-needed verification-needed-xenial patch sts verification-needed verification-needed-xenial verification-needed-zesty
2017-09-18 17:52:25 Ryan Beisner cloud-archive/mitaka: status Triaged Fix Committed
2017-09-18 17:52:27 Ryan Beisner tags patch sts verification-needed verification-needed-xenial verification-needed-zesty patch sts verification-mitaka-needed verification-needed verification-needed-xenial verification-needed-zesty
2017-09-18 17:53:18 Ryan Beisner cloud-archive/newton: status Triaged Fix Committed
2017-09-18 17:53:21 Ryan Beisner tags patch sts verification-mitaka-needed verification-needed verification-needed-xenial verification-needed-zesty patch sts verification-mitaka-needed verification-needed verification-needed-xenial verification-needed-zesty verification-newton-needed
2017-09-18 17:54:01 Ryan Beisner cloud-archive/ocata: status Triaged Fix Committed
2017-09-18 17:54:04 Ryan Beisner tags patch sts verification-mitaka-needed verification-needed verification-needed-xenial verification-needed-zesty verification-newton-needed patch sts verification-mitaka-needed verification-needed verification-needed-xenial verification-needed-zesty verification-newton-needed verification-ocata-needed
2017-09-27 15:00:25 Felipe Reyes tags patch sts verification-mitaka-needed verification-needed verification-needed-xenial verification-needed-zesty verification-newton-needed verification-ocata-needed patch sts verification-done-zesty verification-mitaka-needed verification-needed verification-needed-xenial verification-newton-needed verification-ocata-needed
2017-09-27 18:44:13 Felipe Reyes tags patch sts verification-done-zesty verification-mitaka-needed verification-needed verification-needed-xenial verification-newton-needed verification-ocata-needed patch sts verification-done-zesty verification-mitaka-needed verification-needed verification-needed-xenial verification-newton-done verification-ocata-done
2017-09-27 20:55:34 Felipe Reyes tags patch sts verification-done-zesty verification-mitaka-needed verification-needed verification-needed-xenial verification-newton-done verification-ocata-done patch sts verification-done verification-done-xenial verification-done-zesty verification-mitaka-done verification-newton-done verification-ocata-done
2017-09-28 17:31:05 Launchpad Janitor nova (Ubuntu Zesty): status Fix Committed Fix Released
2017-09-28 18:07:42 Felipe Reyes tags patch sts verification-done verification-done-xenial verification-done-zesty verification-mitaka-done verification-newton-done verification-ocata-done patch sts verification-done-zesty verification-failed verification-failed-xenial verification-mitaka-failed verification-newton-done verification-ocata-done
2017-10-05 17:46:24 Brian Murray tags patch sts verification-done-zesty verification-failed verification-failed-xenial verification-mitaka-failed verification-newton-done verification-ocata-done patch sts verification-done-zesty verification-mitaka-failed verification-needed verification-needed-xenial verification-newton-done verification-ocata-done
2017-10-18 21:56:41 Felipe Reyes tags patch sts verification-done-zesty verification-mitaka-failed verification-needed verification-needed-xenial verification-newton-done verification-ocata-done patch sts verification-done-xenial verification-done-zesty verification-mitaka-failed verification-needed verification-newton-done verification-ocata-done
2017-10-19 17:44:50 Launchpad Janitor nova (Ubuntu Xenial): status Fix Committed Fix Released
2018-10-03 17:10:12 Corey Bryant cloud-archive/mitaka: status Fix Committed Fix Released
2018-10-03 17:10:23 Corey Bryant cloud-archive/newton: status Fix Committed Fix Released
2018-10-03 17:10:33 Corey Bryant cloud-archive/ocata: status Fix Committed Fix Released