Re: [sqlite] Some queries with ORDER BY and LIMIT lock DB

2018-09-07 Thread Richard Hipp
On 9/7/18, Firecore wrote: > > It looks like the latest public version of sqlite v3.24.0 has an issue with > processing queries with ORDER BY and LIMIT against some datasets. Thanks for the bug report. The trouble ticket can be found at

Re: [sqlite] Some queries with ORDER BY and LIMIT lock DB

2018-09-07 Thread Tim Streater
On 07 Sep 2018, at 20:20, Richard Hipp wrote: > On 9/7/18, Firecore wrote: >> >> It's easily reproduced with the sqlite3 client and db file available here >> (https://www.dropbox.com/s/l1xofadq7vi5vjj/lock_issue.db?dl=0): > > I cannot reproduce it. It always runs instantly for me. I also ran

Re: [sqlite] Some queries with ORDER BY and LIMIT lock DB

2018-09-07 Thread Richard Hipp
On 9/7/18, Stephen Chrzanowski wrote: > I can reproduce this issue with the SQLite3.exe under Win7. It depends on compile-time options. I have a repro case now. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Some queries with ORDER BY and LIMIT lock DB

2018-09-07 Thread Stephen Chrzanowski
I can reproduce this issue with the SQLite3.exe under Win7. The first sqlite3 was pulled from a sqlite3.exe I have somewhere in my path, I then extracted the 3.24.0 version to the Ramdrive and executed from there. On the first run, r:\sqlite3.exe did not exist. R:\>sqlite3 lock_issue.db SQLite

Re: [sqlite] Some queries with ORDER BY and LIMIT lock DB

2018-09-07 Thread Richard Hipp
On 9/7/18, Firecore wrote: > > It's easily reproduced with the sqlite3 client and db file available here > (https://www.dropbox.com/s/l1xofadq7vi5vjj/lock_issue.db?dl=0): I cannot reproduce it. It always runs instantly for me. I also ran it under valgrind with no issues reported. -- D.

Re: [sqlite] Some queries with ORDER BY and LIMIT lock DB

2018-09-07 Thread David Raymond
al Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Firecore Sent: Friday, September 07, 2018 1:32 PM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] Some queries with ORDER BY and LIMIT lock DB Hi all - It looks like the latest publ

[sqlite] Some queries with ORDER BY and LIMIT lock DB

2018-09-07 Thread Firecore
Hi all - It looks like the latest public version of sqlite v3.24.0 has an issue with processing queries with ORDER BY and LIMIT against some datasets. In essence, sqlite3_step returns SQLITE_LOCKED for some of these statments even if there are no other active connections. We were able to