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