We had this problem, but we are on firebird 1.5..
So im not sure it'll totally apply.

The only way we could get the numbers to tally up was to do a backup then restore to new file

We also found using the newest odbc driver cured the issue with OAT's not advancing.

Ours was slightly more severe at a difference of about 1 million :s



-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Hannes Streicher
Sent: 03 November 2008 14:03
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Stuck Transaction(s)

Hello all ,

i have some stuck Transactions since Thrusday, the oldest Active
Transaction is not advancing

Saturday and Sunday all Machines were turned off , only the server
was running , shouldnt dead connections be detected after 2 Hours ?

using the Monitoring Tables i can see some old processes from
thursday in mon$attachments, mon$transaction and mon$statements
all of them show mon_state =0 so inactive but one of them has the
OAT

trying to kill the statements with
delete from mon$statemente where mon$statement_id= number
seems to work , but commiting and redsiplaying the table
the statements are back

killing transactions or attachments is refused by the server
with 'operation not supported'

i tried it with ibexpert and an small delphi programm ,
same result


System
Windows 2003 Server
Firebird 2.1.1
ODS 11.1
Page Size 8192
Version WI-V6.3.1.17910 Firebird 2.1
Forced Writes 1

Programms are Delphi using the IBX Components


Oldest: 36646 Oldest Active :36647 Next :91652

connections from various clients XP Home or XP Pro

The Database was restored Wednesday

2 Questions

1)How can that happen or better how to avoid it

2)i am off site and i only have a VPN connection to the Database
and the persons there are no computer experts , thf i want to avoid restarting the
server if possible



--
Mit freundlichen Grüssen
Hannes Streicher mailto:HStreicher@...


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links




Head and Registered Office:
Call Assist Ltd,
Axis Court, North Station Road,
Colchester, Essex.
CO1 1UX
Telephone +44 (0)1206 771771
Fax +44 (0)1206 364268

Registered in England and Wales.
Registered Company Number 3668383
Authorised and regulated by the Financial Services Authority

Please Note : This electronic message contains information from Call Assist Ltd which may be privileged or confidential.
The information is intended for the use of the individual(s) named above. If you are not the intended recipient be aware
that any disclosure, copying, distribution or use of the contents of this information is prohibited.
If you are not the intended recipient please delete this email. If you have received this electronic
message in error, please notify us by telephone or email immediately.

Please consider the environment before printing this email.