Subject Re: Upgrading from FB 2.0.3 to Firebird-2.1.1.17910: fbserver.exe goes to 100% CPU
Author vahrokh
> Show us a "gstat -h" output when server is busy.
>
> Regards,
> Vlad
>

Here we go. Off a freshly restored database (to weed off "garbage").
fbserver.exe currently at 87% CPU usage, *after* quitting the
application (which worked perfectly as-is till the 2.0.3 => 2.1.1
upgrade).

Another interesting bit I noticed: in IBExpert etc. the CPU goes high
when you start the software and open the database.
In our application (made with Codegear RAD Studio's Delphi) it goes
CPU crazy *after* quitting the application. That is, it works well
during the application duration and then almost hangs the machine
when exiting it. Even without writing a single byte on the database.


Here's the output you asked for:


Database "measures_database.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 77861
Page size 4096
ODS version 11.1
Oldest transaction 77641
Oldest active 77642
Oldest snapshot 77642
Next transaction 77643
Bumped transaction 1
Sequence number 0
Next attachment ID 30661
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Nov 28, 2008 12:11:26
Attributes force write

Variable header data:
Sweep interval: 1
*END*