|Subject||RE: [firebird-support] Problems with transactions|
> Suddenly today the database stopped sweeping. The interval has for yearsThe engine hasn't stopped working.
> 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 "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 upYou need to track down your stuck connections/transactions.
> the database without doing this or finding at least the cause.
You can use the MON$ tables to help you identify the source of these items.