[Juno] keystone deb package can't be installed correctly

[Sergey Kolekonov]

How to reproduce:
- Install keystone ubuntu package from master (6.0) branch on Ubuntu 12.04

The following lines can be found in apt's output:

Setting up keystone (1:2014.2.b3-fuel5.1~mira1) ...
2014-09-17 11:38:28.652 4293 CRITICAL keystone [-] OperationalError: (OperationalError) database is locked u'DELETE FROM user_project_metadata' ()
2014-09-17 11:38:28.652 4293 TRACE keystone Traceback (most recent call last):
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/bin/keystone-manage", line 44, in <module>
2014-09-17 11:38:28.652 4293 TRACE keystone cli.main(argv=sys.argv, config_files=config_files)
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/keystone/cli.py", line 292, in main
2014-09-17 11:38:28.652 4293 TRACE keystone CONF.command.cmd_class.main()
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/keystone/cli.py", line 74, in main
2014-09-17 11:38:28.652 4293 TRACE keystone migration_helpers.sync_database_to_version(extension, version)
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 204, in sync_database_to_version
2014-09-17 11:38:28.652 4293 TRACE keystone _sync_common_repo(version)
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 160, in _sync_common_repo
2014-09-17 11:38:28.652 4293 TRACE keystone init_version=init_version)
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/migration.py", line 79, in db_sync
2014-09-17 11:38:28.652 4293 TRACE keystone return versioning_api.upgrade(engine, repository, version)
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade
2014-09-17 11:38:28.652 4293 TRACE keystone return _migrate(url, repository, version, upgrade=True, err=err, **opts)
2014-09-17 11:38:28.652 4293 TRACE keystone File "<string>", line 2, in _migrate
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 160, in with_engine
2014-09-17 11:38:28.652 4293 TRACE keystone return f(*a, **kw)
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate
2014-09-17 11:38:28.652 4293 TRACE keystone schema.runchange(ver, change, changeset.step)
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 93, in runchange
2014-09-17 11:38:28.652 4293 TRACE keystone change.run(self.engine, step)
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 148, in run
2014-09-17 11:38:28.652 4293 TRACE keystone script_func(engine)
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migrate_repo/versions/039_grant_to_assignment.py", line 223, in upgrade
2014-09-17 11:38:28.652 4293 TRACE keystone migrate_grant_table(meta, migrate_engine, session, table_name)
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migrate_repo/versions/039_grant_to_assignment.py", line 85, in migrate_grant_table
2014-09-17 11:38:28.652 4293 TRACE keystone migrate_engine.execute(upgrade_table.delete())
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1614, in execute
2014-09-17 11:38:28.652 4293 TRACE keystone return connection.execute(statement, *multiparams, **params)
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 662, in execute
2014-09-17 11:38:28.652 4293 TRACE keystone params)
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 761, in _execute_clauseelement
2014-09-17 11:38:28.652 4293 TRACE keystone compiled_sql, distilled_params
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 874, in _execute_context
2014-09-17 11:38:28.652 4293 TRACE keystone context)
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/compat/handle_error.py", line 125, in _handle_dbapi_exception
2014-09-17 11:38:28.652 4293 TRACE keystone six.reraise(type(newraise), newraise, sys.exc_info()[2])
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/compat/handle_error.py", line 102, in _handle_dbapi_exception
2014-09-17 11:38:28.652 4293 TRACE keystone per_fn = fn(ctx)
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/exc_filters.py", line 323, in handler
2014-09-17 11:38:28.652 4293 TRACE keystone context.is_disconnect)
2014-09-17 11:38:28.652 4293 TRACE keystone File "/usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/exc_filters.py", line 254, in _raise_operational_errors_directly_filter
2014-09-17 11:38:28.652 4293 TRACE keystone raise operational_error
2014-09-17 11:38:28.652 4293 TRACE keystone OperationalError: (OperationalError) database is locked u'DELETE FROM user_project_metadata' ()
2014-09-17 11:38:28.652 4293 TRACE keystone
dpkg: error processing keystone (--configure):
 subprocess installed post-installation script returned error exit status 1

The problem seems to be caused by debian/patches/sql_connection.patch (from package specs). It sets default db connection to sqlite database

[OSCI Robot (oscirobot)]

Package keystone has been built from changeset: http://gerrit.mirantis.com/28395
RPM Repository URL: http://osci-obs.vm.mirantis.net:82/centos-fuel-master-28395/centos

[OSCI Robot (oscirobot)]

Package keystone has been built from changeset: http://gerrit.mirantis.com/28395
DEB Repository URL: http://osci-obs.vm.mirantis.net:82/ubuntu-fuel-master-28395/ubuntu

[OSCI Robot (oscirobot)]

Package keystone has been built from changeset: http://gerrit.mirantis.com/28395
RPM Repository URL: http://osci-obs.vm.mirantis.net:82/centos-fuel-master-28395/centos

[OSCI Robot (oscirobot)]

Package keystone has been built from changeset: http://gerrit.mirantis.com/28395
DEB Repository URL: http://osci-obs.vm.mirantis.net:82/ubuntu-fuel-master-28395/ubuntu

[OSCI Robot (oscirobot)]

Package keystone has been built from changeset: http://gerrit.mirantis.com/28395
RPM Repository URL: http://osci-obs.vm.mirantis.net:82/centos-fuel-master/centos

[OSCI Robot (oscirobot)]

Package keystone has been built from changeset: http://gerrit.mirantis.com/28395
DEB Repository URL: http://osci-obs.vm.mirantis.net:82/ubuntu-fuel-master/ubuntu

[Sergey Kolekonov (skolekonov)]

The problem is fixed by http://gerrit.mirantis.com/28395

[Ivan Berezovskiy (iberezovskiy)]

Verified on
{"build_id": "2014-12-09_22-41-06", "ostf_sha": "a9afb68710d809570460c29d6c3293219d3624d4", "build_number": "49", "auth_required": true, "api": "1.0", "nailgun_sha": "22bd43b89a17843f9199f92d61fc86cb0f8772f1", "production": "docker", "fuelmain_sha": "3aab16667f47dd8384904e27f70f7a87ba15f4ee", "astute_sha": "16b252d93be6aaa73030b8100cf8c5ca6a970a91", "feature_groups": ["mirantis"], "release": "6.0", "release_versions": {"2014.2-6.0": {"VERSION": {"build_id": "2014-12-09_22-41-06", "ostf_sha": "a9afb68710d809570460c29d6c3293219d3624d4", "build_number": "49", "api": "1.0", "nailgun_sha": "22bd43b89a17843f9199f92d61fc86cb0f8772f1", "production": "docker", "fuelmain_sha": "3aab16667f47dd8384904e27f70f7a87ba15f4ee", "astute_sha": "16b252d93be6aaa73030b8100cf8c5ca6a970a91", "feature_groups": ["mirantis"], "release": "6.0", "fuellib_sha": "2c99931072d951301d395ebd5bf45c8d401301bb"}}}, "fuellib_sha": "2c99931072d951301d395ebd5bf45c8d401301bb"}

http://paste.openstack.org/show/152749/