Subject | Deadlock error while inserting..... |
---|---|
Author | bkshahu |
Post date | 2006-05-13T01:44:56Z |
Hi,
I got following error on a DML operation (I think it was INSERT
operation but I am not sure it might be UPDATE, SELECT or even a DB
procedcure call - I did not notice at that time).
"Lock conflict on no wait transaction deadlock."
At the time when I got this error, I was the only person who was
connected to the firebird DB.
I think the error should come when there are at lease 2 users connected.
Does anybody has any information about how this can be resolved.
I dont know whether this has to do anything with "less RAM", When I
increased the RAM (from 500 Mb to 1 Gb) I could not replicate this.
Regards,
Bhavesh.
I got following error on a DML operation (I think it was INSERT
operation but I am not sure it might be UPDATE, SELECT or even a DB
procedcure call - I did not notice at that time).
"Lock conflict on no wait transaction deadlock."
At the time when I got this error, I was the only person who was
connected to the firebird DB.
I think the error should come when there are at lease 2 users connected.
Does anybody has any information about how this can be resolved.
I dont know whether this has to do anything with "less RAM", When I
increased the RAM (from 500 Mb to 1 Gb) I could not replicate this.
Regards,
Bhavesh.