Skip to Content

terminate session with ase database

Dears,

kindly note we use sybase ASE 15.7 for our production database,

we set number of user connection = 1000

while users are connecting to the database through our internal applications,

one or more users disconnected suddenly without any notification in the error log,

and the connected users at that time is just 600

how can I investigate in this case, and find the real cause of terminating the session with database.

- it is not network issue.

- we don't have audit database.

please advice.

Thank you

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 09 at 05:43 PM

    What is "common" for the group of end-users who lost their connections ?

    Geo-location ? then it points to problem in end-to-end connectivity (i.e. most probably a network related issue)

    ASE knocks out inactive/non-reachable connection only after tcp time out set at OS level. And it normally leaves a line in the error log about this.

    Other reasons may be

    - tempdb for the set of users not being available or full (but again this will result in lines in error log)

    - Locks running out (leaves lines in error log)

    Best option would be use auditing or have a periodic job to monitor master...sysprocesses, master..monProcesses etc.

    HTH

    Avinash

    Add comment
    10|10000 characters needed characters exceeded

    • Thank you dear for replying.

      kindly find my comment below on Mr Bret's answer, and I will add:

      I check tempdb after receive a complaint from a user, but it is not full, what do you think about user log cache size ?

      kindly find tha attached file in my previous comment, I think there is some thing with Large IO denied, or with packet size?

      did you mean to run select * from master..sysprocesses every 30 minutes as an example?

      Best Regards

  • Jan 09 at 05:39 PM

    How have you become aware of the disconnects?
    Are users complaining, if so exactly what did they experience?
    Is the spid gone but locks owned by the spid left behind (this issue is called "phantom locks")?
    Any common factors for the disconnects (particular users, particular applications, particular time of day)?

    -bret

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Bret, Thanks in advanced.

      I will try your suggestions if experienced the problem again, I think we won't

      kindly note what happened recently, it add some clearness on the issue:

      yesterday, there were complaints about 2 issues:

      1- when users tried (through their connection to the production database) to get data from another server which was added on the production database as a remote server,I can see it in the master..sysservers table,

      they got the following error:


      at that time, I logged in as a window user to the server where our sybase production server is, and from dsedit tool try to ping to that remote server and got the error message which was recorded in the database error log;

      ping to the server x.x.x.x:6000 using protocol tcp

      Net-lib protocol driver call to connect two endpoints failed to connect to server, Error is 10055 An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.

      but pinging from dsedit tool on my PC was fine,

      I want to say the problem was from the production sybase server, cause pinging in the opposite direction : from remote server to production was fine from dsedit on that remote server.

      I googled for this error and found that this is a windows issue returned to the cause of OS may run out of memory for tcp buffers, and one of the solutions was reboot the server to release some resources, or add some tcpip parameters to the registry.

      but before restarting the windows server , I issued netstat on cmd and got more than 2000 results in TIME_WAIT state,

      2- the second complaint was, some users try to connect to the database's server for twice and others for 3 times but couldn't establish a connection, at the next try they success ed

      I restarted the windows server (which by it's way restarted sybase services), the pinging (for the first issue) done fine, and till now no user has a complaint about disconnecting or a problem in connection establishing to the database.

      Many thanks for you

      select-error.png (29.6 kB)
  • Jan 08 at 07:22 PM

    Hi Suzn,

    Are there any corresponding messages in the SM21 system log or any ST22 short dumps raised during the random disconnects?

    Thanks,

    Madhvi Pai

    SAP Product Support

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks for replying dear,

      I think SM21 or ST22 are related to SAP, aren't they?

      I don't have SAP app, I just work with sybase ASE .