← Back to team overview

nova team mailing list archive

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