Another track to take may be how may connections you have to the server.
Server2003 has recently been more agressive about limiting connection
counts after security updates. The symptoms are the same - the log file
records a more general problem.

Max

> Kevin,
>
> > I've gotten a few reports since install that my application
> > just "freezes". Some reports can be run but data entry
> freezes
> > up (order entry, check writing, etc).
>
> > I have not been able to dial in to check the FB log yet.
>
> There will be probably nothing interesting in it.
> At least, nothing about freezing. :)
>
> > I did dial in this AM, ran a "mend" batch file which is an
> excerpt
> from
> > Helen's book to validate, mend, validate, backup and restore the
> database
> > from a copy of the live one. This seems to fix the freezing
> problem.
>
> Especially, restore :)
>
> > Has anyone run into something like this before? This client used
> to be on =
>
> I also have this problem with FB153SS freezing on Win2003 server.
>
> Currently, I have three suspects:
>
> 1) FB2RC1 release notes in the Bug fixed section contains this:
>
> > SF #1385092 A TCP/IP connection would appear to freeze the
> > Superserver if it was disconnected abnormally while a large
> > packet, e.g. a BLOB or a large SQL request, was being passed
> > across the interface.
>
> 2) Long-lasting or dead (eg. lost connection) write transaction
> may cause another client running transaction to wait until the
> problematic transaction either commits or rollbacks itself.
> This may appear as freezing.
>
> 3) Fetching huge result-set may appear to the client as freezing.
> Check if your client application allows that. Have progress bars
> whenever possible for users to see if it is doing something big
> or it is actually freezing.
>
> What is worse, if some impatient people experience freezing, they
> tend to turn the computer off, which results in lost connection
> and improving chances of further freezing because of unfinished
> transaction until it is detected as such.
>
> Also, nightly garbage collection (sweep) is very healthy.
>
> Regards,
> Glebas
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
> SPONSORED LINKS
> Technical support
> Computer technical support
> Compaq computer technical support
> Compaq technical support
> Hewlett packard technical support
> Microsoft technical support
> YAHOO! GROUPS LINKS
> Visit your group "firebird-support" on the web.
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>