But why it only happens when any concurrent select query is in progress? Thanks for any response.
Jan Pavel Ivanov wrote: >> Does any sqlite MVP know what could be beyond this strange >> error message. >> > > Exactly what message says: you tried to insert data that is not > allowed by constraints in the table. "Read"/"write" threads construct > doesn't have anything to do with that - everything can be reproduced > in one "write" thread. > > > Pavel > > On Fri, Jan 22, 2010 at 11:45 AM, Jan Bilek <bil...@gmail.com> 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