search

albertlauncher / albert

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

Kubuntu 22.04 - problem with SQL ERROR: INSERT INTO execution #1129

Closed ZielonyBuszmen closed 2 years ago

ZielonyBuszmen commented 2 years ago

Description App Version: albert_0.17.6 OS: Kubuntu 22.04 LTS

After open albert (by shortcut alt + space), I have an error:

09:34:57 [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 The data row could not be retrieved  --  [(null)]

And app shuts down.

Expected behavior A clear and concise description of what you expected to happen.

Steps to reproduce

  1. Run Albert app (by terminal)
  2. Open Albert app by shortcut (alt + space)
  3. Close Albert window by alt + space
  4. Error appears in terminal

Additional information (please provide the following information): App Version: albert_0.17.6, downloaded from "OBS software repo". OS: Kubuntu 22.04 LTS

Output of `albert --report ` core: Albert version: 0.17.6 core: Build date: Oct 29 2017 00:00:00 core: Qt version: 5.15.3 core: QT_QPA_PLATFORMTHEME: core: Binary location: /usr/bin/albert core: PWD: /home/krzysiek core: SHELL: /bin/bash core: LANG: pl_PL.UTF-8 core: XDG_SESSION_TYPE: x11 core: XDG_CURRENT_DESKTOP: KDE core: DESKTOP_SESSION: plasma core: XDG_SESSION_DESKTOP: KDE core: OS: Ubuntu 22.04.1 LTS core: OS (type/version): ubuntu/22.04 core: Build ABI: x86_64-little_endian-lp64 core: Arch (build/current): x86_64/x86_64 core: Kernel (type/version): linux/5.15.0-48-generic
Output of `albert` when started in a terminal (stdout/stderr) 09:34:41 [info:core] Initializing application 09:34:41 [info:default] Systems icon theme is: "breeze" 09:34:41 [info:core] Initializing mandatory paths 09:34:41 [info:core] Setup signal handlers 09:34:41 [info:core] Creating running indicator file 09:34:41 [warn:core] Application has not been terminated graciously. 09:34:41 [info:core] Initializing core components 09:34:41 [info:core] Loading extension org.albert.extension.applications 09:34:41 [info:apps] Start indexing applications. 09:34:41 [debg:core] org.albert.extension.applications loaded in 1 milliseconds 09:34:41 [info:core] Loading extension org.albert.extension.calculator 09:34:42 [info:apps] Desktop file skipped: '/usr/share/applications/org.kde.kate.desktop' overwritten in '/home/krzysiek/.local/share/applications/org.kde.kate.desktop' 09:34:42 [debg:apps] Indexing desktop file: -home-krzysiek-Pulpit-Skrót do programu.desktop 09:34:42 [debg:apps] Indexing desktop file: albert.desktop 09:34:42 [debg:apps] Indexing desktop file: apport-kde-mime.desktop 09:34:42 [debg:apps] Indexing desktop file: byobu.desktop 09:34:42 [debg:apps] Indexing desktop file: chromium_chromium.desktop 09:34:42 [debg:apps] Indexing desktop file: code_code-url-handler.desktop 09:34:42 [debg:apps] Indexing desktop file: code_code.desktop 09:34:42 [debg:apps] Indexing desktop file: com.github.ztefn.haguichi.desktop 09:34:42 [debg:apps] Indexing desktop file: com.teamviewer.TeamViewer.desktop 09:34:42 [debg:core] org.albert.extension.calculator loaded in 21 milliseconds 09:34:42 [info:core] Loading extension org.albert.extension.files 09:34:42 [debg:apps] Indexing desktop file: debian-uxterm.desktop 09:34:42 [debg:applications] Loading file index from cache. 09:34:42 [debg:apps] Indexing desktop file: debian-xterm.desktop 09:34:42 [debg:apps] Indexing desktop file: discord_discord.desktop [....] (Only indexing files, without warning and errors) 09:34:42 [debg:applications] Building inverted file index. 09:34:43 [info:applications] Start indexing files. 09:34:43 [debg:core] org.albert.extension.files loaded in 1176 milliseconds 09:34:43 [info:core] Loading extension org.albert.extension.hashgenerator 09:34:43 [debg:core] org.albert.extension.hashgenerator loaded in 0 milliseconds 09:34:43 [info:core] Loading extension org.albert.extension.python 09:34:43 [warn:default] QFileSystemWatcher::removePaths: list is empty 09:34:43 [debg:python.modulev1] Reading metadata of python module: api_test 09:34:43 [debg:python.modulev1] Reading metadata of python module: arch_wiki 09:34:43 [debg:python.modulev1] Reading metadata of python module: atom_projects 09:34:43 [info:python.modulev1] Could not locate python module 'cson'. 09:34:43 [debg:python.modulev1] Reading metadata of python module: aur 09:34:43 [debg:python.modulev1] Reading metadata of python module: base_converter 09:34:43 [info:python.modulev1] Could not locate python module 'numpy'. 09:34:43 [debg:python.modulev1] Reading metadata of python module: binance 09:34:43 [debg:python.modulev1] Reading metadata of python module: bitwarden 09:34:43 [info:python.modulev1] No 'rbw' in $PATH. 09:34:43 [debg:python.modulev1] Reading metadata of python module: copyq 09:34:43 [info:python.modulev1] No 'copyq' in $PATH. 09:34:43 [debg:python.modulev1] Reading metadata of python module: currency_converter 09:34:43 [debg:python.modulev1] Reading metadata of python module: datetime 09:34:43 [debg:python.modulev1] Reading metadata of python module: docker 09:34:43 [info:python.modulev1] Could not locate python module 'docker'. 09:34:43 [debg:python.modulev1] Reading metadata of python module: fortune 09:34:43 [info:python.modulev1] No 'fortune' in $PATH. 09:34:43 [debg:python.modulev1] Reading metadata of python module: gnome_dictionary 09:34:43 [info:python.modulev1] No 'gnome-dictionary' in $PATH. 09:34:43 [debg:python.modulev1] Reading metadata of python module: gnote 09:34:43 [info:python.modulev1] No 'gnote' in $PATH. 09:34:43 [debg:python.modulev1] Reading metadata of python module: goldendict 09:34:43 [info:python.modulev1] No 'goldendict' in $PATH. 09:34:43 [debg:python.modulev1] Reading metadata of python module: google_translate 09:34:43 [debg:python.modulev1] Reading metadata of python module: ip 09:34:43 [debg:python.modulev1] Reading metadata of python module: jetbrains_projects 09:34:43 [warn:python.modulev1] [jetbrains_projects] Invalid version format: ''. Expected '^(\d)\.(\d)\.(\d)$'. 09:34:43 [debg:python.modulev1] Reading metadata of python module: kill 09:34:43 [debg:python.modulev1] Reading metadata of python module: locate 09:34:43 [debg:python.modulev1] Reading metadata of python module: lpass 09:34:43 [info:python.modulev1] No 'lpass' in $PATH. 09:34:43 [debg:python.modulev1] Reading metadata of python module: mathematica_eval 09:34:43 [info:python.modulev1] No 'wolframscript' in $PATH. 09:34:43 [debg:python.modulev1] Reading metadata of python module: multi_google_translate 09:34:43 [debg:python.modulev1] Reading metadata of python module: node_eval 09:34:43 [debg:python.modulev1] Reading metadata of python module: npm 09:34:43 [debg:python.modulev1] Reading metadata of python module: packagist 09:34:43 [info:python.modulev1] No 'composer' in $PATH. 09:34:43 [debg:python.modulev1] Reading metadata of python module: pacman 09:34:43 [info:python.modulev1] No 'expac' in $PATH. 09:34:43 [debg:python.modulev1] Reading metadata of python module: pass 09:34:43 [info:python.modulev1] No 'pass' in $PATH. 09:34:43 [debg:python.modulev1] Reading metadata of python module: php_eval 09:34:43 [debg:python.modulev1] Reading metadata of python module: pidgin 09:34:43 [debg:python.modulev1] Reading metadata of python module: pomodoro 09:34:43 [debg:python.modulev1] Reading metadata of python module: python_eval 09:34:43 [debg:python.modulev1] Reading metadata of python module: scrot 09:34:43 [info:python.modulev1] No 'xclip' in $PATH. 09:34:43 [debg:python.modulev1] Reading metadata of python module: tex_to_unicode 09:34:43 [info:python.modulev1] Could not locate python module 'pylatexenc'. 09:34:43 [debg:python.modulev1] Reading metadata of python module: texdoc 09:34:43 [info:python.modulev1] No 'texdoc' in $PATH. 09:34:43 [debg:python.modulev1] Reading metadata of python module: timer 09:34:43 [debg:python.modulev1] Reading metadata of python module: tomboy 09:34:43 [info:python.modulev1] No 'tomboy' in $PATH. 09:34:43 [debg:python.modulev1] Reading metadata of python module: trash 09:34:43 [debg:python.modulev1] Reading metadata of python module: unicode_emoji 09:34:43 [info:python.modulev1] No 'convert' in $PATH. 09:34:43 [debg:python.modulev1] Reading metadata of python module: units 09:34:43 [info:python.modulev1] No 'units' in $PATH. 09:34:43 [debg:python.modulev1] Reading metadata of python module: vpn 09:34:43 [debg:python.modulev1] Reading metadata of python module: wikipedia 09:34:43 [debg:python.modulev1] Reading metadata of python module: window_switcher 09:34:43 [info:python.modulev1] No 'wmctrl' in $PATH. 09:34:43 [debg:python.modulev1] Reading metadata of python module: xkcd 09:34:43 [warn:python.modulev1] [xkcd] Invalid version format: ''. Expected '^(\d)\.(\d)\.(\d)$'. 09:34:43 [debg:python.modulev1] Reading metadata of python module: youtube 09:34:43 [debg:python.modulev1] Reading metadata of python module: zeal 09:34:43 [info:python.modulev1] No 'zeal' in $PATH. 09:34:43 [debg:core] org.albert.extension.python loaded in 84 milliseconds 09:34:43 [info:core] Loading extension org.albert.extension.system 09:34:43 [debg:core] org.albert.extension.system loaded in 2 milliseconds 09:34:43 [info:core] Loading extension org.albert.extension.terminal 09:34:43 [debg:core] org.albert.extension.terminal loaded in 0 milliseconds 09:34:43 [info:term] Indexing $PATH. 09:34:43 [debg:term] Finished indexing $PATH. 09:34:43 [warn:core] No terminal command set. Using konsole -e 09:34:43 [info:core] Checking last used version 09:34:43 [info:core] Creating IPC server 09:34:43 [info:core] Entering eventloop 09:34:43 [info:apps] Indexed 90 applications. 09:34:43 [debg:applications] Serializing files… 09:34:43 [debg:applications] Building inverted file index… 09:34:44 [info:applications] Indexed 65366 files in 16402 directories. 09:34:56 [debg:core] ========== SESSION SETUP STARTED ========== 09:34:56 [debg:core] TIME: 0 µs SESSION SETUP [org.albert.extension.applications] 09:34:56 [debg:core] TIME: 0 µs SESSION SETUP [org.albert.extension.calculator] 09:34:56 [debg:core] TIME: 0 µs SESSION SETUP [org.albert.extension.python] 09:34:56 [debg:core] TIME: 0 µs SESSION SETUP [org.albert.extension.files] 09:34:56 [debg:core] TIME: 0 µs SESSION SETUP [org.albert.extension.system] 09:34:56 [debg:core] TIME: 0 µs SESSION SETUP [org.albert.extension.terminal] 09:34:56 [debg:core] TIME: 0 µs SESSION SETUP [org.albert] 09:34:56 [debg:core] TIME: 0 µs SESSION SETUP [org.albert.extension.hashgenerator] 09:34:56 [debg:core] TIME: 82 µs SESSION SETUP OVERALL 09:34:56 [debg:core] ========== QUERY: ========== 09:34:56 [debg:core] TIME: 59 µs SESSION TEARDOWN OVERALL 09:34:56 [debg:core] TIME: 14 µs MATCHES [org.albert.extension.python] 09:34:56 [debg:core] TIME: 1 µs MATCHES [org.albert.extension.calculator] 09:34:56 [debg:core] TIME: 1 µs MATCHES [org.albert.extension.system] 09:34:56 [debg:core] TIME: 1 µs MATCHES [org.albert] 09:34:56 [debg:core] TIME: 3 µs MATCHES [org.albert.extension.hashgenerator] 09:34:56 [debg:core] TIME: 141 µs MATCHES [org.albert.extension.applications] 09:34:56 [debg:core] TIME: 1 µs MATCHES [org.albert.extension.terminal] 09:34:56 [debg:core] TIME: 3 µs MATCHES [org.albert.extension.files] 09:34:56 [debg:core] TIME: 3167 µs QUERY OVERALL 09:34:57 [debg:core] ========== SESSION TEARDOWN STARTED ========== 09:34:57 [debg:core] TIME: 1 µs SESSION TEARDOWN [org.albert.extension.applications] 09:34:57 [debg:core] TIME: 0 µs SESSION TEARDOWN [org.albert.extension.calculator] 09:34:57 [debg:core] TIME: 0 µs SESSION TEARDOWN [org.albert.extension.python] 09:34:57 [debg:core] TIME: 0 µs SESSION TEARDOWN [org.albert.extension.files] 09:34:57 [debg:core] TIME: 0 µs SESSION TEARDOWN [org.albert.extension.system] 09:34:57 [debg:core] TIME: 0 µs SESSION TEARDOWN [org.albert.extension.terminal] 09:34:57 [debg:core] TIME: 0 µs SESSION TEARDOWN [org.albert] 09:34:57 [debg:core] TIME: 0 µs SESSION TEARDOWN [org.albert.extension.hashgenerator] 09:34:57 [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 The data row could not be retrieved -- [(null)]
ManuelSchneid3r commented 2 years ago

Again I cannot reproduce this issue 😩

ManuelSchneid3r commented 2 years ago

Do you mind to send your core.db?

Sudo-kun commented 2 years ago

I had the same issue, a quick but dirty workaround was removing the core.db at .config/albert/core.db file and starting albert again.

albert version: 0.17.6 Linux Mint Version: 20.1

ManuelSchneid3r commented 2 years ago

Please send your core.db. I can't reproduce this issue: https://t.me/ef551af8

ZielonyBuszmen commented 2 years ago

I remove all files from config, end everything start working :) (.config/albert/)

Thanks for help @Sudo-kun And thank you very much, @ManuelSchneid3r, for quick answer and willingness to help.