On Mon, Mar 18, 2013 at 8:09 PM, Alykhan Jetha <[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])>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] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

