Subject RE: [firebird-support] Problems with transactions
Author Leyne, Sean
> Suddenly today the database stopped sweeping. The interval has for years
> been set to 0 due to some automatic cleaning im doing every night.
> Now i cant sweep the database. nor when using GFIX -sweep command.

The engine hasn't stopped working.

The "stuck transactions"/connections are preventing the garbage collection from operating.

> The next i could do is backup/restore, but there must be a way of cleaning up
> the database without doing this or finding at least the cause.

You need to track down your stuck connections/transactions.

You can use the MON$ tables to help you identify the source of these items.