Hi,

When you say 2.1 you think for 2.1.0 or 2.1.1 or 2.1.2RCx?
I am not used the monitoring tables but I see in WhatsNew some
improvements/changes made.

Gabor

Olaf Kluge írta:

> Hi,
>
> has no one the same problem with the monitoring tables?
>
>
> Hello,
>
> I have installed firebird 2.1 this weekend, there was a firebird 2.0
> installation before.
>
> After the restore I have executed the metadata update.
>
> We have transaction problems with one application connected to our firebird
> database. It was developed by an other developer. All other applications are
> clean, but the one developed dll does not commit the transactions.
>
> Now I can see the transaction problem in the monitoring tables.
>
> But:
> After I have restored the database, the follow sql statement returns a true
> result (details of the last saved transaction):
>
> select
> md.mon$oldest_active,
> mt.mon$transaction_id,
> ma.mon$remote_address,
> ma.mon$remote_process,
> ma.mon$attachment_name,
> ms.mon$timestamp,
> ms.mon$sql_text
> from mon$database md
> join mon$transactions mt on mt.mon$transaction_id=md.mon$oldest_active
> left join mon$attachments ma on ma.mon$attachment_id=mt.mon$attachment_id
> left join mon$statements ms on ms.mon$transaction_id=md.mon$oldest_active
>
> But after a few hours, the statement returns a blank result. Is the last
> saved transaction in the database-monitoring-table not present in
> transactions-monitoring-table? (md.mon$oldest_active =
> mt.mon$transaction_id) What is wrong?
>
> This code does work: (returns all transactions)
>
> select
> mt.mon$transaction_id,
> ma.mon$remote_address,
> ma.mon$remote_process,
> ma.mon$attachment_name,
> ms.mon$timestamp,
> ms.mon$sql_text
> from mon$transactions mt
> left join mon$attachments ma on ma.mon$attachment_id=mt.mon$attachment_id
> left join mon$statements ms on ms.mon$transaction_id=mt.mon$attachment_id
>
> My second question, should something not work tomorrow, can I easily
> fallback to the old firebird version? I have made the metadata update, is
> this a problem to fallback?
>
> A big Thanks to all the firebird developers and newsgroup members for the
> good work, and thanks for your help.
>
> With best regards.
>
> Olaf Kluge