OK. Let's assume that my db design is buggy (messed up foreign keys or something). Could you then explain why i receive "constraint failed" error ONLY when any select query is in progress? No select in progress = no error.
Thanks for reply. Jan cmar...@unc.edu wrote: > On Fri, 22 Jan 2010, Jan Bilek wrote: > > >> processing >> of write transaction fails with strange "constraint failed" error (no. 19). >> I've tried to search the web for any solution, but i haven't found >> anything. >> > > While a web search can be useful, it is often more useful to go straight > to the relevant source first. In this case, go to http://www.sqlite.org > and enter "constraint failed" in the search box in the upper right corner. > Read the first entry which discusses this error. > > To search the entire world, I Googled 'sqlite constraint failed' and got > 282,000 results: > > http://www.google.com/search?client=opera&rls=en&q=sqlite+constraint+failed&sourceid=opera&ie=utf-8&oe=utf-8 > > The third item in the Google results gives a link to the SQLite docs which > describe this error. > > Chris > > On Fri, 22 Jan 2010, Jan Bilek wrote: > > >> Hello, >> I've got a setup, where one process/thread writes data (multiple inserts >> in one transaction ) to db and other which reads data (one select) from >> db. These two threads use their own db connections. When "write" thread >> and "read" thread access the database at the same time, then processing >> of write transaction fails with strange "constraint failed" error (no. 19). >> I've tried to search the web for any solution, but i haven't found >> anything. Does any sqlite MVP know what could be beyond this strange >> error message. >> >> Thanks for any help. >> >> Sincerely, >> Jan >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
