Skip to Content
0
Dec 15, 2014 at 09:14 PM

ASE Server periodically Locks out new Connections

93 Views

We are running ASE 15.5 on Linux : Adaptive Server Enterprise/15.5/EBF 20636 SMP ESD#5.2/P/x86_64/Enterprise Linux/asear155/2602/64-bit/FBO/Sun Dec 9 15:11:04 2012

We have experienced periods where new sessions are unable to connect to ASE via isql/JAVA/ODBC. We are not seeing much in error log

Some times we see Login failure messages in log and update of syslogins failed:

00:01:00000:03379:2014/10/30 10:11:43.30 Logon Login failed : User *******, Client IP address: '**********', Appname: ,Sybase Application, Progname: DB-Library, Progversion: 5.0.0.0, TdsVersion:5.0.0.0.

00:10:00000:09278:2014/10/30 10:11:43.30 server Update of syslogins failed

When this happened -- server was not accessible by new connections for any where between 1 minute and 5 minutes .. Then applications were able to connect -- no other issues. All applications/ sessions that were already connected did not seem to experience any problem. This past Friday we experienced lockout of new sessions -- no errors were recorded in the log. Lock out did not correct itself -- We do have an open CASE with SAP and we attempted to get a shared memory dump. We had to terminate the memory dump after 40 minutes and then were forced to reboot ASE .

Anyone experience anything similar ?