> > 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
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com