Jan Bilek wrote:
> ... is there any way how to detect which constraint has failed?
http://www.sqlite.org/src/tktview?name=23b2128201
Roger
___
sqlite-users mailing list
sqlite-users@sqlite.org
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
> 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
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
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,
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
> 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"
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
8 matches
Mail list logo