search

FirebirdSQL / firebird

Firebird server, client and tools
https://firebirdsql.org
1.26k stars 217 forks source link

Long running transactions commited with commit retaining randomly dissapear [CORE5293] #5571

Open firebird-automations opened 8 years ago

firebird-automations commented 8 years ago

Submitted by: Ryszard Skotarski (rysios)

Votes: 1

I cannot reproduce it ,but my suspection is, that long running transactions commited with commit retaining randomly dissapear from server . Same problem was reported on http://comments.gmane.org/gmane.comp.db.firebird.user/13932 but i don't know if they are using commit retaining. This error appears while using Delphi with IBX or flamerobin.
On 2.5 and 2.1 there was no problems.
After moving to FB3 on client side we got random " invalid transaction handle (expecting explicit transaction start)."

Tools on the same database like PHP with autocommit works fine.

firebird-automations commented 8 years ago

Commented by: @ibaseru

maybe that there is a bug, but anyway, avoid using commit-retaining. This results to long-running transaction, that prevents versions to be garbage, to be garbage collected, so performance drops, etc.