db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Ondruška <peter.ondru...@kaibo.eu>
Subject SYSCS_DIAG.TRANSACTION_TABLE stale records
Date Tue, 11 Jul 2017 17:10:17 GMT
Dear all,

the documentation mentions "The SYSCS_DIAG.TRANSACTION_TABLE diagnostic
table shows *all of the transactions that are currently *in the database."
Is it really correct? In my case I have an application server (Payara)
connected to database with ClientXADataSource. Over time the record count
in this table grows. When I stop application server and all database
sessions are disconnected, record count stays with no change and I would
expect that it drops as transactions are definitely closed. The only way to
"clean" the diagnostic table is to restart database.

All the records are same (different XID of course):

XID    GLOBAL_XID    USERNAME    TYPE    STATUS    FIRST_INSTANT    SQL_TEXT
79512765    NULL    APP    UserTransaction    IDLE    NULL    NULL

except one SystemTransaction:
XID    GLOBAL_XID    USERNAME    TYPE    STATUS    FIRST_INSTANT    SQL_TEXT
79241843    NULL    NULL    SystemTransaction    IDLE    NULL    NULL

and one UserTransaction (as expected):
XID    GLOBAL_XID    USERNAME    TYPE    STATUS    FIRST_INSTANT    SQL_TEXT
79604720    NULL    APP    UserTransaction    IDLE    NULL    SELECT * FROM
syscs_diag.transaction_table

Regards,

-- 
Peter Ondruška

-- 
kaibo, s.r.o., ID 28435036, registered with the commercial register 
administered by the Municipal Court in Prague, section C, insert 141269.
Registered office and postal address: kaibo, s.r.o., Kališnická 379/10, 
Prague 3, 130 00, Czech Republic.
https://www.kaibo.eu

Mime
View raw message