Ubuntu
command-not-found package

cnf-update-db crashed with sqlite3.OperationalError in create(): database is locked

Bug #1871670 reported by Mustafa Senturk on 2020-04-08

20

This bug affects 3 people

Affects		Status	Importance	Assigned to	Milestone
	command-not-found (Ubuntu)	Confirmed	Medium	Unassigned

Bug Description

After loading the 20.04 UBUNTU when i update this message is coming.

ProblemType: Crash
DistroRelease: Ubuntu 20.04
Package: command-not-found 20.04.2
ProcVersionSignature: Ubuntu 5.4.0-21.25-generic 5.4.27
Uname: Linux 5.4.0-21-generic x86_64
ApportVersion: 2.20.11-0ubuntu25
Architecture: amd64
CrashCounter: 1
Date: Wed Apr 8 19:02:37 2020
ExecutablePath: /usr/lib/cnf-update-db
InstallationDate: Installed on 2020-04-08 (0 days ago)
InstallationMedia: Ubuntu 20.04 LTS "Focal Fossa" - Beta amd64 (20200402)
InterpreterPath: /usr/bin/python3.8
PackageArchitecture: all
ProcCmdline: /usr/bin/python3 /usr/lib/cnf-update-db
ProcEnviron:
TERM=xterm-256color
PATH=(custom, no user)
LANG=tr_TR.UTF-8
SHELL=/bin/bash
Python3Details: /usr/bin/python3.8, Python 3.8.2, python3-minimal, 3.8.2-0ubuntu2
PythonArgs: ['/usr/lib/cnf-update-db']
PythonDetails: N/A
SourcePackage: command-not-found
Title: cnf-update-db crashed with sqlite3.OperationalError in create(): database is locked
UpgradeStatus: No upgrade log present (probably fresh install)
UserGroups:

Tags:

Revision history for this message

Mustafa Senturk (afatsumkrutnes5561) wrote on 2020-04-08:

#1

Dependencies.txt Edit (2.1 KiB, text/plain; charset="utf-8")
JournalErrors.txt Edit (93.7 KiB, text/plain; charset="utf-8")
ProcCpuinfoMinimal.txt Edit (1.1 KiB, text/plain; charset="utf-8")
ProcMaps.txt Edit (21.2 KiB, text/plain; charset="utf-8")
ProcStatus.txt Edit (1.3 KiB, text/plain; charset="utf-8")
Traceback.txt Edit (279 bytes, text/plain; charset="utf-8")

Apport retracing service (apport) on 2020-04-08

affects:	ubuntu → command-not-found (Ubuntu)
tags:	removed: need-duplicate-check
Changed in command-not-found (Ubuntu):
importance:	Undecided → Medium

Revision history for this message

Seth Arnold (seth-arnold) wrote on 2020-04-09: Bug is not a security issue

#2

Thanks for taking the time to report this bug and helping to make Ubuntu better. We appreciate the difficulties you are facing, but this appears to be a "regular" (non-security) bug. I have unmarked it as a security issue since this bug does not show evidence of allowing attackers to cross privilege boundaries nor directly cause loss of data/privacy. Please feel free to report any other bugs you may find.

information type:

Private Security → Public

Revision history for this message

Mustafa Senturk (afatsumkrutnes5561) wrote on 2020-04-09:

#3

Dear Guys,

Same problem for my other computer which i try to load it. But i should say that i am a new user of UBUNTU since 20 days. After 18.04 this is marvellous it will be better i believe.

But same problem. İ think something like loading files.
Anyway
Good luck

Revision history for this message

Mustafa Senturk (afatsumkrutnes5561) wrote on 2020-04-09:

#4

My first machine i did it with remove and reinstall but now i can not solve yet i think.

Revision history for this message

Mustafa Senturk (afatsumkrutnes5561) wrote on 2020-04-14:

#5

Same problems still go on..
please be aware
i like to work with ubuntu

Revision history for this message

Launchpad Janitor (janitor) wrote on 2020-04-25:

#6

Status changed to 'Confirmed' because the bug affects multiple users.

Changed in command-not-found (Ubuntu):
status:	New → Confirmed

Revision history for this message

Brian Murray (brian-murray) wrote on 2020-04-28:

#8

@Butterfly - have you considered submitting your patch so that Ubuntu developers can evaluate your fix for incorporating in the official Ubuntu archives?

Revision history for this message

Mark (markthecodehamster) wrote on 2020-05-12:

#9

I guess I'm having the same bug, plaguing me since upgrading to 20.04.

I have a 100% reproducible
```
$ LC_ALL=en-US.UTF-8 blabla
Omlouváme se, command-not-found zhavaroval! Prosíme nahlaste chybu na:
https://bugs.launchpad.net/command-not-found/+filebug
K hlášení přidejte následující informace:

command-not-found verze: 0.3
Python verze: 3.8.2 final 0
Distributor ID: Ubuntu
Description: Ubuntu 20.04 LTS
Release: 20.04
Codename: focal
Informace o výjimce:

unable to open database file
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/CommandNotFound/util.py", line 23, in crash_guard
callback()
File "/usr/lib/command-not-found", line 90, in main
cnf = CommandNotFound.CommandNotFound(options.data_dir)
File "/usr/lib/python3/dist-packages/CommandNotFound/CommandNotFound.py", line 79, in __init__
self.db = SqliteDatabase(dbpath)
File "/usr/lib/python3/dist-packages/CommandNotFound/db/db.py", line 12, in __init__
self.con = sqlite3.connect(filename)
sqlite3.OperationalError: unable to open database file
```

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Bug attachments

Add attachment

Remote bug watches

Bug watches keep track of this bug in other bug trackers.