Skip to content

Crash during export to sql #4154

Open
Open

Description

@jebissey

Details for the issue

What did you do?

Create a base with:
sqlite3 /tmp/test.db <<'EOF'
CREATE TABLE test(id INTEGER PRIMARY KEY, name TEXT);
INSERT INTO test(name) VALUES ('abc');
EOF

open with:
sqlitebrowser

export to sql file

What did you expect to see?

What did you see instead?

many lines
KServiceTypeTrader: serviceType "ThumbCreator" not found

and finaly

terminate called after throwing an instance of 'std::bad_alloc'
what(): std::bad_alloc
Abandon (core dumped)

Useful extra information

DB4S v3.13.99 (Apr 11 2025) [built for x86_64-little_endian-lp64] on Debian GNU/Linux 13 (trixie) (linux/6.12.90 deb13.1-amd64) [x86_64]
using SQLCipher Version 4.6.1 community (based on SQLite 3.46.1)
and Qt 5.15.15

Activity

  1. FriedrichFroebel commented on Jun 23, 2026

    @FriedrichFroebel
    Contributor

    Running a quick test, I have not been able to reproduce this crash with the default version of Ubuntu 24.04 and the latest AppImage release.

    KServiceTypeTrader: serviceType "ThumbCreator" not found

    I am not sure this is related to your issue.

  2. jebissey commented on Jun 24, 2026

    @jebissey
    Author

    This morning I tried
    jeb@debian:~$ sudo apt purge sqlitebrowser
    [sudo] Mot de passe de jeb :

    SUPPRESSION :
    sqlitebrowser*

    Sommaire :
    Mise à niveau de : 0. Installation de : 0Supprimé : 1. Non mis à jour : 0
    Espace libéré : 6 838 kB

    Continuer ? [O/n]
    (Lecture de la base de données... 270091 fichiers et répertoires déjà installés.)
    Suppression de sqlitebrowser (3.13.0-1+b1) ...
    Traitement des actions différées (« triggers ») pour man-db (2.13.1-1) ...
    Traitement des actions différées (« triggers ») pour mailcap (3.74) ...
    Traitement des actions différées (« triggers ») pour hicolor-icon-theme (0.18-2) ...
    jeb@debian:~$ sudo apt install sqlitebrowser

    Installation de :
    sqlitebrowser

    Sommaire :
    Mise à niveau de : 0. Installation de : 1Supprimé : 0. Non mis à jour : 0
    Taille du téléchargement : 2 597 kB
    Espace nécessaire : 6 838 kB / 13,2 GB disponible

    Réception de : 1 http://deb.debian.org/debian trixie/main amd64 sqlitebrowser amd64 3.13.0-1+b1 [2 597 kB]
    2 597 ko réceptionnés en 0s (11,7 Mo/s)
    Sélection du paquet sqlitebrowser précédemment désélectionné.
    (Lecture de la base de données... 270080 fichiers et répertoires déjà installés.)
    Préparation du dépaquetage de .../sqlitebrowser_3.13.0-1+b1_amd64.deb ...
    Dépaquetage de sqlitebrowser (3.13.0-1+b1) ...
    Paramétrage de sqlitebrowser (3.13.0-1+b1) ...
    Traitement des actions différées (« triggers ») pour hicolor-icon-theme (0.18-2) ...
    Traitement des actions différées (« triggers ») pour man-db (2.13.1-1) ...
    Traitement des actions différées (« triggers ») pour mailcap (3.74) ...
    jeb@debian:$ sqlitebrowser
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    Processus arrêté
    jeb@debian:
    $

    I would like to open the db created yesterday. Of course this db didn't exist anymore. So I closed the dialog box and application crashed.

    I tried again
    jeb@debian:$ sqlite3 /tmp/test.db <<'EOF'
    CREATE TABLE test(id INTEGER PRIMARY KEY, name TEXT);
    INSERT INTO test(name) VALUES ('abc');
    EOF
    jeb@debian:
    $ sqlitebrowser
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    KServiceTypeTrader: serviceType "ThumbCreator" not found
    terminate called after throwing an instance of 'std::bad_alloc'
    what(): std::bad_alloc
    Abandon (core dumped)
    jeb@debian:~$

    Same result. And opening the database lasted 10 secondes.
    I use debian13 with KDE.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions