Hello Olaf, 'Checkmail' check_m...@satron.de [firebird-support] schrieb am 13.04.2016 14:38:
> Hello, > > > > I've a problem with our database, firebird 3.0 RC2, some Clients (C++, > Microsoft Access over Firebird ODBC). There are 70000 open transactions. But > in the monitoring Table, I cannot see the one who is the oldest was shown. > Why? How/where do you identify the oldest transaction? -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > > > > INSERT INTO MON$TRANSACTIONS (MON$TRANSACTION_ID, MON$ATTACHMENT_ID, > MON$STATE, MON$TIMESTAMP, MON$TOP_TRANSACTION, MON$OLDEST_TRANSACTION, > MON$OLDEST_ACTIVE, MON$ISOLATION_MODE, MON$LOCK_TIMEOUT, MON$READ_ONLY, > MON$AUTO_COMMIT, MON$AUTO_UNDO, MON$STAT_ID) > > VALUES (2834893, 85000, 1, '2016-04-13 14:34:31', > 2834893, 2774214, 2771000, 2, 0, 0, 0, 1, 201); > > INSERT INTO MON$TRANSACTIONS (MON$TRANSACTION_ID, MON$ATTACHMENT_ID, > MON$STATE, MON$TIMESTAMP, MON$TOP_TRANSACTION, MON$OLDEST_TRANSACTION, > MON$OLDEST_ACTIVE, MON$ISOLATION_MODE, MON$LOCK_TIMEOUT, MON$READ_ONLY, > MON$AUTO_COMMIT, MON$AUTO_UNDO, MON$STAT_ID) > > VALUES (2208191, 68114, 0, '2016-04-07 05:03:44', > 2208191, 2768721, 2771000, 2, -1, 1, 0, 1, 319); > > INSERT INTO MON$TRANSACTIONS (MON$TRANSACTION_ID, MON$ATTACHMENT_ID, > MON$STATE, MON$TIMESTAMP, MON$TOP_TRANSACTION, MON$OLDEST_TRANSACTION, > MON$OLDEST_ACTIVE, MON$ISOLATION_MODE, MON$LOCK_TIMEOUT, MON$READ_ONLY, > MON$AUTO_COMMIT, MON$AUTO_UNDO, MON$STAT_ID) > > VALUES (2833276, 83617, 1, '2016-04-13 07:00:29', > 2771000, 2768721, 2769594, 2, -1, 0, 0, 1, 1267); > > INSERT INTO MON$TRANSACTIONS (MON$TRANSACTION_ID, MON$ATTACHMENT_ID, > MON$STATE, MON$TIMESTAMP, MON$TOP_TRANSACTION, MON$OLDEST_TRANSACTION, > MON$OLDEST_ACTIVE, MON$ISOLATION_MODE, MON$LOCK_TIMEOUT, MON$READ_ONLY, > MON$AUTO_COMMIT, MON$AUTO_UNDO, MON$STAT_ID) > > VALUES (2834878, 84239, 1, '2016-04-13 10:38:25', > 2792941, 2768721, 2771000, 2, -1, 0, 0, 1, 1677); > > INSERT INTO MON$TRANSACTIONS (MON$TRANSACTION_ID, MON$ATTACHMENT_ID, > MON$STATE, MON$TIMESTAMP, MON$TOP_TRANSACTION, MON$OLDEST_TRANSACTION, > MON$OLDEST_ACTIVE, MON$ISOLATION_MODE, MON$LOCK_TIMEOUT, MON$READ_ONLY, > MON$AUTO_COMMIT, MON$AUTO_UNDO, MON$STAT_ID) > > VALUES (2834800, 84681, 1, '2016-04-13 14:21:39', > 2832348, 2768721, 2771000, 2, -1, 0, 0, 1, 1933); > > INSERT INTO MON$TRANSACTIONS (MON$TRANSACTION_ID, MON$ATTACHMENT_ID, > MON$STATE, MON$TIMESTAMP, MON$TOP_TRANSACTION, MON$OLDEST_TRANSACTION, > MON$OLDEST_ACTIVE, MON$ISOLATION_MODE, MON$LOCK_TIMEOUT, MON$READ_ONLY, > MON$AUTO_COMMIT, MON$AUTO_UNDO, MON$STAT_ID) > > VALUES (2833230, 84857, 1, '2016-04-13 14:25:23', > 2833010, 2768721, 2771000, 2, -1, 0, 0, 1, 2196); > > INSERT INTO MON$TRANSACTIONS (MON$TRANSACTION_ID, MON$ATTACHMENT_ID, > MON$STATE, MON$TIMESTAMP, MON$TOP_TRANSACTION, MON$OLDEST_TRANSACTION, > MON$OLDEST_ACTIVE, MON$ISOLATION_MODE, MON$LOCK_TIMEOUT, MON$READ_ONLY, > MON$AUTO_COMMIT, MON$AUTO_UNDO, MON$STAT_ID) > > VALUES (2829258, 84866, 1, '2016-04-13 14:06:50', > 2829258, 2768721, 2771000, 2, -1, 0, 0, 1, 2293); > > INSERT INTO MON$TRANSACTIONS (MON$TRANSACTION_ID, MON$ATTACHMENT_ID, > MON$STATE, MON$TIMESTAMP, MON$TOP_TRANSACTION, MON$OLDEST_TRANSACTION, > MON$OLDEST_ACTIVE, MON$ISOLATION_MODE, MON$LOCK_TIMEOUT, MON$READ_ONLY, > MON$AUTO_COMMIT, MON$AUTO_UNDO, MON$STAT_ID) > > VALUES (2834822, 84891, 1, '2016-04-13 14:13:14', > 2829911, 2768721, 2771000, 2, -1, 0, 0, 1, 2358); > > INSERT INTO MON$TRANSACTIONS (MON$TRANSACTION_ID, MON$ATTACHMENT_ID, > MON$STATE, MON$TIMESTAMP, MON$TOP_TRANSACTION, MON$OLDEST_TRANSACTION, > MON$OLDEST_ACTIVE, MON$ISOLATION_MODE, MON$LOCK_TIMEOUT, MON$READ_ONLY, > MON$AUTO_COMMIT, MON$AUTO_UNDO, MON$STAT_ID) > > VALUES (2833355, 84977, 1, '2016-04-13 14:27:03', > 2833355, 2768721, 2771000, 2, -1, 0, 0, 1, 2450); > > INSERT INTO MON$TRANSACTIONS (MON$TRANSACTION_ID, MON$ATTACHMENT_ID, > MON$STATE, MON$TIMESTAMP, MON$TOP_TRANSACTION, MON$OLDEST_TRANSACTION, > MON$OLDEST_ACTIVE, MON$ISOLATION_MODE, MON$LOCK_TIMEOUT, MON$READ_ONLY, > MON$AUTO_COMMIT, MON$AUTO_UNDO, MON$STAT_ID) > > VALUES (2833491, 84980, 1, '2016-04-13 14:28:18', > 2833491, 2768721, 2771000, 2, -1, 0, 0, 1, 2527); > > INSERT INTO MON$TRANSACTIONS (MON$TRANSACTION_ID, MON$ATTACHMENT_ID, > MON$STATE, MON$TIMESTAMP, MON$TOP_TRANSACTION, MON$OLDEST_TRANSACTION, > MON$OLDEST_ACTIVE, MON$ISOLATION_MODE, MON$LOCK_TIMEOUT, MON$READ_ONLY, > MON$AUTO_COMMIT, MON$AUTO_UNDO, MON$STAT_ID) > > VALUES (2834880, 85006, 1, '2016-04-13 14:34:02', > 2834880, 2774214, 2771000, 2, -1, 0, 0, 1, 2664); > > > > COMMIT WORK; > > > > Thank you > > > > Best regards > > > > Olaf > > > > > >