pkg: sqlite error while executing COMMIT TRANSACTION in file pkgdb.c:1215: database is locked #2573
Description
Closed:
– with reference to:
Tagged 2.4.2:
Line 1216 in b0a4090
A version 2.4.2_1 incident:
…
[22/291] Extracting libnghttp2-1.68.0: 100%
[23/291] Upgrading libthai from 0.1.29_1 to 0.1.29_2...
[23/291] Extracting libthai-0.1.29_2: 100%
pkg: sqlite error while executing COMMIT TRANSACTION in file pkgdb.c:1216: database is locked
[24/291] Upgrading luajit from 2.1.0.20250728 to 2.1.0.20251208...
pkg: sqlite error while executing BEGIN IMMEDIATE TRANSACTION in file pkgdb.c:1216: cannot start a transaction within a transaction
root@minimal-kde-pre:~ # pkg -v
2.4.2
root@minimal-kde-pre:~ # pkg iinfo ^pkg$
pkg-2.4.2_1
root@minimal-kde-pre:~ # freebsd-version -kru ; uname -mvKU
15.0-RELEASE
15.0-RELEASE
15.0-RELEASE
FreeBSD 15.0-RELEASE releng/15.0-n280995-7aedc8de6446 GENERIC amd64 1500068 1500068
root@minimal-kde-pre:~ # pkg repos -el | sort -f
FreeBSD-base
FreeBSD-ports
FreeBSD-ports-kmods
root@minimal-kde-pre:~ # pkg repos -e | grep -B 1 url
FreeBSD-ports: {
url : "pkg+https://pkg.FreeBSD.org/FreeBSD:15:amd64/latest",
--
FreeBSD-ports-kmods: {
url : "pkg+https://pkg.FreeBSD.org/FreeBSD:15:amd64/kmods_latest_0",
--
FreeBSD-base: {
url : "pkg+https://pkg.FreeBSD.org/FreeBSD:15:amd64/base_release_0",
root@minimal-kde-pre:~ # dmesg grep avail
usage: dmesg [-ac] [-M core [-N system]]
root@minimal-kde-pre:~ # dmesg | grep avail
avail memory = 2024996864 (1931 MB)
root@minimal-kde-pre:~ # sysctl vm.pageout_oom_seq=120
vm.pageout_oom_seq: 12 -> 120
root@minimal-kde-pre:~ # history 10
6 1:51 pkg upgrade
7 2:06 pkg -v
8 2:06 pkg iinfo ^pkg$
9 2:06 freebsd-version -kru ; uname -mvKU
10 2:06 pkg repos -el | sort -f
11 2:07 pkg repos -e | grep -B 1 url
12 2:07 dmesg grep avail
13 2:07 dmesg | grep avail
14 2:07 sysctl vm.pageout_oom_seq=120
15 2:20 history 10
root@minimal-kde-pre:~ #
The pkg upgrade command was at 01:51, however I did not key y to proceed until some time later.