Hi!

In a C/S environment, whenever there is heavy workload (e.g. a query that takes minutes for execution) and a different user starts the application, session is connected and the first query about to be opened, the application hangs for a short while, then I get the "Cannot lock the session manager" error on "Open Table" and "Prepare Statement".

The IDs (what do they mean anyway?) differ, I've seen 3, 4, 5, 10, 19, 21 in the last days.

I'm on 2.30 Build 5.

Any ideas? Is there maybe a timeout setting that is set to low?

Heiko,

<< In a C/S environment, whenever there is heavy workload (e.g. a query that takes minutes for execution) and a different user starts the application, session is connected and the first query about to be opened, the application hangs for a short while, then I get the "Cannot lock the session manager" error on "Open Table" and "Prepare Statement". >>

This normally indicates that the remote session on the client has disconnected and is attempting to reconnect to the same session, but cannot do so because the session on the server is still servicing the last request (it's a long-running request).

If you're seeing this across different application instances, then please send me an example and I'll take a look.  I suspect that it's the above issue, but it's possible that it could also be something like trying to query the server's session information tables while a long-running query is still being executed.

Tim Young
Elevate Software
www.elevatesoft.com