[elbe-users] sqlite3.OperationalError: database is locked

[Ralf Schlatterbeck]

When building a project with 14.9.3+deb12+build1311 on debian stable aka
bookworm (the elbe VM still seems to be bullseye) I'm getting the
traceback below. This is an armel project with an ubifs filesystem.

Also note: Previous elbe versions produced nand.img.tar.gz, now there is
a file rootfs.ubifs in the directory on elbe, has the output format
changed? Or is there something else going wrong?

I'm running
elbe control --build-bin build <projecthash>
and then while waiting with:
elbe control wait_busy <projecthash>

the traceback occurs.
It looks like everything is built fine but how can I be sure?

Thanks
Ralf

Traceback (on stderr, I'm logging stdout and stderr separately):

Server returned error:

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 609, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: database is locked

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/elbepack/daemons/soap/faults.py", line 128, in wrapped
    return func(self, arg1, arg2)
  File "/usr/lib/python3/dist-packages/elbepack/daemons/soap/esoap.py", line 373, in get_project_busy
    self.app.pm.open_project(uid, builddir)
  File "/usr/lib/python3/dist-packages/elbepack/projectmanager.py", line 116, in open_project
    self._check_project_permission(userid, builddir)
  File "/usr/lib/python3/dist-packages/elbepack/projectmanager.py", line 549, in _check_project_permission
    if self.db.is_admin(userid):
  File "/usr/lib/python3/dist-packages/elbepack/db.py", line 940, in is_admin
    u = s.query(User).filter(User.id == userid).one()
  File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 3490, in one
    ret = self.one_or_none()
  File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 3459, in one_or_none
    ret = list(self)
  File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
    return self._execute_and_instances(context)
  File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1011, in execute
    return meth(self, multiparams, params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
    ret = self._execute_context(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
    self._handle_dbapi_exception(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
    util.raise_(
  File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 609, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: SELECT users.id AS users_id, users.name AS users_name, users.fullname AS users_fullname, users.pwhash AS users_pwhash, users.email AS users_email, users.admin AS users_admin 
FROM users 
WHERE users.id = ?]
[parameters: (1,)]
(Background on this error at: http://sqlalche.me/e/13/e3q8)



-- 
Dr. Ralf Schlatterbeck                  Tel:   +43/2243/26465-16
Open Source Consulting                  www:   www.runtux.com
Reichergasse 131, A-3411 Weidling       email: office at runtux.com