Subject Re: [firebird-support] User lockouts
Author David Johnson
The 20 minutes is probably a sockets timeout.

I concur with the other replies I have seen here ... open that sucker
up.

Look for event loops - a common issue in Delphi.

Make sure that your business logic is linear (as much as possible) and
is not attached to the GUI layer. Delphi's GUI events are prone to
recursion if your programmers are not intimately familiar with the
internals of the VCL.

Identify where and why the application is locking up. If you cannot
reproduce the issue under the IDE, then it is likely to be stack
corruption.

Generate a trace log of every action you take - entry into _every_
method and exit from _every_ method.




On Thu, 2005-09-15 at 08:42 +0000, Robin Cumming wrote:
> We are using Firebird 1.5x on a Win2003 server with a Delphi 5 based
> application. We are experiencing hangs in the application (no doubt
> due to bad code), the user then ends the process/application with task
> manager, and restarts the application. However Firebird will not allow
> the user to re-connect for about 20 minutes. The program uses IBX
> components to test whether the user is connected to FB, and FB reports
> the user is still connected even after disconnecting and re-starting,
> thus the 20 minute wait.
>
> Any suggestions on the cause of the problem and what we can do to fix ?
>
> Many thanks
>
> Rob Cumming
> rcumming@...
>
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>