Two independent processes. Process A is a desktop app. Process B is a background sync tool (a headless app).
-- AJ On Monday, 18 March, 2013 at 8:28 PM, Richard Hipp wrote: > On Mon, Mar 18, 2013 at 8:09 PM, Alykhan Jetha <[email protected] > (mailto:[email protected])>wrote: > > > Hi Richard, > > > > I can certainly send you a build of the app > > > To be clear, are you talking about two threads within the same process, or > two independent processes? > > > > and the steps to reproduce the problem (not too complicated). > > I'm not sure how I would make some sample code that exhibits the problem... > > > > Let me know. > > > > Thanks!!!-- > > AJ > > > > > > On Monday, 18 March, 2013 at 8:00 PM, Richard Hipp wrote: > > > > > On Mon, Mar 18, 2013 at 7:47 PM, Alykhan Jetha <[email protected] > > > (mailto:[email protected])(mailto: > > [email protected] (mailto:[email protected]))>wrote: > > > > > > > Hi Gang, > > > > > > > > I have a weird issue that has me believing I've missed something… > > > > > > > > I have 2 processes (process A and process B) opening a connection to > > the a > > > > database. After process B is done its work, we call > > > > > > > checkpoint(restart), > > > > process A seems to lose its file handles (unknown IO error). > > > > > > > > If we don't use a checkpoint or use checkpoint(passive), the database > > > > eventually gets corrupt (malformed image) when using process A. > > > > > > > > We are using version 3.7.15.2 built into both apps. > > > > The problem is exhibited on Mac OS X 10.6 and 10.7 (haven't tried this > > > > case on 10.8). > > > > > > > > The database is opened in both processes in WAL mode and with Normal > > sync. > > > > Everything else is stock. > > > > > > > > I have the feeling I'm missing something or have it misconfigured. > > > > > > No - it should just work. You shouldn't have to configure anything to get > > > it to work. > > > > > > Can you give us additional detail on how to demonstrate the problem, so > > > that we can try to reproduce it? Perhaps some sample code? > > > > > > > > > -- > > > D. Richard Hipp > > > [email protected] (mailto:[email protected]) > > > _______________________________________________ > > > sqlite-users mailing list > > > [email protected] (mailto:[email protected]) > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > > > > > _______________________________________________ > > sqlite-users mailing list > > [email protected] (mailto:[email protected]) > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > -- > D. Richard Hipp > [email protected] (mailto:[email protected]) > _______________________________________________ > sqlite-users mailing list > [email protected] (mailto:[email protected]) > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
