Hi Sean

Thanks for your reply.

What am I looking for in the MON-tables and where? And if founding a symptom or problem, how can it be fixed without Backup/restore=

\Kenneth

--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@...> wrote:
>
>
>
> > 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.
>
>
> Sean
>