Subject Re: [firebird-support] Re: Restart fixes performance issues
Author Martijn Tonies
> > This does.
> >
> > You have a runaway transaction somewhere. The difference between
> > "oldest active" and "next" is too large.
> >
> > Fix it.
> >
> How? :-)
> I've already researched and ended up with the same thought - but how
> to fix it? Is there a way to tell Firebird to end a certain
> transaction that is running for too long?

Apparently, there's a transaction somewhere in your application
that doesn't get committed or rolled back.

Don't use "commit retaining" without the occasional Commit either.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!