search

albertlauncher / albert

A fast and flexible keyboard launcher
https://albertlauncher.github.io
Other
7.26k stars 305 forks source link

Albert crashes on minimize with `SQL ERROR: INSERT INTO execution ... UNIQUE constraint failed` #1138

Closed cartisan closed 2 years ago

cartisan commented 2 years ago

Description Albert crashes on minimizing. I get following log message when running albert from the terminal:

15:36:24 [warn:default] file:///usr/share/albert/org.albert.frontend.qmlboxmodel/styles/BoxModel/ItemViewDelegate.qml:18: TypeError: Cannot read property 'width' of null
15:36:24 [fatal:default] SQL ERROR: INSERT INTO execution (query_id, handler_id, runtime) VALUES (:query_id, :handler_id, :runtime); UNIQUE constraint failed: execution.query_id, execution.handler_id Unable to fetch row  --  [(null)]

Interestingly, if I run albert with sudo privileges, the error does not appear.

Expected behavior Albert does not crash on minimizing.

Steps to reproduce

  1. Start albert with hotkey (for me: Alt+Space)
  2. Minimize albert with hotkey (Alt+Space)
  3. Crash happens.

Additional information (please provide the following information):

Output of `albert --report ` ``` core: Albert version: 0.17.6 core: Build date: Oct 29 2017 00:00:00 core: Qt version: 5.15.2 core: QT_QPA_PLATFORMTHEME: core: Binary location: /usr/bin/albert core: PWD: /home/leonid/code/prism_john core: SHELL: /bin/bash core: LANG: en_US.UTF-8 core: XDG_SESSION_TYPE: x11 core: XDG_CURRENT_DESKTOP: ubuntu:GNOME core: DESKTOP_SESSION: ubuntu core: XDG_SESSION_DESKTOP: ubuntu core: OS: Ubuntu 21.10 core: OS (type/version): ubuntu/21.10 core: Build ABI: x86_64-little_endian-lp64 core: Arch (build/current): x86_64/x86_64 core: Kernel (type/version): linux/5.13.0-52-generic ```
Output of `albert` when started in a terminal (stdout/stderr) ``` 15:45:49 [info:core] Initializing application 15:45:49 [info:default] Systems icon theme is: "Yaru" 15:45:49 [info:core] Initializing mandatory paths 15:45:49 [info:core] Setup signal handlers 15:45:49 [info:core] Creating running indicator file 15:45:49 [warn:core] Application has not been terminated graciously. 15:45:49 [info:core] Initializing core components 15:45:49 [warn:default] file:///usr/share/albert/org.albert.frontend.qmlboxmodel/styles/BoxModel/MainComponent.qml:275:5: QML Connections: Implicitly defined onFoo properties in Connections are deprecated. Use this syntax instead: function onFoo() { ... } 15:45:49 [warn:default] file:///usr/share/albert/org.albert.frontend.qmlboxmodel/styles/BoxModel/DesktopListView.qml:16:5: QML Connections: Implicitly defined onFoo properties in Connections are deprecated. Use this syntax instead: function onFoo() { ... } 15:45:49 [warn:default] file:///usr/share/albert/org.albert.frontend.qmlboxmodel/styles/BoxModel/DesktopListView.qml:16:5: QML Connections: Implicitly defined onFoo properties in Connections are deprecated. Use this syntax instead: function onFoo() { ... } 15:45:49 [info:core] Loading extension org.albert.extension.applications 15:45:49 [info:apps] Start indexing applications. 15:45:49 [debg:core] org.albert.extension.applications loaded in 0 milliseconds 15:45:49 [info:core] Loading extension org.albert.extension.calculator 15:45:49 [info:apps] Desktop file skipped: '/usr/share/applications/info.desktop' overwritten in '/usr/share/ubuntu/applications/info.desktop' 15:45:49 [info:apps] Desktop file skipped: '/usr/share/applications/gnome-initial-setup.desktop' overwritten in '/usr/share/ubuntu/applications/gnome-initial-setup.desktop' 15:45:49 [debg:core] org.albert.extension.calculator loaded in 3 milliseconds 15:45:49 [info:core] Loading extension org.albert.extension.files 15:45:49 [debg:applications] Loading file index from cache. 15:45:49 [debg:apps] Indexing desktop file: 1password.desktop 15:45:49 [debg:apps] Indexing desktop file: albert.desktop 15:45:49 [debg:apps] Indexing desktop file: appimagekit-joplin.desktop 15:45:49 [debg:apps] Indexing desktop file: apport-gtk.desktop 15:45:49 [debg:apps] Indexing desktop file: apturl.desktop 15:45:49 [debg:apps] Indexing desktop file: bluetooth-sendto.desktop 15:45:49 [debg:apps] Indexing desktop file: ca.desrt.dconf-editor.desktop 15:45:49 [debg:apps] Indexing desktop file: com.ulduzsoft.Birdtray.desktop 15:45:49 [debg:apps] Indexing desktop file: evolution-calendar.desktop 15:45:49 [debg:apps] Indexing desktop file: gcr-prompter.desktop 15:45:49 [debg:apps] Indexing desktop file: gcr-viewer.desktop 15:45:49 [debg:apps] Indexing desktop file: geoclue-demo-agent.desktop 15:45:49 [debg:apps] Indexing desktop file: gimp_gimp.desktop 15:45:49 [debg:apps] Indexing desktop file: gkbd-keyboard-display.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-applications-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-background-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-bluetooth-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-camera-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-color-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-connectivity-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-control-center.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-datetime-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-default-apps-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-diagnostics-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-disk-image-mounter.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-disk-image-writer.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-display-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-info-overview-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-initial-setup.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-keyboard-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-language-selector.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-location-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-lock-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-microphone-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-mouse-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-network-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-notifications-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-online-accounts-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-power-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-printers-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-region-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-removable-media-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-search-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-session-properties.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-sharing-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-sound-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-system-monitor-kde.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-system-monitor.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-thunderbolt-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-ubuntu-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-universal-access-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-usage-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-user-accounts-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-wacom-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: gnome-wifi-panel.desktop 15:45:49 [debg:apps] Indexing desktop file: google-chrome.desktop 15:45:49 [debg:apps] Indexing desktop file: guvcview.desktop 15:45:49 [debg:apps] Indexing desktop file: gvim.desktop 15:45:49 [debg:apps] Indexing desktop file: hplj1020.desktop 15:45:49 [debg:apps] Indexing desktop file: htop.desktop 15:45:49 [debg:apps] Indexing desktop file: ibus-setup-table.desktop 15:45:49 [debg:apps] Indexing desktop file: im-config.desktop 15:45:49 [debg:apps] Indexing desktop file: info.desktop 15:45:49 [debg:apps] Indexing desktop file: input-remapper.desktop 15:45:49 [debg:apps] Indexing desktop file: insomnia.desktop 15:45:49 [debg:apps] Indexing desktop file: io.snapcraft.SessionAgent.desktop 15:45:49 [debg:apps] Indexing desktop file: jetbrains-pycharm.desktop 15:45:49 [debg:apps] Indexing desktop file: jetbrains-toolbox.desktop 15:45:49 [debg:apps] Indexing desktop file: ktelnetservice5.desktop 15:45:49 [debg:apps] Indexing desktop file: libreoffice-calc.desktop 15:45:49 [debg:apps] Indexing desktop file: libreoffice-draw.desktop 15:45:49 [debg:apps] Indexing desktop file: libreoffice-impress.desktop 15:45:49 [debg:apps] Indexing desktop file: libreoffice-math.desktop 15:45:49 [debg:apps] Indexing desktop file: libreoffice-startcenter.desktop 15:45:49 [debg:apps] Indexing desktop file: libreoffice-writer.desktop 15:45:49 [debg:apps] Indexing desktop file: libreoffice-xsltfilter.desktop 15:45:49 [debg:apps] Indexing desktop file: masterpdfeditor5.desktop 15:45:49 [debg:apps] Indexing desktop file: mono-runtime-common.desktop 15:45:49 [debg:apps] Indexing desktop file: mono-runtime-terminal.desktop 15:45:49 [debg:apps] Indexing desktop file: nautilus-autorun-software.desktop 15:45:49 [debg:apps] Indexing desktop file: net.launchpad.plank.AppsLauncher.desktop 15:45:49 [debg:apps] Indexing desktop file: nm-applet.desktop 15:45:49 [debg:apps] Indexing desktop file: nm-connection-editor.desktop 15:45:49 [debg:apps] Indexing desktop file: nordvpn.desktop 15:45:49 [debg:apps] Indexing desktop file: obsidian_obsidian.desktop 15:45:49 [debg:apps] Indexing desktop file: okularApplication_chm.desktop 15:45:49 [debg:apps] Indexing desktop file: okularApplication_comicbook.desktop 15:45:49 [debg:apps] Indexing desktop file: okularApplication_djvu.desktop 15:45:49 [debg:apps] Indexing desktop file: okularApplication_dvi.desktop 15:45:49 [debg:apps] Indexing desktop file: okularApplication_epub.desktop 15:45:49 [debg:apps] Indexing desktop file: okularApplication_fax.desktop 15:45:49 [debg:apps] Indexing desktop file: okularApplication_fb.desktop 15:45:49 [debg:apps] Indexing desktop file: okularApplication_ghostview.desktop 15:45:49 [debg:apps] Indexing desktop file: okularApplication_kimgio.desktop 15:45:49 [debg:apps] Indexing desktop file: okularApplication_md.desktop 15:45:49 [debg:apps] Indexing desktop file: okularApplication_mobi.desktop 15:45:49 [debg:apps] Indexing desktop file: okularApplication_pdf.desktop 15:45:49 [debg:apps] Indexing desktop file: okularApplication_plucker.desktop 15:45:49 [debg:apps] Indexing desktop file: okularApplication_tiff.desktop 15:45:49 [debg:apps] Indexing desktop file: okularApplication_txt.desktop 15:45:49 [debg:apps] Indexing desktop file: okularApplication_xps.desktop 15:45:49 [debg:apps] Indexing desktop file: org.flameshot.Flameshot.desktop 15:45:49 [debg:apps] Indexing desktop file: org.freedesktop.IBus.Panel.Emojier.desktop 15:45:49 [debg:apps] Indexing desktop file: org.freedesktop.IBus.Panel.Extension.Gtk3.desktop 15:45:49 [debg:apps] Indexing desktop file: org.freedesktop.IBus.Setup.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Calculator.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Characters.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Cheese.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.ChromeGnomeShell.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.DejaDup.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.DiskUtility.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Evince-previewer.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Evince.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Evolution-alarm-notify.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Extensions.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.FileRoller.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Logs.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Mahjongg.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Mines.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Nautilus.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.PowerStats.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Screenshot.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Shell.Extensions.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Shell.PortalHelper.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Shell.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Sudoku.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Terminal.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Todo.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.Totem.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.baobab.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.eog.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.font-viewer.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.gedit.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.seahorse.Application.desktop 15:45:49 [debg:apps] Indexing desktop file: org.gnome.tweaks.desktop 15:45:49 [debg:apps] Indexing desktop file: org.kde.kdeconnect.app.desktop 15:45:49 [debg:apps] Indexing desktop file: org.kde.kdeconnect.daemon.desktop 15:45:49 [debg:apps] Indexing desktop file: org.kde.kdeconnect.handler.desktop 15:45:49 [debg:apps] Indexing desktop file: org.kde.kdeconnect.nonplasma.desktop 15:45:49 [debg:apps] Indexing desktop file: org.kde.kdeconnect.settings.desktop 15:45:49 [debg:apps] Indexing desktop file: org.kde.kdeconnect.sms.desktop 15:45:49 [debg:apps] Indexing desktop file: org.kde.kdeconnect_open.desktop 15:45:49 [debg:apps] Indexing desktop file: org.kde.kded5.desktop 15:45:49 [debg:apps] Indexing desktop file: org.kde.keditbookmarks.desktop 15:45:49 [debg:apps] Indexing desktop file: org.kde.knotes.desktop 15:45:49 [debg:apps] Indexing desktop file: org.kde.mobile.okular_chm.desktop 15:45:49 [debg:apps] Indexing desktop file: org.kde.mobile.okular_djvu.desktop 15:45:49 [debg:apps] Indexing desktop file: org.kde.mobile.okular_epub.desktop 15:45:49 [debg:apps] Indexing desktop file: org.kde.mobile.okular_md.desktop 15:45:49 [debg:apps] Indexing desktop file: org.kde.mobile.okular_tiff.desktop 15:45:49 [debg:apps] Indexing desktop file: org.kde.okular.desktop 15:45:49 [debg:apps] Indexing desktop file: org.remmina.Remmina.desktop 15:45:49 [debg:apps] Indexing desktop file: pinta.desktop 15:45:49 [debg:apps] Indexing desktop file: plank.desktop 15:45:49 [debg:apps] Indexing desktop file: python3.9.desktop 15:45:49 [debg:apps] Indexing desktop file: remmina-file.desktop 15:45:49 [debg:apps] Indexing desktop file: remmina-gnome.desktop 15:45:49 [debg:apps] Indexing desktop file: rhythmbox-device.desktop 15:45:49 [debg:apps] Indexing desktop file: rhythmbox.desktop 15:45:49 [debg:apps] Indexing desktop file: rygel.desktop 15:45:49 [debg:apps] Indexing desktop file: shotwell-viewer.desktop 15:45:49 [debg:apps] Indexing desktop file: shotwell.desktop 15:45:49 [debg:apps] Indexing desktop file: simple-scan.desktop 15:45:49 [debg:apps] Indexing desktop file: slack_slack.desktop 15:45:49 [debg:apps] Indexing desktop file: snap-handle-link.desktop 15:45:49 [debg:apps] Indexing desktop file: snap-store_snap-store.desktop 15:45:49 [debg:apps] Indexing desktop file: snap-store_ubuntu-software-local-file.desktop 15:45:49 [debg:apps] Indexing desktop file: snap-store_ubuntu-software.desktop 15:45:49 [debg:apps] Indexing desktop file: software-properties-drivers.desktop 15:45:49 [debg:apps] Indexing desktop file: software-properties-gtk.desktop 15:45:49 [debg:apps] Indexing desktop file: software-properties-livepatch.desktop 15:45:49 [debg:apps] Indexing desktop file: sol.desktop 15:45:49 [debg:apps] Indexing desktop file: solaar.desktop 15:45:49 [debg:apps] Indexing desktop file: spotify_spotify.desktop 15:45:49 [debg:apps] Indexing desktop file: sticky.desktop 15:45:49 [debg:applications] Building inverted file index. 15:45:49 [debg:apps] Indexing desktop file: synaptic.desktop 15:45:49 [debg:apps] Indexing desktop file: system-config-printer.desktop 15:45:49 [debg:apps] Indexing desktop file: terminator.desktop 15:45:49 [debg:apps] Indexing desktop file: texdoctk.desktop 15:45:49 [debg:apps] Indexing desktop file: thunderbird.desktop 15:45:49 [debg:apps] Indexing desktop file: transmission-gtk.desktop 15:45:49 [debg:apps] Indexing desktop file: update-manager.desktop 15:45:49 [debg:apps] Indexing desktop file: usb-creator-gtk.desktop 15:45:49 [debg:apps] Indexing desktop file: userapp-Thunderbird-O615C1.desktop 15:45:49 [debg:apps] Indexing desktop file: vim.desktop 15:45:49 [debg:apps] Indexing desktop file: virtualbox.desktop 15:45:49 [debg:apps] Indexing desktop file: vlc_vlc.desktop 15:45:49 [debg:apps] Indexing desktop file: xdg-desktop-portal-gtk.desktop 15:45:49 [debg:apps] Indexing desktop file: xpad.desktop 15:45:49 [debg:apps] Indexing desktop file: yelp.desktop 15:45:50 [info:applications] Start indexing files. 15:45:50 [debg:core] org.albert.extension.files loaded in 1426 milliseconds 15:45:50 [info:core] Loading extension org.albert.extension.websearch 15:45:50 [debg:core] org.albert.extension.websearch loaded in 0 milliseconds 15:45:50 [info:core] Checking last used version 15:45:50 [info:core] Creating IPC server 15:45:50 [info:core] Entering eventloop 15:45:50 [info:apps] Indexed 88 applications. 15:45:50 [debg:applications] Serializing files… 15:45:51 [debg:applications] Building inverted file index… 15:45:52 [info:applications] Indexed 109667 files in 17688 directories. 15:45:54 [debg:core] ========== SESSION SETUP STARTED ========== 15:45:54 [debg:core] TIME: 1 µs SESSION SETUP [org.albert.extension.files] 15:45:54 [debg:core] TIME: 0 µs SESSION SETUP [org.albert] 15:45:54 [debg:core] TIME: 1 µs SESSION SETUP [org.albert.extension.calculator] 15:45:54 [debg:core] TIME: 1 µs SESSION SETUP [org.albert.extension.applications] 15:45:54 [debg:core] TIME: 1 µs SESSION SETUP [org.albert.extension.websearch] 15:45:54 [debg:core] TIME: 171 µs SESSION SETUP OVERALL 15:45:54 [debg:core] ========== QUERY: ========== 15:45:54 [debg:core] TIME: 92 µs SESSION TEARDOWN OVERALL 15:45:54 [debg:core] TIME: 4 µs MATCHES [org.albert.extension.files] 15:45:54 [debg:core] TIME: 2 µs MATCHES [org.albert.extension.calculator] 15:45:54 [debg:core] TIME: 18 µs MATCHES [org.albert.extension.websearch] 15:45:54 [debg:core] TIME: 1 µs MATCHES [org.albert] 15:45:54 [debg:core] TIME: 191 µs MATCHES [org.albert.extension.applications] 15:45:54 [debg:core] TIME: 7538 µs QUERY OVERALL 15:45:54 [warn:default] file:///usr/share/albert/org.albert.frontend.qmlboxmodel/styles/BoxModel/MainComponent.qml:87:21: QML Connections: Implicitly defined onFoo properties in Connections are deprecated. Use this syntax instead: function onFoo() { ... } 15:45:55 [debg:core] ========== SESSION TEARDOWN STARTED ========== 15:45:55 [debg:core] TIME: 1 µs SESSION TEARDOWN [org.albert.extension.files] 15:45:55 [debg:core] TIME: 0 µs SESSION TEARDOWN [org.albert] 15:45:55 [debg:core] TIME: 1 µs SESSION TEARDOWN [org.albert.extension.calculator] 15:45:55 [debg:core] TIME: 1 µs SESSION TEARDOWN [org.albert.extension.applications] 15:45:55 [debg:core] TIME: 1 µs SESSION TEARDOWN [org.albert.extension.websearch] 15:45:55 [fatal:default] SQL ERROR: INSERT INTO execution (query_id, handler_id, runtime) VALUES (:query_id, :handler_id, ```
ManuelSchneid3r commented 2 years ago

https://github.com/albertlauncher/albert/search?q=UNIQUE+constraint+failed&type=issues