search

freebsd / pkg

Package management tool for FreeBSD. Help at #pkg on Libera Chat or pkg@FreeBSD.org
Other
748 stars 279 forks source link

pkg fails to report 'Disk full' condition: 'sudo pkg autoremove' fails with 'pkg: sqlite error while executing VACUUM; in file pkgdb.c:2333: cannot VACUUM - SQL statements in progress' #2098

Open yurivict opened 1 year ago

yurivict commented 1 year ago

Here is how the session went:

[yuri@yv //usr/ports/science/trilinos] $ sudo pkg autoremove
Checking integrity... done (0 conflicting)
Deinstallation has been requested for the following 18 packages:

Installed packages to be REMOVED:
    hdf5: 1.12.2_1,1
    munge: 0.5.14_1
    py39-appdirs: 1.4.4
    py39-argon2-cffi-bindings: 21.2.0
    py39-beautifulsoup: 4.11.1
    py39-bleach: 5.0.1
    py39-debugpy: 1.6.3
    py39-defusedxml: 0.7.1
    py39-ipython: 7.34.0
    py39-jupyterlab-pygments: 0.2.2
    py39-mistune: 2.0.4
    py39-nbclient: 0.7.0
    py39-packaging: 21.3
    py39-pandocfilters: 1.5.0
    py39-twisted: 22.4.0
    tex-formats: 20210325_1
    tex-libtexlua: 5.3.6
    tex-libtexluajit: 2.1.0

Number of packages to be removed: 18

The operation will free 174 MiB.

Proceed with deinstalling packages? [y/N]: y
[1/18] Deinstalling py39-twisted-22.4.0...
[1/18] Deleting files for py39-twisted-22.4.0: 100%
[2/18] Deinstalling py39-pandocfilters-1.5.0...
[2/18] Deleting files for py39-pandocfilters-1.5.0: 100%
[3/18] Deinstalling py39-argon2-cffi-bindings-21.2.0...
[3/18] Deleting files for py39-argon2-cffi-bindings-21.2.0: 100%
[4/18] Deinstalling hdf5-1.12.2_1,1...
[4/18] Deleting files for hdf5-1.12.2_1,1: 100%
[5/18] Deinstalling munge-0.5.14_1...
[5/18] Deleting files for munge-0.5.14_1: 100%
[6/18] Deinstalling tex-formats-20210325_1...
[6/18] Deleting files for tex-formats-20210325_1: 100%
[7/18] Deinstalling py39-debugpy-1.6.3...
[7/18] Deleting files for py39-debugpy-1.6.3: 100%
[8/18] Deinstalling tex-libtexlua-5.3.6...
[8/18] Deleting files for tex-libtexlua-5.3.6: 100%
[9/18] Deinstalling tex-libtexluajit-2.1.0...
[9/18] Deleting files for tex-libtexluajit-2.1.0: 100%
[10/18] Deinstalling py39-jupyterlab-pygments-0.2.2...
[10/18] Deleting files for py39-jupyterlab-pygments-0.2.2: 100%
[11/18] Deinstalling py39-packaging-21.3...
[11/18] Deleting files for py39-packaging-21.3: 100%
[12/18] Deinstalling py39-ipython-7.34.0...
[12/18] Deleting files for py39-ipython-7.34.0: 100%
[13/18] Deinstalling py39-appdirs-1.4.4...
[13/18] Deleting files for py39-appdirs-1.4.4: 100%
[14/18] Deinstalling py39-nbclient-0.7.0...
[14/18] Deleting files for py39-nbclient-0.7.0: 100%
[15/18] Deinstalling py39-bleach-5.0.1...
[15/18] Deleting files for py39-bleach-5.0.1: 100%
[16/18] Deinstalling py39-beautifulsoup-4.11.1...
[16/18] Deleting files for py39-beautifulsoup-4.11.1: 100%
[17/18] Deinstalling py39-mistune-2.0.4...
[17/18] Deleting files for py39-mistune-2.0.4: 100%
[18/18] Deinstalling py39-defusedxml-0.7.1...
[18/18] Deleting files for py39-defusedxml-0.7.1: 100%
pkg: sqlite error while executing VACUUM; in file pkgdb.c:2333: cannot VACUUM - SQL statements in progress
[yuri@yv //usr/ports/science/trilinos]$ echo $?
0

Please note that pkg succeeded in the end, which it shouldn't.

yurivict commented 1 year ago

This is the behavior caused by 'Disk full' condition. fsck has accidentally left the UFS snapshot (which I didn't notice in time) which caused a lingering 'Disk full' condition. The above symptoms are a result of some bug in pkg that is triggered by the 'Disk full' condition.

Please make the pkg behavior reasonable. It looks like some SQLite 'prepare' statements failed and weren't reported. Also 'Disk full' should be part of the log, and it isn't.

yurivict commented 1 year ago

pkg does this w/out Disk Full condition as well:

$ sudo pkg autoremove
Checking integrity... done (0 conflicting)
Deinstallation has been requested for the following 106 packages:

Installed packages to be REMOVED:
    akonadi: 22.08.3
    arb: 2.23.0
    autoconf-switch: 20220527
    chmlib: 0.40_1
    discount: 2.2.7b
    ebook-tools: 0.2.2_8
    gl2ps: 1.4.2_1
    googletest: 1.12.1
    java-zoneinfo: 2021.e
    javavmwrapper: 2.7.9
    kdegraphics-mobipocket: 22.08.3
    kf5-kactivities: 5.99.0
    kf5-kdelibs4support: 5.99.0
    kf5-khtml: 5.99.0
    kf5-kinit: 5.99.0
    kf5-kpty: 5.99.0
    kf5-purpose: 5.99.0
    kf5-threadweaver: 5.99.0
    libfmt: 8.1.1
    libkexiv2: 22.08.3
    liblas: 1.8.1_21
    libmicrohttpd: 0.9.75
    libspectre: 0.2.11
    llvm15: 15.0.6_1
    m4: 1.4.19,1
    mfem: 4.4_6
    mpir: 3.0.0_1
    netpbm: 10.91.01_1
    node16: 16.19.0
    openturns: 1.20_1
    p5-Locale-gettext: 1.07
    p5-Text-Unidecode: 1.30
    p5-Unicode-EastAsianWidth: 12.0
    pdal: 2.3.0_9
    poppler-qt5: 22.12.0
    pugixml: 1.13
    py27-setuptools44: 44.1.1
    py310-setuptools: 63.1.0
    py311-setuptools: 63.1.0
    py37-setuptools: 63.1.0
    py38-setuptools: 63.1.0
    py39-Shapely: 1.8.5
    py39-appdirs: 1.4.4
    py39-atomicwrites: 1.4.1
    py39-attrs: 22.1.0
    py39-bcrypt: 3.2.2
    py39-beaker: 1.11.0
    py39-beautifulsoup: 4.11.1
    py39-chardet: 4.0.0,1
    py39-colorlog: 6.7.0
    py39-constantly: 15.1.0
    py39-django32: 3.2.16
    py39-dpcontracts: 0.6.0
    py39-filelock: 3.8.2
    py39-gast: 0.5.3
    py39-h11: 0.14.0
    py39-httpcore: 0.15.0_1
    py39-hyperlink: 21.0.0
    py39-itsdangerous: 2.1.2
    py39-jaraco: 1
    py39-jaraco.context: 4.1.2
    py39-jaraco.functools: 3.5.2
    py39-jsonschema: 4.14.0
    py39-lark: 1.1.3
    py39-libcst: 0.3.23
    py39-markdown-it-py: 2.1.0
    py39-mccabe: 0.7.0
    py39-mdit-py-plugins: 0.3.1
    py39-mistune0: 0.8.4
    py39-mpmath: 1.2.1
    py39-msgpack: 1.0.4
    py39-mypy: 0.991
    py39-pep517: 0.13.0
    py39-ply: 3.11
    py39-priority1: 1.3.0
    py39-ptyprocess: 0.7.0
    py39-pycodestyle: 2.10.0
    py39-pycollada: 0.6_3
    py39-pyflakes: 3.0.1
    py39-pyglet1: 1.5.27
    py39-pyserial: 3.5_2
    py39-pytest-black: 0.3.12
    py39-pytest-forked: 1.4.0
    py39-python-fcl: 0.0.12_2
    py39-python-multipart: 0.0.5
    py39-redis: 3.5.3_1
    py39-rfc3986: 1.5.0,1
    py39-rtree: 1.0.1
    py39-scikit-image: 0.19.3
    py39-service_identity: 18.1.0
    py39-sortedcontainers: 2.4.0
    py39-sphinx-basic-ng: 0.0.1a12
    py39-svg_path: 4.0.2
    py39-sympy: 1.11.1_1
    py39-towncrier: 22.8.0
    py39-traceback2: 1.4.0_2
    py39-triangle: 20200424
    py39-xxhash: 3.1.0
    py39-zope.interface: 5.3.0
    qt5-scripttools: 5.15.10p0
    qt5-webengine: 5.15.2_7
    qt5-xmlpatterns: 5.15.5p0
    suitesparse-klu: 2.0.0
    texlive-base: 20210325_12
    verdict: 1.4.1
    xtl-quant-stack: 0.7.4

Number of packages to be removed: 106

The operation will free 2 GiB.

Proceed with deinstalling packages? [y/N]: y
[1/106] Deinstalling kf5-purpose-5.99.0...
[1/106] Deleting files for kf5-purpose-5.99.0: 100%
[2/106] Deinstalling py39-pytest-black-0.3.12...
[2/106] Deleting files for py39-pytest-black-0.3.12: 100%
[3/106] Deinstalling py39-pytest-forked-1.4.0...
[3/106] Deleting files for py39-pytest-forked-1.4.0: 100%
[4/106] Deinstalling py39-httpcore-0.15.0_1...
[4/106] Deleting files for py39-httpcore-0.15.0_1: 100%
[5/106] Deinstalling poppler-qt5-22.12.0...
[5/106] Deleting files for poppler-qt5-22.12.0: 100%
[6/106] Deinstalling py39-libcst-0.3.23...
[6/106] Deleting files for py39-libcst-0.3.23: 100%
[7/106] Deinstalling py39-jsonschema-4.14.0...
[7/106] Deleting files for py39-jsonschema-4.14.0: 100%
[8/106] Deinstalling py39-service_identity-18.1.0...
[8/106] Deleting files for py39-service_identity-18.1.0: 100%
[9/106] Deinstalling verdict-1.4.1...
[9/106] Deleting files for verdict-1.4.1: 100%
[10/106] Deinstalling kf5-kpty-5.99.0...
[10/106] Deleting files for kf5-kpty-5.99.0: 100%
[11/106] Deinstalling akonadi-22.08.3...
[11/106] Deleting files for akonadi-22.08.3: 100%
[12/106] Deinstalling arb-2.23.0...
[12/106] Deleting files for arb-2.23.0: 100%
[13/106] Deinstalling kdegraphics-mobipocket-22.08.3...
[13/106] Deleting files for kdegraphics-mobipocket-22.08.3: 100%
[14/106] Deinstalling py39-lark-1.1.3...
[14/106] Deleting files for py39-lark-1.1.3: 100%
[15/106] Deinstalling py39-mdit-py-plugins-0.3.1...
[15/106] Deleting files for py39-mdit-py-plugins-0.3.1: 100%
[16/106] Deinstalling py39-jaraco.functools-3.5.2...
[16/106] Deleting files for py39-jaraco.functools-3.5.2: 100%
[17/106] Deinstalling py39-sympy-1.11.1_1...
[17/106] Deleting files for py39-sympy-1.11.1_1: 100%
[18/106] Deinstalling py39-bcrypt-3.2.2...
[18/106] Deleting files for py39-bcrypt-3.2.2: 100%
[19/106] Deinstalling kf5-kactivities-5.99.0...
[19/106] Deleting files for kf5-kactivities-5.99.0: 100%
[20/106] Deinstalling py39-beautifulsoup-4.11.1...
[20/106] Deleting files for py39-beautifulsoup-4.11.1: 100%
[21/106] Deinstalling py39-jaraco.context-4.1.2...
[21/106] Deleting files for py39-jaraco.context-4.1.2: 100%
[22/106] Deinstalling py39-attrs-22.1.0...
[22/106] Deleting files for py39-attrs-22.1.0: 100%
[23/106] Deinstalling py39-markdown-it-py-2.1.0...
[23/106] Deleting files for py39-markdown-it-py-2.1.0: 100%
[24/106] Deinstalling p5-Locale-gettext-1.07...
[24/106] Deleting files for p5-Locale-gettext-1.07: 100%
[25/106] Deinstalling py39-python-fcl-0.0.12_2...
[25/106] Deleting files for py39-python-fcl-0.0.12_2: 100%
[26/106] Deinstalling liblas-1.8.1_21...
[26/106] Deleting files for liblas-1.8.1_21: 100%
[27/106] Deinstalling kf5-threadweaver-5.99.0...
[27/106] Deleting files for kf5-threadweaver-5.99.0: 100%
[28/106] Deinstalling py310-setuptools-63.1.0...
[28/106] Deleting files for py310-setuptools-63.1.0: 100%
[29/106] Deinstalling py39-beaker-1.11.0...
[29/106] Deleting files for py39-beaker-1.11.0: 100%
[30/106] Deinstalling py39-pyflakes-3.0.1...
[30/106] Deleting files for py39-pyflakes-3.0.1: 100%
[31/106] Deinstalling xtl-quant-stack-0.7.4...
[31/106] Deleting files for xtl-quant-stack-0.7.4: 100%
[32/106] Deinstalling py39-zope.interface-5.3.0...
[32/106] Deleting files for py39-zope.interface-5.3.0: 100%
[33/106] Deinstalling libkexiv2-22.08.3...
[33/106] Deleting files for libkexiv2-22.08.3: 100%
[34/106] Deinstalling py311-setuptools-63.1.0...
[34/106] Deleting files for py311-setuptools-63.1.0: 100%
[35/106] Deinstalling py38-setuptools-63.1.0...
[35/106] Deleting files for py38-setuptools-63.1.0: 100%
[36/106] Deinstalling py39-constantly-15.1.0...
[36/106] Deleting files for py39-constantly-15.1.0: 100%
[37/106] Deinstalling py39-python-multipart-0.0.5...
[37/106] Deleting files for py39-python-multipart-0.0.5: 100%
[38/106] Deinstalling kf5-kdelibs4support-5.99.0...
[38/106] Deleting files for kf5-kdelibs4support-5.99.0: 100%
[39/106] Deinstalling py39-rfc3986-1.5.0,1...
[39/106] Deleting files for py39-rfc3986-1.5.0,1: 100%
[40/106] Deinstalling texlive-base-20210325_12...
[40/106] Deleting files for texlive-base-20210325_12: 100%
[41/106] Deinstalling kf5-khtml-5.99.0...
[41/106] Deleting files for kf5-khtml-5.99.0: 100%
[42/106] Deinstalling chmlib-0.40_1...
[42/106] Deleting files for chmlib-0.40_1: 100%
[43/106] Deinstalling py37-setuptools-63.1.0...
[43/106] Deleting files for py37-setuptools-63.1.0: 100%
[44/106] Deinstalling py39-sphinx-basic-ng-0.0.1a12...
[44/106] Deleting files for py39-sphinx-basic-ng-0.0.1a12: 100%
[45/106] Deinstalling py39-triangle-20200424...
[45/106] Deleting files for py39-triangle-20200424: 100%
[46/106] Deinstalling py39-redis-3.5.3_1...
[46/106] Deleting files for py39-redis-3.5.3_1: 100%
[47/106] Deinstalling libmicrohttpd-0.9.75...
[47/106] Deleting files for libmicrohttpd-0.9.75: 100%
[48/106] Deinstalling py39-ply-3.11...
[48/106] Deleting files for py39-ply-3.11: 100%
[49/106] Deinstalling py39-mistune0-0.8.4...
[49/106] Deleting files for py39-mistune0-0.8.4: 100%
[50/106] Deinstalling java-zoneinfo-2021.e...
[50/106] Deleting files for java-zoneinfo-2021.e: 100%
[51/106] Deinstalling py39-pycollada-0.6_3...
[51/106] Deleting files for py39-pycollada-0.6_3: 100%
[52/106] Deinstalling py39-atomicwrites-1.4.1...
[52/106] Deleting files for py39-atomicwrites-1.4.1: 100%
[53/106] Deinstalling p5-Unicode-EastAsianWidth-12.0...
[53/106] Deleting files for p5-Unicode-EastAsianWidth-12.0: 100%
[54/106] Deinstalling libspectre-0.2.11...
[54/106] Deleting files for libspectre-0.2.11: 100%
[55/106] Deinstalling libfmt-8.1.1...
[55/106] Deleting files for libfmt-8.1.1: 100%
[56/106] Deinstalling py39-dpcontracts-0.6.0...
[56/106] Deleting files for py39-dpcontracts-0.6.0: 100%
[57/106] Deinstalling py39-gast-0.5.3...
[57/106] Deleting files for py39-gast-0.5.3: 100%
[58/106] Deinstalling py39-Shapely-1.8.5...
[58/106] Deleting files for py39-Shapely-1.8.5: 100%
[59/106] Deinstalling netpbm-10.91.01_1...
[59/106] Deleting files for netpbm-10.91.01_1: 100%
[60/106] Deinstalling ebook-tools-0.2.2_8...
[60/106] Deleting files for ebook-tools-0.2.2_8: 100%
[61/106] Deinstalling py39-appdirs-1.4.4...
[61/106] Deleting files for py39-appdirs-1.4.4: 100%
[62/106] Deinstalling py39-ptyprocess-0.7.0...
[62/106] Deleting files for py39-ptyprocess-0.7.0: 100%
[63/106] Deinstalling qt5-xmlpatterns-5.15.5p0...
[63/106] Deleting files for qt5-xmlpatterns-5.15.5p0: 100%
[64/106] Deinstalling py39-filelock-3.8.2...
[64/106] Deleting files for py39-filelock-3.8.2: 100%
[65/106] Deinstalling py39-mypy-0.991...
[65/106] Deleting files for py39-mypy-0.991: 100%
[66/106] Deinstalling gl2ps-1.4.2_1...
[66/106] Deleting files for gl2ps-1.4.2_1: 100%
[67/106] Deinstalling py39-traceback2-1.4.0_2...
[67/106] Deleting files for py39-traceback2-1.4.0_2: 100%
[68/106] Deinstalling py39-django32-3.2.16...
[68/106] Deleting files for py39-django32-3.2.16: 100%
[69/106] Deinstalling qt5-scripttools-5.15.10p0...
[69/106] Deleting files for qt5-scripttools-5.15.10p0: 100%
[70/106] Deinstalling javavmwrapper-2.7.9...
[70/106] Deleting files for javavmwrapper-2.7.9: 100%
[71/106] Deinstalling py39-scikit-image-0.19.3...
[71/106] Deleting files for py39-scikit-image-0.19.3: 100%
[72/106] Deinstalling p5-Text-Unidecode-1.30...
[72/106] Deleting files for p5-Text-Unidecode-1.30: 100%
[73/106] Deinstalling py27-setuptools44-44.1.1...
[73/106] Deleting files for py27-setuptools44-44.1.1: 100%
[74/106] Deinstalling py39-pyglet1-1.5.27...
[74/106] Deleting files for py39-pyglet1-1.5.27: 100%
[75/106] Deinstalling mfem-4.4_6...
[75/106] Deleting files for mfem-4.4_6: 100%
[76/106] Deinstalling py39-hyperlink-21.0.0...
[76/106] Deleting files for py39-hyperlink-21.0.0: 100%
[77/106] Deinstalling py39-svg_path-4.0.2...
[77/106] Deleting files for py39-svg_path-4.0.2: 100%
[78/106] Deinstalling py39-priority1-1.3.0...
[78/106] Deleting files for py39-priority1-1.3.0: 100%
[79/106] Deinstalling py39-pycodestyle-2.10.0...
[79/106] Deleting files for py39-pycodestyle-2.10.0: 100%
[80/106] Deinstalling mpir-3.0.0_1...
[80/106] Deleting files for mpir-3.0.0_1: 100%
[81/106] Deinstalling py39-colorlog-6.7.0...
[81/106] Deleting files for py39-colorlog-6.7.0: 100%
[82/106] Deinstalling py39-msgpack-1.0.4...
[82/106] Deleting files for py39-msgpack-1.0.4: 100%
[83/106] Deinstalling py39-jaraco-1...
[83/106] Deleting files for py39-jaraco-1: 100%
[84/106] Deinstalling pugixml-1.13...
[84/106] Deleting files for pugixml-1.13: 100%
[85/106] Deinstalling kf5-kinit-5.99.0...
[85/106] Deleting files for kf5-kinit-5.99.0: 100%
[86/106] Deinstalling py39-towncrier-22.8.0...
[86/106] Deleting files for py39-towncrier-22.8.0: 100%
[87/106] Deinstalling py39-sortedcontainers-2.4.0...
[87/106] Deleting files for py39-sortedcontainers-2.4.0: 100%
[88/106] Deinstalling py39-itsdangerous-2.1.2...
[88/106] Deleting files for py39-itsdangerous-2.1.2: 100%
[89/106] Deinstalling py39-chardet-4.0.0,1...
[89/106] Deleting files for py39-chardet-4.0.0,1: 100%
[90/106] Deinstalling py39-rtree-1.0.1...
[90/106] Deleting files for py39-rtree-1.0.1: 100%
[91/106] Deinstalling py39-mccabe-0.7.0...
[91/106] Deleting files for py39-mccabe-0.7.0: 100%
[92/106] Deinstalling py39-pyserial-3.5_2...
[92/106] Deleting files for py39-pyserial-3.5_2: 100%
[93/106] Deinstalling qt5-webengine-5.15.2_7...
[93/106] Deleting files for qt5-webengine-5.15.2_7: 100%
[94/106] Deinstalling openturns-1.20_1...
[94/106] Deleting files for openturns-1.20_1: 100%
[95/106] Deinstalling py39-h11-0.14.0...
[95/106] Deleting files for py39-h11-0.14.0: 100%
[96/106] Deinstalling py39-xxhash-3.1.0...
[96/106] Deleting files for py39-xxhash-3.1.0: 100%
[97/106] Deinstalling py39-pep517-0.13.0...
[97/106] Deleting files for py39-pep517-0.13.0: 100%
[98/106] Deinstalling m4-1.4.19,1...
[98/106] Deleting files for m4-1.4.19,1: 100%
[99/106] Deinstalling llvm15-15.0.6_1...
[99/106] Deleting files for llvm15-15.0.6_1: 100%
[100/106] Deinstalling node16-16.19.0...
[100/106] Deleting files for node16-16.19.0: 100%
[101/106] Deinstalling py39-mpmath-1.2.1...
[101/106] Deleting files for py39-mpmath-1.2.1: 100%
[102/106] Deinstalling googletest-1.12.1...
[102/106] Deleting files for googletest-1.12.1: 100%
[103/106] Deinstalling suitesparse-klu-2.0.0...
[103/106] Deleting files for suitesparse-klu-2.0.0: 100%
[104/106] Deinstalling pdal-2.3.0_9...
[104/106] Deleting files for pdal-2.3.0_9: 100%
[105/106] Deinstalling autoconf-switch-20220527...
[105/106] Deleting files for autoconf-switch-20220527: 100%
[106/106] Deinstalling discount-2.2.7b...
[106/106] Deleting files for discount-2.2.7b: 100%
Generating GTK icon cache for /usr/local/share/icons/hicolor
Building the Shared MIME-Info database cache
pkg: sqlite error while executing VACUUM; in file pkgdb.c:2333: cannot VACUUM - SQL statements in progress
[yuri@yv /usr/ports/science/dynare]$ sudo pkg autoremove
Checking integrity... done (0 conflicting)
Deinstallation has been requested for the following 63 packages:

Installed packages to be REMOVED:
    c-ares: 1.18.1_1
    ceres-solver: 2.1.0_1
    cminpack: 1.3.6_4
    coin-or-bonmin: 1.8.8_5
    dlib-cpp: 19.24
    fcl05: 0.5.0_2
    flint2: 2.9.0
    hypre: 2.26.0
    kaccounts-integration: 22.08.3
    kf5-kdesignerplugin: 5.99.0
    kf5-kemoticons: 5.99.0
    kf5-kirigami2: 5.99.0
    kf5-kitemmodels: 5.99.0
    kf5-kjs: 5.99.0
    kf5-kunitconversion: 5.99.0
    laszip: 3.4.3
    lazperf: 2.0.0
    libpotrace: 1.16
    llvm12: 12.0.1_10
    mysql57-server: 5.7.40
    p5-File-HomeDir: 1.006
    p5-YAML-Tiny: 1.73
    pagmo2: 2.18.0_8
    primesieve: 8.0
    py39-PyWavelets: 1.4.1
    py39-black: 22.10.0_2
    py39-chaospy: 4.3.8
    py39-click-default-group: 1.2.2
    py39-cloudpickle: 2.2.0
    py39-dill: 0.3.4
    py39-exceptiongroup: 1.0.0rc9
    py39-h2: 4.0.0
    py39-html5lib: 1.0.1
    py39-imageio: 2.22.1
    py39-incremental: 21.3.0
    py39-mdurl: 0.1.2
    py39-more-itertools: 8.14.0
    py39-networkx: 2.8.8,1
    py39-pyasn1: 0.4.8
    py39-pyasn1-modules: 0.2.8
    py39-pyrsistent: 0.18.1
    py39-pytest: 7.2.0,1
    py39-sniffio: 1.3.0
    py39-soupsieve: 2.0.1
    py39-sphinx: 4.5.0,1
    py39-sqlparse: 0.4.3
    py39-tifffile: 2022.7.28
    py39-toml: 0.10.2
    py39-typing-inspect: 0.8.0
    python27: 2.7.18_2
    python310: 3.10.9_1
    python311: 3.11.1
    python37: 3.7.16
    python38: 3.8.16
    qt5-sqldrivers-mysql: 5.15.5p165
    spatialindex: 1.8.5
    suitesparse-btf: 2.0.0
    superlu-dist: 8.1.2
    t1lib: 5.1.2_5,1
    teckit: 2.5.11
    tex-web2c: 20210325
    texlive-tlmgr: 20210325_1
    xpdfopen: 0.86_1

Number of packages to be removed: 63

The operation will free 2 GiB.

Proceed with deinstalling packages? [y/N]: y
[1/63] Deinstalling hypre-2.26.0...
[1/63] Deleting files for hypre-2.26.0: 100%
[2/63] Deinstalling flint2-2.9.0...
[2/63] Deleting files for flint2-2.9.0: 100%
[3/63] Deinstalling py39-pyasn1-modules-0.2.8...
[3/63] Deleting files for py39-pyasn1-modules-0.2.8: 100%
[4/63] Deinstalling kf5-kunitconversion-5.99.0...
[4/63] Deleting files for kf5-kunitconversion-5.99.0: 100%
[5/63] Deinstalling ceres-solver-2.1.0_1...
[5/63] Deleting files for ceres-solver-2.1.0_1: 100%
[6/63] Deinstalling py39-pytest-7.2.0,1...
[6/63] Deleting files for py39-pytest-7.2.0,1: 100%
[7/63] Deinstalling fcl05-0.5.0_2...
[7/63] Deleting files for fcl05-0.5.0_2: 100%
[8/63] Deinstalling laszip-3.4.3...
[8/63] Deleting files for laszip-3.4.3: 100%
[9/63] Deinstalling py39-h2-4.0.0...
[9/63] Deleting files for py39-h2-4.0.0: 100%
[10/63] Deinstalling py39-soupsieve-2.0.1...
[10/63] Deleting files for py39-soupsieve-2.0.1: 100%
[11/63] Deinstalling py39-black-22.10.0_2...
[11/63] Deleting files for py39-black-22.10.0_2: 100%
[12/63] Deinstalling py39-pyasn1-0.4.8...
[12/63] Deleting files for py39-pyasn1-0.4.8: 100%
[13/63] Deinstalling py39-exceptiongroup-1.0.0rc9...
[13/63] Deleting files for py39-exceptiongroup-1.0.0rc9: 100%
[14/63] Deinstalling mysql57-server-5.7.40...
[14/63] Deleting files for mysql57-server-5.7.40: 100%
==> You should manually remove the "mysql" user. 
==> You should manually remove the "mysql" group 
[15/63] Deinstalling xpdfopen-0.86_1...
[15/63] Deleting files for xpdfopen-0.86_1: 100%
[16/63] Deinstalling python37-3.7.16...
[16/63] Deleting files for python37-3.7.16: 100%
[17/63] Deinstalling spatialindex-1.8.5...
[17/63] Deleting files for spatialindex-1.8.5: 100%
[18/63] Deinstalling py39-more-itertools-8.14.0...
[18/63] Deleting files for py39-more-itertools-8.14.0: 100%
[19/63] Deinstalling primesieve-8.0...
[19/63] Deleting files for primesieve-8.0: 100%
[20/63] Deinstalling py39-pyrsistent-0.18.1...
[20/63] Deleting files for py39-pyrsistent-0.18.1: 100%
[21/63] Deinstalling kf5-kirigami2-5.99.0...
[21/63] Deleting files for kf5-kirigami2-5.99.0: 100%
[22/63] Deinstalling py39-click-default-group-1.2.2...
[22/63] Deleting files for py39-click-default-group-1.2.2: 100%
[23/63] Deinstalling p5-File-HomeDir-1.006...
[23/63] Deleting files for p5-File-HomeDir-1.006: 100%
[24/63] Deinstalling py39-sqlparse-0.4.3...
[24/63] Deleting files for py39-sqlparse-0.4.3: 100%
[25/63] Deinstalling py39-mdurl-0.1.2...
[25/63] Deleting files for py39-mdurl-0.1.2: 100%
[26/63] Deinstalling teckit-2.5.11...
[26/63] Deleting files for teckit-2.5.11: 100%
[27/63] Deinstalling coin-or-bonmin-1.8.8_5...
[27/63] Deleting files for coin-or-bonmin-1.8.8_5: 100%
[28/63] Deinstalling python38-3.8.16...
[28/63] Deleting files for python38-3.8.16: 100%
[29/63] Deinstalling cminpack-1.3.6_4...
[29/63] Deleting files for cminpack-1.3.6_4: 100%
[30/63] Deinstalling lazperf-2.0.0...
[30/63] Deleting files for lazperf-2.0.0: 100%
[31/63] Deinstalling libpotrace-1.16...
[31/63] Deleting files for libpotrace-1.16: 100%
[32/63] Deinstalling python311-3.11.1...
[32/63] Deleting files for python311-3.11.1: 100%
[33/63] Deinstalling pagmo2-2.18.0_8...
[33/63] Deleting files for pagmo2-2.18.0_8: 100%
[34/63] Deinstalling llvm12-12.0.1_10...
[34/63] Deleting files for llvm12-12.0.1_10: 100%
[35/63] Deinstalling kf5-kjs-5.99.0...
[35/63] Deleting files for kf5-kjs-5.99.0: 100%
[36/63] Deinstalling py39-dill-0.3.4...
[36/63] Deleting files for py39-dill-0.3.4: 100%
[37/63] Deinstalling python310-3.10.9_1...
[37/63] Deleting files for python310-3.10.9_1: 100%
[38/63] Deinstalling texlive-tlmgr-20210325_1...
[38/63] Deleting files for texlive-tlmgr-20210325_1: 100%
[39/63] Deinstalling kf5-kemoticons-5.99.0...
[39/63] Deleting files for kf5-kemoticons-5.99.0: 100%
[40/63] Deinstalling superlu-dist-8.1.2...
[40/63] Deleting files for superlu-dist-8.1.2: 100%
[41/63] Deinstalling py39-toml-0.10.2...
[41/63] Deleting files for py39-toml-0.10.2: 100%
[42/63] Deinstalling python27-2.7.18_2...
[42/63] Deleting files for python27-2.7.18_2: 100%
[43/63] Deinstalling suitesparse-btf-2.0.0...
[43/63] Deleting files for suitesparse-btf-2.0.0: 100%
[44/63] Deinstalling c-ares-1.18.1_1...
[44/63] Deleting files for c-ares-1.18.1_1: 100%
[45/63] Deinstalling p5-YAML-Tiny-1.73...
[45/63] Deleting files for p5-YAML-Tiny-1.73: 100%
[46/63] Deinstalling py39-cloudpickle-2.2.0...
[46/63] Deleting files for py39-cloudpickle-2.2.0: 100%
[47/63] Deinstalling py39-incremental-21.3.0...
[47/63] Deleting files for py39-incremental-21.3.0: 100%
[48/63] Deinstalling py39-networkx-2.8.8,1...
[48/63] Deleting files for py39-networkx-2.8.8,1: 100%
[49/63] Deinstalling py39-typing-inspect-0.8.0...
[49/63] Deleting files for py39-typing-inspect-0.8.0: 100%
[50/63] Deinstalling qt5-sqldrivers-mysql-5.15.5p165...
[50/63] Deleting files for qt5-sqldrivers-mysql-5.15.5p165: 100%
[51/63] Deinstalling t1lib-5.1.2_5,1...
[51/63] Deleting files for t1lib-5.1.2_5,1: 100%
[52/63] Deinstalling kf5-kitemmodels-5.99.0...
[52/63] Deleting files for kf5-kitemmodels-5.99.0: 100%
[53/63] Deinstalling kaccounts-integration-22.08.3...
[53/63] Deleting files for kaccounts-integration-22.08.3: 100%
[54/63] Deinstalling py39-sphinx-4.5.0,1...
[54/63] Deleting files for py39-sphinx-4.5.0,1: 100%
[55/63] Deinstalling py39-chaospy-4.3.8...
[55/63] Deleting files for py39-chaospy-4.3.8: 100%
[56/63] Deinstalling kf5-kdesignerplugin-5.99.0...
[56/63] Deleting files for kf5-kdesignerplugin-5.99.0: 100%
[57/63] Deinstalling py39-sniffio-1.3.0...
[57/63] Deleting files for py39-sniffio-1.3.0: 100%
[58/63] Deinstalling py39-imageio-2.22.1...
[58/63] Deleting files for py39-imageio-2.22.1: 100%
[59/63] Deinstalling py39-tifffile-2022.7.28...
[59/63] Deleting files for py39-tifffile-2022.7.28: 100%
[60/63] Deinstalling py39-PyWavelets-1.4.1...
[60/63] Deleting files for py39-PyWavelets-1.4.1: 100%
[61/63] Deinstalling dlib-cpp-19.24...
[61/63] Deleting files for dlib-cpp-19.24: 100%
[62/63] Deinstalling py39-html5lib-1.0.1...
[62/63] Deleting files for py39-html5lib-1.0.1: 100%
[63/63] Deinstalling tex-web2c-20210325...
[63/63] Deleting files for tex-web2c-20210325: 100%
pkg: sqlite error while executing VACUUM; in file pkgdb.c:2333: cannot VACUUM - SQL statements in progress
CyberCr33p commented 1 year ago

root@clamav:~ # pkg autoremove Checking integrity... done (0 conflicting) Deinstallation has been requested for the following 3 packages:

Installed packages to be REMOVED: libiconv: 1.17 perl5: 5.32.1_3 python39: 3.9.16

Number of packages to be removed: 3

The operation will free 181 MiB.

Proceed with deinstalling packages? [y/N]: y [clamav] [1/3] Deinstalling python39-3.9.16... [clamav] [1/3] Deleting files for python39-3.9.16: 100% [clamav] [2/3] Deinstalling perl5-5.32.1_3... [clamav] [2/3] Deleting files for perl5-5.32.1_3: 100% [clamav] [3/3] Deinstalling libiconv-1.17... [clamav] [3/3] Deleting files for libiconv-1.17: 100% pkg: sqlite error while executing VACUUM; in file pkgdb.c:2333: cannot VACUUM - SQL statements in progress

CyberCr33p commented 1 year ago

In a next "pkg autoremove" it shows no error.

CyberCr33p commented 1 year ago

pkg autoremove Checking integrity... done (0 conflicting) Deinstallation has been requested for the following 3 packages:

Installed packages to be REMOVED: http-parser: 2.9.4 libssh2: 1.10.0_1,3 python39: 3.9.16

Number of packages to be removed: 3

The operation will free 120 MiB.

Proceed with deinstalling packages? [y/N]: y [1/3] Deinstalling http-parser-2.9.4... [1/3] Deleting files for http-parser-2.9.4: 100% [2/3] Deinstalling python39-3.9.16... [2/3] Deleting files for python39-3.9.16: 100% [3/3] Deinstalling libssh2-1.10.0_1,3... [3/3] Deleting files for libssh2-1.10.0_1,3: 100% pkg: sqlite error while executing VACUUM; in file pkgdb.c:2333: cannot VACUUM - SQL statements in progress

edlitmus commented 1 year ago

This just hit me as well:

# pkg autoremove -y
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
Checking for upgrades (1 candidates): 100%
Processing candidates (1 candidates): 100%
Checking integrity... done (0 conflicting)
Your packages are up to date.
Checking integrity... done (0 conflicting)
Deinstallation has been requested for the following 21 packages:

Installed packages to be REMOVED:
    aom: 3.5.0_1
    cairo: 1.17.4_2,3
    cups: 2.4.2
    dav1d: 1.0.0_3
    dejavu: 2.37_1
    fribidi: 1.0.12
    harfbuzz: 6.0.0
    jbig2dec: 0.19
    libXft: 2.3.7
    libXmu: 1.1.3,1
    libXpm: 3.5.13
    libde265: 1.0.9
    libidn: 1.38
    openjpeg: 2.5.0
    php81-xml: 8.1.14
    php81-zlib: 8.1.14
    poppler-data: 0.4.11
    svt-av1: 1.4.1
    webp: 1.2.4_1
    x265: 3.4_2
    xorg-fonts-truetype: 7.7_1

Number of packages to be removed: 21

The operation will free 112 MiB.
[1/21] Deinstalling xorg-fonts-truetype-7.7_1...
[1/21] Deleting files for xorg-fonts-truetype-7.7_1: 100%
[2/21] Deinstalling cairo-1.17.4_2,3...
[2/21] Deleting files for cairo-1.17.4_2,3: 100%
[3/21] Deinstalling dejavu-2.37_1...
[3/21] Deleting files for dejavu-2.37_1: 100%
[4/21] Deinstalling x265-3.4_2...
[4/21] Deleting files for x265-3.4_2: 100%
[5/21] Deinstalling cups-2.4.2...
[5/21] Deleting files for cups-2.4.2: 100%
==> You should manually remove the "cups" user.
==> You should manually remove the "cups" group
[6/21] Deinstalling libde265-1.0.9...
[6/21] Deleting files for libde265-1.0.9: 100%
[7/21] Deinstalling php81-zlib-8.1.14...
[7/21] Deleting files for php81-zlib-8.1.14: 100%
[8/21] Deinstalling fribidi-1.0.12...
[8/21] Deleting files for fribidi-1.0.12: 100%
[9/21] Deinstalling svt-av1-1.4.1...
[9/21] Deleting files for svt-av1-1.4.1: 100%
[10/21] Deinstalling libidn-1.38...
[10/21] Deleting files for libidn-1.38: 100%
[11/21] Deinstalling openjpeg-2.5.0...
[11/21] Deleting files for openjpeg-2.5.0: 100%
[12/21] Deinstalling jbig2dec-0.19...
[12/21] Deleting files for jbig2dec-0.19: 100%
[13/21] Deinstalling libXmu-1.1.3,1...
[13/21] Deleting files for libXmu-1.1.3,1: 100%
[14/21] Deinstalling aom-3.5.0_1...
[14/21] Deleting files for aom-3.5.0_1: 100%
[15/21] Deinstalling dav1d-1.0.0_3...
[15/21] Deleting files for dav1d-1.0.0_3: 100%
[16/21] Deinstalling php81-xml-8.1.14...
[16/21] Deleting files for php81-xml-8.1.14: 100%
[17/21] Deinstalling libXft-2.3.7...
[17/21] Deleting files for libXft-2.3.7: 100%
[18/21] Deinstalling webp-1.2.4_1...
[18/21] Deleting files for webp-1.2.4_1: 100%
[19/21] Deinstalling libXpm-3.5.13...
[19/21] Deleting files for libXpm-3.5.13: 100%
[20/21] Deinstalling harfbuzz-6.0.0...
[20/21] Deleting files for harfbuzz-6.0.0: 100%
[21/21] Deinstalling poppler-data-0.4.11...
[21/21] Deleting files for poppler-data-0.4.11: 100%
Running fc-cache to build fontconfig cache...
pkg: sqlite error while executing VACUUM; in file pkgdb.c:2333: cannot VACUUM - SQL statements in progress
yurivict commented 1 year ago

BTW, this happens without Disk Full as well.

It looks like some SQLite related object isn't released when vacuuming is attempted.