02.07.2015 13:45, brucedickinson@... [firebird-support] wrote:

>
> here is the output from gstat.
>
> Database header page information:
> Flags 0
> Checksum 12345
> Generation 500
> Page size 16384
> ODS version 11.2
> Oldest transaction 1
> Oldest active 2
> Oldest snapshot 2
> Next transaction 492
> Bumped transaction &nb sp; 1
> Sequence number 0
> Next attachment ID 2
> Implementation ID 16
> Shadow count 0
> Page buffers 0
> Next header page 0
> Database dialect 3
> Creation date Jul 1, 2015 10:50:27
> Attributes force write
>
> Variable header data:
> Sweep interval: 20000
> *END*
>
> Gstat was started right after the restore. Is it normal to have so many
> active transactions right after the database restore?

Yes. I suppose you used the -verbose switch, right? In this case each
index is created in a separate transaction.


Dmitry