[Bug 1875760] Re: /usr/lib/cnf-update-db:sqlite3.OperationalError:/usr/lib/cnf-update-db at 26:create

[Lukas Märdian]

This is a working reproducer:

sudo cp /var/lib/command-not-found/commands.db /var/lib/command-not-found/commands.db.tmp
sudo sqlite3 /var/lib/command-not-found/commands.db.tmp
SQLite version 3.31.1 2020-01-27 19:55:54
Enter ".help" for usage hints.
sqlite> PRAGMA locking_mode = EXCLUSIVE;
exclusive
sqlite> BEGIN EXCLUSIVE;
sqlite>

sudo rm /var/lib/command-not-found/commands.db.metadata
sudo PYTHONPATH=. ./cnf-update-db --verbose
Traceback (most recent call last):
  File "./cnf-update-db", line 26, in <module>
    col.create(db)
  File "/home/lukas/canonical/01-Distro/command-not-found/CommandNotFound/db/creator.py", line 92, in create
    con.executescript(create_db_sql)
sqlite3.OperationalError: database is locked

-- 
You received this bug notification because you are a member of Ubuntu
Foundations Bugs, which is subscribed to command-not-found in Ubuntu.
https://bugs.launchpad.net/bugs/1875760

Title:
  /usr/lib/cnf-update-db:sqlite3.OperationalError:/usr/lib/cnf-update-
  db at 26:create

Status in command-not-found package in Ubuntu:
  Triaged
Status in command-not-found source package in Focal:
  Triaged

Bug description:
  The Ubuntu Error Tracker has been receiving reports about a problem regarding command-not-found.  This problem was most recently seen with package version 20.04.2, the problem page at https://errors.ubuntu.com/problem/e1fb83cff555154efc036bf0674053c5e555d96b contains more details, including versions of packages affected, stacktrace or traceback, and individual crash reports.
  If you do not have access to the Ubuntu Error Tracker and are a software developer, you can request it at http://forms.canonical.com/reports/.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/command-not-found/+bug/1875760/+subscriptions