Fedora Account System
Red Hat Associate
Red Hat Customer
Description of problem: I was just using sqlitebrowser and executing a simple sql-command. Version-Release number of selected component: sqlitebrowser-3.12.1-1.fc33 Additional info: reporter: libreport-2.14.0 backtrace_rating: 4 cgroup: 0::/user.slice/user-1000.slice/user/app-gnome-sqlitebrowser-122631.scope cmdline: sqlitebrowser crash_function: qt_message_fatal executable: /usr/bin/sqlitebrowser journald_cursor: s=443fe3cbc03748a0991ecf610fd3494e;i=5bfc;b=af6c0db8e40e4609935311a77399529b;m=21373d90cc;t=5b97dd41a525e;x=e7bfd766e8c92a41 kernel: 5.10.7-200.fc33.x86_64 rootdir: / runlevel: N 5 type: CCpp uid: 1000
Created attachment 1750108 [details] File: backtrace
Created attachment 1750109 [details] File: core_backtrace
Created attachment 1750110 [details] File: cpuinfo
Created attachment 1750111 [details] File: dso_list
Created attachment 1750112 [details] File: environ
Created attachment 1750113 [details] File: limits
Created attachment 1750114 [details] File: maps
Created attachment 1750115 [details] File: mountinfo
Created attachment 1750116 [details] File: open_fds
Created attachment 1750117 [details] File: proc_pid_status
Created attachment 1750118 [details] File: var_log_messages
*** Bug 1921276 has been marked as a duplicate of this bug. ***
Looks like an assertion failure in the query parser. Do you recall the query you submitted resp. is it reproducible?
Created attachment 1752031 [details] Test database
I cannot be certain which query crashed the sqlitebrowser, but after some testing I found out that these steps should do the trick: 1. Open 2020k_demot.db (See attachments) 2. Execute this query: SELECT tp.tp_id, tp.sijainti FROM tarkistuspiste tp WHERE 5 <= (SELECT COUNT(asiakas_id) FROM tarkistus t WHERE tp.tp_id = t.tp_id GROUP BY tp_id, asiakas_id); 3. Execute this query (same as in the step 2. except for the the missing semicolon): SELECT tp.tp_id, tp.sijainti FROM tarkistuspiste tp WHERE 5 <= (SELECT COUNT(asiakas_id) FROM tarkistus t WHERE tp.tp_id = t.tp_id GROUP BY tp_id, asiakas_id) Hope this helps!
Taken upstream: https://github.com/sqlitebrowser/sqlitebrowser/issues/2611
FEDORA-2021-c7de344a42 has been submitted as an update to Fedora 33. https://bodhi.fedoraproject.org/updates/FEDORA-2021-c7de344a42
FEDORA-2021-c05a50fdb2 has been submitted as an update to Fedora 35. https://bodhi.fedoraproject.org/updates/FEDORA-2021-c05a50fdb2
FEDORA-2021-e3e53e3809 has been submitted as an update to Fedora 34. https://bodhi.fedoraproject.org/updates/FEDORA-2021-e3e53e3809
FEDORA-2021-c05a50fdb2 has been pushed to the Fedora 35 testing repository. Soon you'll be able to install the update with the following command: `sudo dnf upgrade --enablerepo=updates-testing --advisory=FEDORA-2021-c05a50fdb2` You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2021-c05a50fdb2 See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.
FEDORA-2021-e3e53e3809 has been pushed to the Fedora 34 testing repository. Soon you'll be able to install the update with the following command: `sudo dnf upgrade --enablerepo=updates-testing --advisory=FEDORA-2021-e3e53e3809` You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2021-e3e53e3809 See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.
FEDORA-2021-c7de344a42 has been pushed to the Fedora 33 testing repository. Soon you'll be able to install the update with the following command: `sudo dnf upgrade --enablerepo=updates-testing --advisory=FEDORA-2021-c7de344a42` You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2021-c7de344a42 See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.
FEDORA-2021-e3e53e3809 has been pushed to the Fedora 34 stable repository. If problem still persists, please make note of it in this bug report.
FEDORA-2021-c7de344a42 has been pushed to the Fedora 33 stable repository. If problem still persists, please make note of it in this bug report.
FEDORA-2021-c05a50fdb2 has been pushed to the Fedora 35 stable repository. If problem still persists, please make note of it in this bug report.