> But why it only happens when any concurrent select query is in progress?
Probably you don't tell us all necessary information about your set up (or maybe you don't know it yourself) because concurrent select cannot cause this kind of error in any way. It can cause only SQLITE_BUSY error. Are you sure you don't mess with your data from some other process? Pavel On Fri, Jan 22, 2010 at 2:28 PM, Jan Bilek <bil...@gmail.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
