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