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 version 3.8.10.1 2015-05-09 12:14:55 Enter ".help" for usage hints. sqlite> SELECT meta_tvshow.ItemID, meta_tvshow.Path, meta_tvshow.DateCached, meta_tvshow.VFS_ID, FileIndex.ModificationDate from meta_tvshow ...> LEFT JOIN FileIndex ON meta_tvshow.ItemID = FileIndex.ItemID ...> WHERE meta_tvshow.MetaID='80349' ...> ORDER BY FileIndex.Enabled DESC ...> LIMIT 1; B2A4025D165B97BF07B4489B30E4EC6F|/local/californication.S1.E4.mp4|1536215989.63828|778FF248-0A9E-44BE-BDAE-1B413A0C55A0|401460374.0 R:\>sqlite3.exe SQLite version 3.24.0 2018-06-04 19:24:41 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> R:\>sqlite3.exe lock_issue.db SQLite version 3.24.0 2018-06-04 19:24:41 Enter ".help" for usage hints. sqlite> SELECT meta_tvshow.ItemID, meta_tvshow.Path, meta_tvshow.DateCached, meta_tvshow.VFS_ID, FileIndex.ModificationDate from meta_tvshow ...> LEFT JOIN FileIndex ON meta_tvshow.ItemID = FileIndex.ItemID ...> WHERE meta_tvshow.MetaID='80349' ...> ORDER BY FileIndex.Enabled DESC ...> LIMIT 1; Error: interrupted <- Pressed CTRL-C after about 5 seconds. sqlite> On Fri, Sep 7, 2018 at 3:20 PM, Richard Hipp <d...@sqlite.org> wrote: > On 9/7/18, Firecore <d...@firecore.com> 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. Richard Hipp > d...@sqlite.org > _______________________________________________ > 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
