Subject Re: [firebird-support] Hang On ExecuteNonQuery Using Firebird2.5 with visual studio 2010
Author Ann Harrison
> On Feb 24, 2015, at 3:29 AM, Svein Erling Tysvær svein.erling.tysvaer@... [firebird-support] <> wrote:
> Sukhen wrote:
>>>> update never fails but it fails in insert query. loop run in a single connection with a new datarows in same query.
> I answered:
>>> Could it be that another transaction not visible to your current
>>> transaction has inserted a row that creates a lock conflict with your insert and that your code repeatedly tries (and fails)
>>> to insert?

I missed the fact that it was an insert, not an update that failed. That could be a conflict with a long running transaction which has inserted the same value for a primary key.
>>> Or that it is a real deadlock, where one transaction first successfully updates record A, then fails on record B,
>>> whereas another transaction has successfully updated record B and fails on record A?

That should be reported immediately.
>>> Typically, there would be no problems on INSERT, whereas UPDATE could create problems. Getting the problem on INSERT, I'd say
>>> indicates some kind of lock conflict which means that you have some UNIQUE field or constraint or don't use generators to
>>> populate your primary key.
> Sukhen answered:
>> is it could be any buffersize/memmroy issue. please, suggest if it is how to check it in firebird
>> please, somebody help me out

Buffers and memory shouldn't cause the process to stall for hours.

Best regards,