Segmentation fault running a query

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Segmentation fault running a query

Peter Hardman
If i run the following query from Python 3.7 using the sqlite3 DBAPI
adapter or from sqlitebrowser I get a segmentation fault.

The query runs error free on PostgreSQL 9.6

The query fails if the 'in' list has more than two entries.

Any ideas? I could create a test database but it will take a while as it
has personal information in which I would have to obfuscate to avoid
falling foul of the GDPR.

Query:

select  m.member_no, p.title, p.initials, p.forename, p.surname,
m.address_1, m.address_2, m.address_3, m.post_town, m.county,
m.post_code, m.country, s.class_name, m.joined, s.renewed,
s.expires, s.pmt_method, m.non_renewal, m.share_info,
m.last_changed, p.person_id, r.region
from person p join mem_pers mp on p.person_id = mp.person_id
join member m on mp.member_no = m.member_no
join current_member_status s on m.member_no = s.member_no
left join in_region r on m.county = r.county
  join mem_dates d on s.expires > d.renewal_date where m.non_renewal = ''
and p.person_id in
(200,270,271,355,427,484,512,598,685,724,847,922,973,1095,1189,1371,1421,1483,1516,1523,1592,1799,1866,2024,2076,2077)

  order by m.country, m.county, p.surname, p.initials

Core dump (the interesting bit only):

[peter@system04 ppd-memrpt2]$ coredumpctl info 10267
            PID: 10267 (sqlitebrowser)
            UID: 1000 (peter)
            GID: 1000 (peter)
         Signal: 11 (SEGV)
      Timestamp: Tue 2019-03-05 18:55:38 GMT (55min ago)
   Command Line: sqlitebrowser
     Executable: /usr/bin/sqlitebrowser
  Control Group: /user.slice/user-1000.slice/session-1.scope
           Unit: session-1.scope
          Slice: user-1000.slice
        Session: 1
      Owner UID: 1000 (peter)
        Boot ID: f27026461d4944c8a24ca6524def7c0c
     Machine ID: 47f95fceb9d84436be17de2a1639655e
       Hostname: system04
        Storage:
/var/lib/systemd/coredump/core.sqlitebrowser.1000.f27026461d4944c8a24ca6524def7c0c.10267.15518121380000>
        Message: Process 10267 (sqlitebrowser) of user 1000 dumped core.

                 Stack trace of thread 10267:
                 #0  0x00007ffaf1357223 sqlite3VdbeFindCompare
(libsqlite3.so.0)
                 #1  0x00007ffaf12ba157 sqlite3BtreeMovetoUnpacked
(libsqlite3.so.0)
                 #2  0x00007ffaf134db86 sqlite3VdbeExec (libsqlite3.so.0)
                 #3  0x00007ffaf1352920 sqlite3_step (libsqlite3.so.0)
                 #4  0x0000556bb8b1b09e _ZN10MainWindow12executeQueryEv
(sqlitebrowser)
                 #5  0x0000556bb8c1da2f n/a (sqlitebrowser)
                 #6  0x00007ffaf0a4187c
_ZN11QMetaObject8activateEP7QObjectiiPPv (libQt5Core.so.5)
                 #7  0x00007ffaf16f5633 _ZN7QAction9triggeredEb
(libQt5Widgets.so.5)
                 #8  0x00007ffaf16f7d1a
_ZN7QAction8activateENS_11ActionEventE (libQt5Widgets.so.5)
                 #9  0x00007ffaf17ea45e n/a (libQt5Widgets.so.5)
                 #10 0x00007ffaf17ea696
_ZN15QAbstractButton17mouseReleaseEventEP11QMouseEvent (libQt5Widgets.so.5)
                 #11 0x00007ffaf18da04b
_ZN11QToolButton17mouseReleaseEventEP11QMouseEvent (libQt5Widgets.so.5)
                 #12 0x00007ffaf173cb68 _ZN7QWidget5eventEP6QEvent
(libQt5Widgets.so.5)
                 #13 0x00007ffaf18da0f4 _ZN11QToolButton5eventEP6QEvent
(libQt5Widgets.so.5)
                 #14 0x00007ffaf16fbe24
_ZN19QApplicationPrivate13notify_helperEP7QObjectP6QEvent
(libQt5Widgets.so.5)
                 #15 0x00007ffaf1703929
_ZN12QApplication6notifyEP7QObjectP6QEvent (libQt5Widgets.so.5)
                 #16 0x00007ffaf0a16e99
_ZN16QCoreApplication15notifyInternal2EP7QObjectP6QEvent (libQt5Core.so.5)
                 #17 0x00007ffaf1702c08
_ZN19QApplicationPrivate14sendMouseEventEP7QWidgetP11QMouseEventS1_S1_PS1_R8QPoi>
lines


--
Peter Hardman
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Segmentation fault running a query

Simon Slavin-3
On 5 Mar 2019, at 8:06pm, Peter Hardman <[hidden email]> wrote:

> If i run the following query from Python 3.7 using the sqlite3 DBAPI adapter or from sqlitebrowser I get a segmentation fault.

Please find the SQLite command-line tool on your computer.  If you don't already have one you can download one for your platform in the section "Precompiled Binaries" on

<https://sqlite.org/download.html>

Using that program, please run

PRAGMA integrity_check;

If that reports no problems (should return no results) then please run your SELECT query in that program just to verify that it gets the same result your own code does.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Segmentation fault running a query

David Raymond
And if it does still crash, please provide the database schema to help with debugging.


-----Original Message-----
From: sqlite-users [mailto:[hidden email]] On Behalf Of Simon Slavin
Sent: Tuesday, March 05, 2019 3:14 PM
To: SQLite mailing list
Subject: Re: [sqlite] Segmentation fault running a query

On 5 Mar 2019, at 8:06pm, Peter Hardman <[hidden email]> wrote:

> If i run the following query from Python 3.7 using the sqlite3 DBAPI adapter or from sqlitebrowser I get a segmentation fault.

Please find the SQLite command-line tool on your computer.  If you don't already have one you can download one for your platform in the section "Precompiled Binaries" on

<https://sqlite.org/download.html>

Using that program, please run

PRAGMA integrity_check;

If that reports no problems (should return no results) then please run your SELECT query in that program just to verify that it gets the same result your own code does.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Segmentation fault running a query

Richard Hipp-3
In reply to this post by Peter Hardman
This is another example of the problem described by ticket
https://www.sqlite.org/src/info/df46dfb631f75694 which is fixed in
version 3.27.2.

On 3/5/19, Peter Hardman <[hidden email]> wrote:
> If i run the following query from Python 3.7 using the sqlite3 DBAPI
> adapter or from sqlitebrowser I get a segmentation fault.
>
> The query runs error free on PostgreSQL 9.6
>
> The query fails if the 'in' list has more than two entries.
>
> Any ideas?

--
D. Richard Hipp
[hidden email]
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users