Skip to Content
0

Connection failures to Sybase ASE 15 server

Dec 18, 2016 at 11:31 PM

63

avatar image

Our client reporting console (PHP on apache, using freetds, PDO/mssql_connect) uses Sybase ASE 15 as a backend and for the last few months we have had a lot of connection failures when users are trying to login or use the console.

The PHP error we see is:

SQLSTATE[HY000] Adaptive Server connection timed out (lenny) (severity 6) (error code: 500)

The ASE log has a lot of errors like:

00:03:00000:00051:2016/12/19 11:35:13.30 server  Error: 1608, Severity: 18, State: 300:03:00000:00051:2016/12/19 11:35:13.30 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.

On the ASE side we are typically seeing a login process that appears to be blocking all other requests for several seconds. Doing sp_showplan on the process does not give any information.

Any ideas what might be causing this issue?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers