Re: [sqlite] Windows service with SQLITE

2014-02-17 Thread Teg
Hello tejas, You're using windows so, you should be using "Procmon" to watch file IO. You need to add and look at logging. This is sort of trouble-shooting 101. If you can't get the debugger on it, you'll have to debug with logging. I'd generate a log file and log everything to do with

Re: [sqlite] Windows service with SQLITE

2014-02-17 Thread Richard Hipp
On Sat, Feb 15, 2014 at 7:29 AM, tejas parekh wrote: > Hi All, > > We have a small issue with sqlite database. > > Program structure: > one windows service calls two windows processes process-1 and process-2. > both processes use common database db1.s3db file to store data. >

Re: [sqlite] Windows service with SQLITE

2014-02-17 Thread tejas parekh
Hi Teg, I tried putting delay of 3 seconds and 30 seconds but nothing happens. Still not able to access database and store anything. When i create a file to store data it stores. Strange.. Need more views please. Thanks, Tejas On Sun, Feb 16, 2014 at 12:35 AM, Teg

Re: [sqlite] Windows service with SQLITE

2014-02-15 Thread Simon Slavin
On 15 Feb 2014, at 12:29pm, tejas parekh wrote: > When windows services starts and calls two processes p-1 and p-2 none of > the process is able to store data in the database. > But if i call only one p-1 with service then everything works well > meanwhile if i run p-2

Re: [sqlite] Windows service with SQLITE

2014-02-15 Thread Teg
Hello tejas, I'm thinking it sounds like the processing collides and you don't have retry's built into the process. Basically a race condition. The fact you can run one process and it works, and then later run a second process and it works suggests the problem is in the startup when you

Re: [sqlite] Windows service with SQLITE

2014-02-15 Thread Klaas V
Tejas Parekh wrote: "both processes use common database db1.s3db file to store data." Unfortunately SQLite does not allow more than one process to write a single file the same time. The one writing process should unlock "his" database in order to make it possible to others to make changes to 

[sqlite] Windows service with SQLITE

2014-02-15 Thread tejas parekh
Hi All, We have a small issue with sqlite database. Program structure: one windows service calls two windows processes process-1 and process-2. both processes use common database db1.s3db file to store data. When windows services starts and calls two processes p-1 and p-2 none of the process is