Re: [sqlite] 'Database table is locked' error with libgpkg and SQLite >= 3.24.0

2018-11-21 Thread Benjamin Stadin
Thank you. The ruby helper class used by this library has indeed nested query executions. Modifying this class accordingly fixes the issue. Thanks Ben Am 21.11.18, 21:39 schrieb "drhsql...@gmail.com im Auftrag von Richard Hipp" : On 11/21/18, Benjamin Stadin wrote: > Hi, >

Re: [sqlite] 'Database table is locked' error with libgpkg and SQLite >= 3.24.0

2018-11-21 Thread Richard Hipp
On 11/21/18, Benjamin Stadin wrote: > Hi, > > I've forked libgpkg on Github to merge fixes from other repositories and > update the embedded SQLite (was at 3.8.). Though in the RTREE tests I get a > 'database table is locked' error for the update statements (see exact error > message below).

Re: [sqlite] 'Database table is locked' error with libgpkg and SQLite >= 3.24.0

2018-11-21 Thread Dan Kennedy
On 11/21/2018 11:01 PM, Benjamin Stadin wrote: Hi, I've forked libgpkg on Github to merge fixes from other repositories and update the embedded SQLite (was at 3.8.). Though in the RTREE tests I get a 'database table is locked' error for the update statements (see exact error message below).

[sqlite] 'Database table is locked' error with libgpkg and SQLite >= 3.24.0

2018-11-21 Thread Benjamin Stadin
Hi, I've forked libgpkg on Github to merge fixes from other repositories and update the embedded SQLite (was at 3.8.). Though in the RTREE tests I get a 'database table is locked' error for the update statements (see exact error message below). I ran the tests manually in the gpkg shell and

[sqlite] Odp.: Creating and dropping tables with multiple connections

2018-11-21 Thread Albert Banaszkiewicz
First of all, sorry, for posting the code that did not compile. My intention was to simply show whats going on rather than provide copy-paste-able example. @RichardHipp Thank you for your suggestion. It works as You described. @All Thanks for Your input Regards, Albert