OK. I've anonymised the database and cut it down so that only the records
extracted by the query are present. I have this feeling I've done something
stupid with the data - but all the other queries I run against this database
work fine.
It still gives a segfault when I run the query.
The SQLite3 version is SQLite 3.27.1 2019-02-08 13:17:39, built with zlib
version 1.2.11 and gcc-8.2.1 20181127.
I've attached the database file (300K).
Dan Kennedy wrote on 06/03/2019 12:07:
On 6/3/62 16:37, Peter Hardman wrote:
So, I forgot I had emails from the list turned off....
Integrity check shows no results.
The query fails from the CLI
The schema (of a very much cut down database) is attached.
Can you post the results of running the ".fullschema" command in the shell tool?
Thanks,
Dan.
And if it does still crash, please provide the database schema to help with
debugging.
-----Original Message-----
From: sqlite-users [mailto:sqlite-users-bounces at mailinglists.sqlite.org] 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 <peter at somborneshetlands.co.uk>
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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
Peter Hardman
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
