Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2008
    Posts
    10

    Unanswered: Sybase Hang - No Errors in the Log

    Hey,

    We had a issue yesterday were all the users or ourselves could not get into sybase, it appears that sybase just hung.

    We have sybase 12.5.0.3 EBF 11441
    running on Solaris 5.8

    on the unix box i could see the dataserver was still running but i could not connect. had to kill the process and start the sybase again.

    but there is nothing in the error log or on the unix logs.

    as any one experience this before? this has happened about 3 times in the last year, our support are not sure either

  2. #2
    Join Date
    Oct 2005
    Posts
    13
    did you check the machine's swap when this happens ?
    i am confused ...

  3. #3
    Join Date
    Mar 2009
    Location
    Sydney, Australia
    Posts
    258
    When you state the dataserver was still "running", what exactly did you find out ?
    - cpu time changing (and staying high)
    - I/Os changing
    which means it was actually running and so busy that connection failed (timed out). As opposed to hung, doing nothing, and unable to accept connections.

    In the former case, you need to check that is was not in an infinite loop, or rolling back a large transaction.
    Regards
    Derek Asirvadem (Formerly DerekA)
    Information Architect / Senior Sybase DBA
    Copyright 2009 Software Gems Pty Ltd

    I answer questions from the Original Poster only. If you have a genuine question, as the moderators have requested, start a new thread.

    http://www.softwaregems.com.au

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •