On 16 Jan 2003 at 9:57, Ignacio J. Ortega wrote:

> Sorry to repost, nobody has a clue?
>
> I've done some sources research and this error it's emited when a
> problem is found during VIO_verb_cleanup, any one can imagine why this
> error occurs so often?

If the problem is in VIO_verb_cleanup (undo log cleanup to the
savepoint), then I guess that you probably have too much changes in
stored procedures/triggers and one PSQL routine fails (on exception or
error). The problem may occur on pure quantity of changes to roll back or
with conclusion with some race condition (aka bug in engine). A chance
for this multiplies exponencialy when you have procedures that call other
procedures, and all do changes that may fail. This may also occur on
transaction level when rollback is in progress and you have too much
changes in a batch, but not very likely, I would bet on proc/triggers.

I have only one suggestion: Try to narrow down the amount of changes in
proc/triggers or isolate those changes to top level procedures or in
client.

Best regards
Pavel Cisar
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information