> 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. Sean
