Subject RE: [firebird-support] Weird behaviour
Author Leyne, Sean
> A thread is trying to perform a SQL select, a client wants to display detailed
> information for a certain row.
> Basicly Select * from TABLE where PKEY = PKEY
> The thread acquires lock in our server, then works it's way through GDS32.dll
> (fbclient.dll) and then times out on the call to WinSock2 select (I guess it
> retries if no success, because it never returns).
> MON$STATEMENT shows a stalled SQL statement corresponding to the SQL
> statement above.

Please review the database "Sweep Interval" setting (IMO, it should be = 0) -- your query could be getting caught up with a database sweep.