Hi Chad,

At October 11, 2004, 15:38, Chad Z. Hower aka Kudzu wrote:

> FB 1.5.1.4481

Can you say which version: Classic or Superserver?
And, is it Windows or Linux? I know the last time you referenced to
Windows, but I just want to make sure.

> I have a routine which does:

> Select single record by PK from single table.
> Issue a new update on same record to same table.

> This happens in a transaction and is repeated for each record. Normally a
> couple dozen times. The complete set is done in a trasnaction, not each one.

> Because of a flaw we had a situation that instead of a a few dozen times it
> ran 10,000. Now we fixed this, but the bigger problem is FB just dies. It
> appears that when a transaction log is too big it just dies?? We've
> reproduced this on our test server and two developer machines.

IIRC, something related to that was mentioned post FB 1.5.1. But, I'm
not 100% sure. And, it has to do with the transaction internal save
points.

> The erros are below. When I look in Guardian, it says server terminated
> abnormally or something like that.

You could also try the debug build to see if you can get a dump of the
error and send that to the developers.


--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)