Bug 1919573 - [abrt] sqlitebrowser: qt_message_fatal(): sqlitebrowser killed by SIGABRT
Summary: [abrt] sqlitebrowser: qt_message_fatal(): sqlitebrowser killed by SIGABRT
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Fedora
Classification: Fedora
Component: sqlitebrowser
Version: 33
Hardware: x86_64
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Sandro Mani
QA Contact: Fedora Extras Quality Assurance
URL: https://retrace.fedoraproject.org/faf...
Whiteboard: abrt_hash:7b33b5bb8810b3ba1e5c32828a6...
: 1921276 (view as bug list)
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2021-01-23 18:36 UTC by Tom Sundberg
Modified: 2021-09-24 20:13 UTC (History)
2 users (show)

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
Clone Of:
Environment:
Last Closed: 2021-09-10 16:04:14 UTC
Type: ---
Embargoed:


Attachments (Terms of Use)
File: backtrace (76.63 KB, text/plain)
2021-01-23 18:36 UTC, Tom Sundberg
no flags Details
File: core_backtrace (32.34 KB, text/plain)
2021-01-23 18:37 UTC, Tom Sundberg
no flags Details
File: cpuinfo (2.53 KB, text/plain)
2021-01-23 18:37 UTC, Tom Sundberg
no flags Details
File: dso_list (10.22 KB, text/plain)
2021-01-23 18:37 UTC, Tom Sundberg
no flags Details
File: environ (1.54 KB, text/plain)
2021-01-23 18:37 UTC, Tom Sundberg
no flags Details
File: limits (1.29 KB, text/plain)
2021-01-23 18:37 UTC, Tom Sundberg
no flags Details
File: maps (63.98 KB, text/plain)
2021-01-23 18:37 UTC, Tom Sundberg
no flags Details
File: mountinfo (4.11 KB, text/plain)
2021-01-23 18:37 UTC, Tom Sundberg
no flags Details
File: open_fds (2.96 KB, text/plain)
2021-01-23 18:37 UTC, Tom Sundberg
no flags Details
File: proc_pid_status (1.36 KB, text/plain)
2021-01-23 18:37 UTC, Tom Sundberg
no flags Details
File: var_log_messages (137 bytes, text/plain)
2021-01-23 18:37 UTC, Tom Sundberg
no flags Details
Test database (89.00 KB, application/x-sqlite3)
2021-01-29 12:46 UTC, Tom Sundberg
no flags Details

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.


Note You need to log in before you can comment on or make changes to this bug.