--- On Tue, 9/14/10, Simon Slavin <slav...@bigfraud.org> wrote: > From: Simon Slavin <slav...@bigfraud.org> > Subject: Re: [sqlite] SQL Logic error for in-memory database > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Date: Tuesday, September 14, 2010, 9:51 PM > > On 15 Sep 2010, at 3:41am, Hemant Shah wrote: > > > I have written a C program that creates in-memory > database. It reads packets from the network and insert some > info in the database. > > > > Sometimes I get following error: > > > > SQL logic error or missing database. > > Does the error occur only when starting your program, or > sometimes during a long run which had gone okay up to that > point ?
It occurs after it is running for a while. If I ignore the error and continue, the inserts are successful for few more hours then I again get error. > > Is the database accessed from more than one thread or > process ? > No it is only accessed by one process (no threads). > Are you intentionally using NULL values anywhere ? > No. all columns are defined with NOT NULL. > Simon. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > Hemant Shah E-mail: hj...@yahoo.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users