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
