Bug 1919573

Summary: [abrt] sqlitebrowser: qt_message_fatal(): sqlitebrowser killed by SIGABRT
Product: [Fedora] Fedora Reporter: Tom Sundberg <tomcom980>
Component: sqlitebrowserAssignee: Sandro Mani <manisandro>
Status: CLOSED ERRATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 33CC: i, manisandro
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Unspecified   
URL: https://retrace.fedoraproject.org/faf/reports/bthash/44a55cfd3d255dfdad85f70eb8c3ad0a512b35af
Whiteboard: abrt_hash:7b33b5bb8810b3ba1e5c32828a66aef72609cac9;VARIANT_ID=workstation;
Fixed In Version: sqlitebrowser-3.13.0-0.1.gita302128.fc34 sqlitebrowser-3.13.0-0.1.gita302128.fc33 sqlitebrowser-3.13.0-0.1.gita302128.fc35 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2021-09-10 16:04:14 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
File: backtrace
none
File: core_backtrace
none
File: cpuinfo
none
File: dso_list
none
File: environ
none
File: limits
none
File: maps
none
File: mountinfo
none
File: open_fds
none
File: proc_pid_status
none
File: var_log_messages
none
Test database none

Description Tom Sundberg 2021-01-23 18:36:55 UTC 
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
Comment 1 Tom Sundberg 2021-01-23 18:36:58 UTC 
Created attachment 1750108 [details]
File: backtrace
Comment 2 Tom Sundberg 2021-01-23 18:37:00 UTC 
Created attachment 1750109 [details]
File: core_backtrace
Comment 3 Tom Sundberg 2021-01-23 18:37:01 UTC 
Created attachment 1750110 [details]
File: cpuinfo
Comment 4 Tom Sundberg 2021-01-23 18:37:04 UTC 
Created attachment 1750111 [details]
File: dso_list
Comment 5 Tom Sundberg 2021-01-23 18:37:05 UTC 
Created attachment 1750112 [details]
File: environ
Comment 6 Tom Sundberg 2021-01-23 18:37:06 UTC 
Created attachment 1750113 [details]
File: limits
Comment 7 Tom Sundberg 2021-01-23 18:37:08 UTC 
Created attachment 1750114 [details]
File: maps
Comment 8 Tom Sundberg 2021-01-23 18:37:09 UTC 
Created attachment 1750115 [details]
File: mountinfo
Comment 9 Tom Sundberg 2021-01-23 18:37:11 UTC 
Created attachment 1750116 [details]
File: open_fds
Comment 10 Tom Sundberg 2021-01-23 18:37:12 UTC 
Created attachment 1750117 [details]
File: proc_pid_status
Comment 11 Tom Sundberg 2021-01-23 18:37:13 UTC 
Created attachment 1750118 [details]
File: var_log_messages
Comment 12 Tom Sundberg 2021-01-27 20:17:25 UTC 
*** Bug 1921276 has been marked as a duplicate of this bug. ***
Comment 13 Sandro Mani 2021-01-29 11:21:23 UTC 
Looks like an assertion failure in the query parser. Do you recall the query you submitted resp. is it reproducible?
Comment 14 Tom Sundberg 2021-01-29 12:46:14 UTC 
Created attachment 1752031 [details]
Test database
Comment 15 Tom Sundberg 2021-01-29 12:51:13 UTC 
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!
Comment 16 Sandro Mani 2021-03-06 16:54:15 UTC 
Taken upstream: https://github.com/sqlitebrowser/sqlitebrowser/issues/2611
Comment 17 Fedora Update System 2021-09-01 20:59:08 UTC 
FEDORA-2021-c7de344a42 has been submitted as an update to Fedora 33. https://bodhi.fedoraproject.org/updates/FEDORA-2021-c7de344a42
Comment 18 Fedora Update System 2021-09-01 20:59:08 UTC 
FEDORA-2021-c05a50fdb2 has been submitted as an update to Fedora 35. https://bodhi.fedoraproject.org/updates/FEDORA-2021-c05a50fdb2
Comment 19 Fedora Update System 2021-09-01 20:59:09 UTC 
FEDORA-2021-e3e53e3809 has been submitted as an update to Fedora 34. https://bodhi.fedoraproject.org/updates/FEDORA-2021-e3e53e3809
Comment 20 Fedora Update System 2021-09-02 15:55:57 UTC 
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.
Comment 21 Fedora Update System 2021-09-03 00:05:13 UTC 
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.
Comment 22 Fedora Update System 2021-09-03 00:30:56 UTC 
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.
Comment 23 Fedora Update System 2021-09-10 16:04:14 UTC 
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.
Comment 24 Fedora Update System 2021-09-10 16:35:59 UTC 
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.
Comment 25 Fedora Update System 2021-09-24 20:13:59 UTC 
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.