[sqlite] detach failed with error code 1

2014-04-17 Thread dd
Hi All, 1. prepare, step, then finalize: Attach DATABASE '/full/path' as 'my_in_memory_db'; 2. prepare, step, then finalize: Delete from my_in_memory_db.table_1 where primary_key = 'value'; 3. prepare, step, then finalize: DETACH my_in_memory_db; Executed above three queries in loop for 1

Re: [sqlite] detach failed with error code 1

2014-04-17 Thread Richard Hipp
Please turn on error logging (http://www.sqlite.org/errlog.html) and report back what error messages you are seeing. On Thu, Apr 17, 2014 at 6:47 AM, dd wrote: > Hi All, > > 1. prepare, step, then finalize: Attach DATABASE '/full/path' as > 'my_in_memory_db'; > 2. prepare, step, then finali

Re: [sqlite] detach failed with error code 1

2014-04-17 Thread dd
Dear Richard, This is great api. output: (1) statement aborts at 5: [DETACH my_in_memory_db;] database my_in_memory_db is locked (1) statement aborts at 5: [ATTACH DATABASE '/full/path/info.db' AS my_in_memory_db;] database my_in_memory_db is already in use (1) statement aborts at 5: [

Re: [sqlite] detach failed with error code 1

2014-04-17 Thread Richard Hipp
On Thu, Apr 17, 2014 at 9:08 AM, dd wrote: > Dear Richard, > > This is great api. > > output: > > (1) statement aborts at 5: [DETACH my_in_memory_db;] database > my_in_memory_db is locked > The DETACH failed because you have unfinalized statements using the attached database and you cannot

Re: [sqlite] detach failed with error code 1

2014-04-20 Thread dd
Given different database name for in-memory database for every iteration(looped for 1000 times). Still, it's throwing Database Locked at least once on Windows, not on Mac/Linux. Is there any way to track this issue? I am using 3.7.11. Any ideas? On Thu, Apr 17, 2014 at 5:11 PM, Richard Hipp wrot

Re: [sqlite] detach failed with error code 1

2014-04-20 Thread Simon Slavin
On 20 Apr 2014, at 12:58pm, dd wrote: > Given different database name for in-memory database for every > iteration(looped for 1000 times). Still, it's throwing Database Locked at > least once on Windows, not on Mac/Linux. Is there any way to track this > issue? I am using 3.7.11. Any ideas? Tec

Re: [sqlite] detach failed with error code 1

2014-04-30 Thread dd
I have set busy time out for 5 seconds and given different names for every attach and detaching database. still, this error is not getting fixed. prepare, step and finalize are not throwing any errors. What is the alternative solution for attach and detaching database? Thanks in advance. On Sun,