> On Feb 24, 2015, at 3:29 AM, Svein Erling Tysvær svein.erling.tysvaer@... [firebird-support] <firebird-support@yahoogroups.com> 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,

Ann