nova team mailing list archive

Thread
Date
Re: Database is locked after running nova-manage

To: "Manuel Amador (Rudd-O)" <rudd-o@xxxxxxxxxx>
From: Vishvananda Ishaya <vishvananda@xxxxxxxxx>
Date: Thu, 16 Sep 2010 14:50:24 -0700
Cc: nova@xxxxxxxxxxxxxxxxxxx
In-reply-to: <201009161420.16679.rudd-o@rudd-o.com>
Those errors are normal.  SQLite isn't very good with multiple threads, but it doesn't actually cause any real problems.

Don't know why redis wasn't installed, it should have gotten it from the pip requires.

You can ignore the scheduler error, it is in the scheduler branch, which hasn't been merged into trunk yet.

nova uses python-gflags.  To set flags you can either use --FLAGNAME=FLAGVALUE on the commandline when you run each of the bins or you can stick a bunch of them into a file with one line per flag, like so
--s3_url=127.0.0.1
--auth_driver=nova.auth.ldapdriver.LdapDriver
and specify the file on the commandline:
./nova-compute --flagfile=/path/to/flagfile

If you have further questions, you might want to just jump in #openstack and irc.freenode.net and we can discuss there.

On Sep 16, 2010, at 2:20 PM, Manuel Amador (Rudd-O) wrote:

> 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 :-)
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~nova
> Post to     : nova@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~nova
> More help   : https://help.launchpad.net/ListHelp
Follow ups

Re: Database is locked after running nova-manage
From: Manuel Amador (Rudd-O), 2010-09-17
References

Database is locked after running nova-manage
From: Manuel Amador (Rudd-O), 2010-09-16