At 02:51 PM 3/11/2003 +0200, you wrote:

>Hi Guys,
>
>I am running Firebird 1.0.3 on a Windows 2000 SP4 Box.
>
>After a large batch operation using external file the database behaves
>very strangely.
>
>If I touch the imported data in any way (even a simple select) I can
>not disconnect from the database afterwards.

This doesn't mean anything is wrong. It means there is a garbage
collection thread running and it's not finished yet.

>It is weird because everything works just fine including
>queries on the imported data and on any other table.

I think possibly there's something you're not telling us: did you begin
the import operation by deleting a large number of old records? If so,
then the first transaction on that table *after* the one that did the
deleting will launch the garbage collector.

>Even Firebird service hangs up and must be terminated manually.

Not hung up, just busy.

h.