Subject Re: [firebird-support] Re: An existing connection was forcibly closed by the remote host (FB1.53/Win2003)
Author Bogusław Brandys
Glebas wrote:
> No UDF in use, this is the last thing I would use, thanks :)
>
> --- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...>
> wrote:
>> are you using UDFs in your application? if so are they your own? or
> some
>> other?
>> badly written UDFs have a habit of crashing the server
>> Alan
>>

No UDF.No BDE. Then check for:
- CommitRetaining
and/or missing hard commit after long insert/update operations
or using savepoints inside frequent transactions
or large data commit inside single transaction

due to this error from firebird.log:

SERVER (Server) Mon Mar 27 14:02:55 2006
Database: C:\PROGRAM
FILES\ISPC\PLANNER\SERVER\FDB\PLANNER.FDB
internal gds software consistency check (Too many savepoints
(287))


it may or may not be a problem here but you will know later if you cope
with this error

Regards
Boguslaw