nova team mailing list archive
-
nova team
-
Mailing list archive
-
Message #00235
Database is locked after running nova-manage
When I ran
bin/nova-manage project create admin admin
Nova-volume said this:
-------------------------
ERROR:root:model server went away
Traceback (most recent call last):
File "/home/rudd-o/openstack/nova/nova/service.py", line 139, in
report_state
service_ref = db.service_get(context, self.service_id)
File "/home/rudd-o/openstack/nova/nova/db/api.py", line 56, in service_get
return IMPL.service_get(context, service_id)
File "/home/rudd-o/openstack/nova/nova/db/sqlalchemy/api.py", line 50, in
service_get
return models.Service.find(service_id)
File "/home/rudd-o/openstack/nova/nova/db/sqlalchemy/models.py", line 79, in
find
).filter_by(deleted=deleted
File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1522,
in one
ret = list(self)
File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565,
in __iter__
return self._execute_and_instances(context)
File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570,
in _execute_and_instances
mapper=self._mapper_zero_or_none())
File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735,
in execute
clause, params or {})
File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line
1157, in execute
params)
File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line
1237, in _execute_clauseelement
return self.__execute_context(context)
File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line
1268, in __execute_context
context.parameters[0], context=context)
File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line
1367, in _cursor_execute
context)
File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line
1360, in _cursor_execute
context)
File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line
288, in do_execute
cursor.execute(statement, parameters)
OperationalError: (OperationalError) database is locked u'SELECT
services.created_at AS services_created_at, services.updated_at AS
services_updated_at, services.deleted_at AS services_deleted_at,
services.deleted AS services_deleted, services.id AS services_id,
services.host AS services_host, services.binary AS services_binary,
services.topic AS services_topic, services.report_count AS
services_report_count \nFROM services \nWHERE services.id = ? AND
services.deleted = ?' (2, False)
2010-09-16 14:19:17-0700 [-] (root): ERROR model server went away
2010-09-16 14:19:17-0700 [-] Traceback (most recent call last):
2010-09-16 14:19:17-0700 [-] File "/home/rudd-
o/openstack/nova/nova/service.py", line 139, in report_state
2010-09-16 14:19:17-0700 [-] service_ref = db.service_get(context,
self.service_id)
2010-09-16 14:19:17-0700 [-] File "/home/rudd-
o/openstack/nova/nova/db/api.py", line 56, in service_get
2010-09-16 14:19:17-0700 [-] return IMPL.service_get(context, service_id)
2010-09-16 14:19:17-0700 [-] File "/home/rudd-
o/openstack/nova/nova/db/sqlalchemy/api.py", line 50, in service_get
2010-09-16 14:19:17-0700 [-] return models.Service.find(service_id)
2010-09-16 14:19:17-0700 [-] File "/home/rudd-
o/openstack/nova/nova/db/sqlalchemy/models.py", line 79, in find
2010-09-16 14:19:17-0700 [-] ).filter_by(deleted=deleted
2010-09-16 14:19:17-0700 [-] File "/usr/lib/python2.6/dist-
packages/sqlalchemy/orm/query.py", line 1522, in one
2010-09-16 14:19:17-0700 [-] ret = list(self)
2010-09-16 14:19:17-0700 [-] File "/usr/lib/python2.6/dist-
packages/sqlalchemy/orm/query.py", line 1565, in __iter__
2010-09-16 14:19:17-0700 [-] return self._execute_and_instances(context)
2010-09-16 14:19:17-0700 [-] File "/usr/lib/python2.6/dist-
packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances
2010-09-16 14:19:17-0700 [-] mapper=self._mapper_zero_or_none())
2010-09-16 14:19:17-0700 [-] File "/usr/lib/python2.6/dist-
packages/sqlalchemy/orm/session.py", line 735, in execute
2010-09-16 14:19:17-0700 [-] clause, params or {})
2010-09-16 14:19:17-0700 [-] File "/usr/lib/python2.6/dist-
packages/sqlalchemy/engine/base.py", line 1157, in execute
2010-09-16 14:19:17-0700 [-] params)
2010-09-16 14:19:17-0700 [-] File "/usr/lib/python2.6/dist-
packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement
2010-09-16 14:19:17-0700 [-] return self.__execute_context(context)
2010-09-16 14:19:17-0700 [-] File "/usr/lib/python2.6/dist-
packages/sqlalchemy/engine/base.py", line 1268, in __execute_context
2010-09-16 14:19:17-0700 [-] context.parameters[0], context=context)
2010-09-16 14:19:17-0700 [-] File "/usr/lib/python2.6/dist-
packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute
2010-09-16 14:19:17-0700 [-] context)
2010-09-16 14:19:17-0700 [-] File "/usr/lib/python2.6/dist-
packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute
2010-09-16 14:19:17-0700 [-] context)
2010-09-16 14:19:17-0700 [-] File "/usr/lib/python2.6/dist-
packages/sqlalchemy/engine/default.py", line 288, in do_execute
2010-09-16 14:19:17-0700 [-] cursor.execute(statement, parameters)
2010-09-16 14:19:17-0700 [-] OperationalError: (OperationalError) database is
locked u'SELECT services.created_at AS services_created_at,
services.updated_at AS services_updated_at, services.deleted_at AS
services_deleted_at, services.deleted AS services_deleted, services.id AS
services_id, services.host AS services_host, services.binary AS
services_binary, services.topic AS services_topic, services.report_count AS
services_report_count \nFROM services \nWHERE services.id = ? AND
services.deleted = ?' (2, False)
ERROR:root:Recovered model server connection!
2010-09-16 14:19:52-0700 [-] (root): ERROR Recovered model server connection
---------------------------
Identical tracebacks in nova-network and nova-compute.
I am stuck here :-)
Follow ups