> Hello, y write to the developer group because i'm observing a very strange
> behaviour in transaction counter,
> and i don't know what needed for open it in the tracker.
>
> I use 2.5.2 superclassic in windows 2008 server 64 bits. I have migrated one
> customer from Interbase 2009
> to Firebird two years ago. The Interbase database, has a transaction count of
> 100.000.000 in a year and a
> half, but after migrate to Firebird, in one day and a half has near 1.000.000
> transactions.
>
> I have done a selet of mon$transactions and i see that transactions with
> higher timestamp has transaction_id
> less than transactions with lower timestamp. I also has observed that in a
> minute there is jumps of por than
> 40000 transactions, and there is no process running such amount of
> transactions.
>
> For example, i see this
>
> Transaction ID Timestamp
> 948265 06.07.2012 10:35
> .....................................................
> 938474 06.07.2012 10:36
> .....................................................
Interesting. Could you show also miliseconds part of the timestamp ? It is
very possible, that tx 948265
was really created few ms before tx 938474 but obtains its number after it (due
to threads preempting by OS
scheduler and needs to obtain EX lock for header page to assign tx number).
> Is impossible that our application generates such amount of transactions and
> i know the first answer is that
> there is a process creating a lot of transactions, but is impossible,
Use trace to see what really happens.
> and two days ago all runs fine with Interbase.
AFAIU, IB used more lightweight way to assign tx numbers and it is SS, not
SC\CS
Regards,
Vlad
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
