[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#1087148: firefox-esr: [regression] leaves even unchanged sqlite files open

Package: firefox-esr
Version: 128.4.0esr-1~deb11u1
Severity: normal
X-Debbugs-Cc: tg@mirbsd.de, debian-lts@lists.debian.org

Ever since the major upgrade to 128, I noticed during backing up my system
that firefox-esr leaves all or almost all of the sqlite files open on exit
as if it crashed, leaving -shm/-wal files around by the hundreds.

I verified that it did so for things like…
PROFILE/storage/default/https+++www.kleinanzeigen.de/idb/3619119340leogcaarlof.sqlite
… when I didn’t even visit the site since the last time I can know it had
no -shm/-wal files lying around: I’ve added…

find ~/.mozilla/firefox/ \( -name \*-shm -o -name \*-wal \) -print0 | \
    while IFS= read -d '' -r name; do
        [[ -e $name ]] || continue
        sqlite3 "${name%-@(shm|wal)}" VACUUM
done

… to my pre-backup runs to get rid of these files, but the resulting
.sqlite files still differ between backup runs *due to* the VACUUM
(it’s noticeably more amount than before the major upgrade).

Additionally, this seems like it could lead to data loss, if it has
not finalised writing things before exit(2)ing the process by leaving
open databasish files.


-- Package-specific info:

-- Extensions information
Name: Add-ons Search Detection
Location: /usr/lib/firefox-esr/browser/omni.ja
Package: firefox-esr
Status: enabled

Name: AI Noise-cancelling headphones
Location: ${PROFILE_EXTENSIONS}/{43ff6c1c-937e-4ec2-a3c5-267bc6c360c3}.xpi
Status: user-disabled

Name: Bing
Location: /usr/lib/firefox-esr/browser/omni.ja
Package: firefox-esr
Status: enabled

Name: Consent-O-Matic
Location: ${PROFILE_EXTENSIONS}/gdpr@cavi.au.dk.xpi
Status: enabled

Name: Dark theme
Location: /usr/lib/firefox-esr/browser/omni.ja
Package: firefox-esr
Status: enabled

Name: Dark Background and Light Text
Location: ${PROFILE_EXTENSIONS}/jid1-QoFqdK4qzUfGWQ@jetpack.xpi
Status: enabled

Name: Detect Cloudflare
Location: ${PROFILE_EXTENSIONS}/{eae9e728-c240-49cd-8d2c-88ac18fea650}.xpi
Status: enabled

Name: DuckDuckGo
Location: /usr/lib/firefox-esr/browser/omni.ja
Package: firefox-esr
Status: enabled

Name: Editable QR Generator
Location: ${PROFILE_EXTENSIONS}/{cd6aaef4-adda-43c6-9222-f6281fc75f23}.xpi
Status: enabled

Name: Firefox Alpenglow theme
Location: /usr/lib/firefox-esr/browser/omni.ja
Package: firefox-esr
Status: user-disabled

Name: Firefox Screenshots
Location: /usr/lib/firefox-esr/browser/features/screenshots@mozilla.org.xpi
Package: firefox-esr
Status: user-disabled

Name: Form Autofill
Location: /usr/lib/firefox-esr/browser/features/formautofill@mozilla.org.xpi
Package: firefox-esr
Status: enabled

Name: Google
Location: /usr/lib/firefox-esr/browser/omni.ja
Package: firefox-esr
Status: enabled

Name: Light theme
Location: /usr/lib/firefox-esr/browser/omni.ja
Package: firefox-esr
Status: user-disabled

Name: Picture-In-Picture
Location: /usr/lib/firefox-esr/browser/features/pictureinpicture@mozilla.org.xpi
Package: firefox-esr
Status: enabled

Name: Regex Search
Location: ${PROFILE_EXTENSIONS}/{cb08faed-9460-474a-ba0b-d98b13b5e001}.xpi
Status: enabled

Name: System theme — auto theme
Location: /usr/lib/firefox-esr/omni.ja
Package: firefox-esr
Status: user-disabled

Name: Web Compatibility Interventions
Location: /home/tg/.mozilla/firefox/h02me2ol.default-esr/features/{5c684e54-4c09-4472-bd69-e01b2ab3a40f}/webcompat@mozilla.org.xpi
Status: enabled

Name: WebCompat Reporter
Location: /usr/lib/firefox-esr/browser/features/webcompat-reporter@mozilla.org.xpi
Package: firefox-esr
Status: user-disabled

Name: Wikipedia (en)
Location: /usr/lib/firefox-esr/browser/omni.ja
Package: firefox-esr
Status: enabled


-- Addons package information
ii  firefox-esr    128.4.0esr-1~deb11u1 amd64        Mozilla Firefox web browser - Extended Support Release (ESR)

-- System Information:
Debian Release: 11.11
  APT prefers oldstable-updates
  APT policy: (500, 'oldstable-updates'), (500, 'oldstable-security'), (500, 'oldstable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 5.10.0-32-amd64 (SMP w/2 CPU threads)
Kernel taint flags: TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE
Locale: LANG=C.UTF-8, LC_CTYPE=C.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /bin/lksh
Init: sysvinit (via /sbin/init)

Versions of packages firefox-esr depends on:
ii  debianutils          4.11.2
ii  fontconfig           2.13.1-4.2
ii  libasound2           1.2.4-1.1
ii  libatk1.0-0          2.36.0-2
ii  libc6                2.31-13+deb11u11
ii  libcairo-gobject2    1.16.0-5
ii  libcairo2            1.16.0-5
ii  libdbus-1-3          1.12.28-0+deb11u1
ii  libevent-2.1-7       2.1.12-stable-1
ii  libffi7              3.3-6
ii  libfontconfig1       2.13.1-4.2
ii  libfreetype6         2.10.4+dfsg-1+deb11u1
ii  libgcc-s1            10.2.1-6
ii  libgdk-pixbuf-2.0-0  2.42.2+dfsg-1+deb11u2
ii  libglib2.0-0         2.66.8-1+deb11u4
ii  libgtk-3-0           3.24.24-4+deb11u4
ii  libpango-1.0-0       1.46.2-3
ii  libstdc++6           10.2.1-6
ii  libx11-6             2:1.7.2-1+deb11u2
ii  libx11-xcb1          2:1.7.2-1+deb11u2
ii  libxcb-shm0          1.14-3
ii  libxcb1              1.14-3
ii  libxcomposite1       1:0.4.5-1
ii  libxdamage1          1:1.1.5-2
ii  libxext6             2:1.3.3-1.1
ii  libxfixes3           1:5.0.3-2
ii  libxrandr2           2:1.5.1-1
ii  procps               2:3.3.17-5
ii  zlib1g               1:1.2.11.dfsg-2+deb11u2

Versions of packages firefox-esr recommends:
ii  libavcodec58  7:4.3.8-0+deb11u1

Versions of packages firefox-esr suggests:
ii  fonts-lmodern          2.004.5-6.1
ii  fonts-stix [otf-stix]  1.1.1-4.1
pn  libcanberra0           <none>
ii  libgssapi-krb5-2       1.18.3-6+deb11u5
pn  pulseaudio             <none>

-- no debconf information

-- debsums errors found:
debsums: changed file /usr/lib/firefox-esr/browser/omni.ja (from firefox-esr package)
debsums: changed file /usr/lib/firefox-esr/omni.ja (from firefox-esr package)
Reply to: