What else do you need to know? BTW... is there any way how to detect which constraint has failed?
Jan Pavel Ivanov wrote: >> 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
