The sybase server version 12.0 running on solaris 2.7 / 2.8 systems, sometimes stops responding to submitted queries or responds very very slowly. The following is a snapshot of one such application waiting for response from sybase server.
I have tried to increase the size of catche and of tempdb also, without any result. while above call hangs, many other queries submitted at the same time get responded, even though slowly. The problem is not for a specific query. Generally, query without any clause is running fine during the same time. the output of sp_who shows the process as 'runnable' and it never turns to 'running'.
How can sybase server come out this deadlock kind of situation?
That's a stack trace in the errorlog, but the very beginning of the stack trace is missing, and the end as well. Do you have other errors messages that occur before the stack trace ? Can you show us the beginning of the stack trace ? Seems there is a lot of network function displayed in the stack trace.
I know as well there are specific SUN SOLARIS patches to install to run sybase 12.0 safely, depends of your environment and the kind of issue you have, but maybe it is not necessary,might be possible to upgrade your sybase open client, need more infos.