solve
> this, the firebird team would gladly implement this.
>
> a
>
>
>> Date: Sun, 20 Sep 2015 14:12:25 +0300
>> From: [email protected]
>> To: [email protected]
>
>> Subject: Re: [Firebird-net-provider] Multithread insert
, 20 Sep 2015 14:12:25 +0300
> From: [email protected]
> To: [email protected]
> Subject: Re: [Firebird-net-provider] Multithread insert
>
> I don't think that the issue in the .NET provider. It just forwards
> options to fbembed.dll for trans
engine.
On 20 September 2015 at 14:03, LtColRDSChauhan wrote:
>> Message: 3
>> Date: Thu, 17 Sep 2015 19:56:20 +0200
>> From: Ji?? ?in?ura
>> Subject: Re: [Firebird-net-provider] Multithread insert
>> To: "For users and developers of the
>
> Message: 3
> Date: Thu, 17 Sep 2015 19:56:20 +0200
> From: Ji?? ?in?ura
> Subject: Re: [Firebird-net-provider] Multithread insert
> To: "For users and developers of the Firebird .NET providers"
>
> Message-ID:
>
On Thu, Sep 17, 2015, at 17:57, Геннадий Забула wrote:
> Narrowed the problem. The cause is a multithreaded update of the same
> record field. Transactions, as I said don't dispatch the issue.
The advice is simple. Don't update same record (not only in .NET;
anywhere, anytool). :D
--
Mgr. Jiří Č
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, Геннадий Забула wrote:
> lock conflict on no wait transaction
> Acquire lock for relation () failed
> ---> FirebirdSql.Data.Common.I
lock conflict on no wait transaction
Acquire lock for relation () failed
---> FirebirdSql.Data.Common.IscException: lock conflict on no wait
transaction
Acquire lock for relation () failed
On 17 September 2015 at 17:38, Геннадий Забула wrote:
> I was wrong about IsolationLevel. If use Isolationle
I was wrong about IsolationLevel. If use Isolationlevel.Serializable
exception message changes to:
On 17 September 2015 at 17:32, Геннадий Забула wrote:
> I'm trying to insert to database multiple items at once via following code:
>
> using (var transaction =
> act.Database.BeginTransaction(Syste
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
