Submitted by: mjanus (mjanus)

Attachments:
FB_commit_test.zip

SFID: 1155183#⁠
Submitted By: mjanus

Hi,

I've found some incorrect behavior of Firebird
SuperServer 1.5.1 (tested on WinXP SP2 or MS
SBS2003 or Win2K).

If I make shutdown of FB server during one active
transaction I would expect that all active transactions
will be rolled back. However, I've found that some part of
changes in such a transaction are curiously committed.

For example: If I make a loop of inserting new records
into some table and during this transaction I make the
shutdown, the client app is terminated by connection
lost as is expected but the server will committed a lot of
inserted records - sometimes the server commits last 5
pcs of hunderds of inserted records, at another time the
server saved all records except last 7pcs etc.

PS: I know that I must check if there is no active
transaction prior to making shutdown but I think this is
an unpleasant and serious bug.

Martin Janus