Narrowed the problem. The cause is a multithreaded update of the same
record field. Transactions, as I said don't dispatch the issue.
On 17 September 2015 at 17:38, Геннадий Забула <zabulu...@gmail.com> wrote:
> lock conflict on no wait transaction
> Acquire lock for relation (<Table with simultenous updates>) failed
> ---> FirebirdSql.Data.Common.IscException: lock conflict on no wait
> transaction
> Acquire lock for relation (<Table with simultenous updates>) failed
>
> On 17 September 2015 at 17:38, Геннадий Забула <zabulu...@gmail.com> wrote:
>> I was wrong about IsolationLevel. If use Isolationlevel.Serializable
>> exception message changes to:
>>
>> On 17 September 2015 at 17:32, Геннадий Забула <zabulu...@gmail.com> wrote:
>>> I'm trying to insert to database multiple items at once via following code:
>>>
>>> using (var transaction =
>>> act.Database.BeginTransaction(System.Data.IsolationLevel.RepeatableRead))
>>> {
>>> // inserting and updating several related entities.
>>> act.SaveChanges() // Throws exception
>>> }
>>>
>>> Exception message:
>>> lock conflict on no wait transaction
>>> deadlock
>>> update conflicts with concurrent update
>>> concurrent transaction number is 665378
>>>
>>> A problematic query that throws is about updating the entity, that all
>>> my queries update.
>>>
>>> Using any other IsolationLevel doesn't affect the behavior.
------------------------------------------------------------------------------
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
