Hello!

Firebird SS 2.1.1.17910-4
Windows XP Service pack 2
Filesize: ~800mb backup ~40mb

I noticed strage behaviour with one of my databases. Suddenly one
table (CLIENTS) become very slow to query. First it happened few weeks
ago - basic backup/restore helped (25 Aug). Today it happened again,
but now backup process also is going terribly slow.

Have not seen/hear about such beahviour in my more than 7 year
experience with first Interbase then Firebird.

I restarted all services - apache,firebird - nothing changed.
Restarted box - nothing changed.

Here is how far the gbak is get:
....
here come some other tables and indexes
....
gbak:587524 records written
gbak: writing index CLIENTSINDEX1
gbak: writing index CLIENTSINDEX2
gbak: writing index CLIENTSINDEX3
gbak: writing data for table CLIENTS
...
Here it is hanging about 3hours now, although I can see a small backup
file size increment - a few KB in 5-10min.

Here is gsec output, but I can`t see nothing unusual except it also
hangs at "Analyzing database pages ..."

Database header page information:
Flags 0
Checksum 12345
Generation 44503
Page size 4096
ODS version 11.1
Oldest transaction 44493
Oldest active 44494
Oldest snapshot 44494
Next transaction 44495
Bumped transaction 1
Sequence number 0
Next attachment ID 12040
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Aug 25, 2008 21:57:39
Attributes force write

Variable header data:
Sweep interval: 20000
*END*

Analyzing database pages ...

Any ideas?

Thank you!