Skip to Content
author's profile photo Former Member
Former Member

Events Cluster Edition

Hi

I have an ASE Cluster Edition 15.7 SP121 and in rare circumstances all the processes in the database been became in status sleeping. There is not errors in the Sybase ErrorLog. The Event ID for these process is 512 (waiting for buffer validation in cmcc_bufsearch) and 509 (waiting for buffer read in cmcc buf search). Additionally I need documentation about the possible events in Cluster Edition.

The solution until the moment has been Kill on dataserver because there is not posible kill the process or restart the server.

Anybody Can help me?.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Oct 27, 2014 at 06:03 PM

    Hi Cristian,

    How are you accessing data in the cluster? All applications that access a given database should be coming through a single instance/node. We do not recommend inserts/updates/deletes to a given database from multiple instances. I'd like to rule this out before digging deeper.

    Regards,

    Mark Kusma

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 13, 2014 at 11:15 PM

    Hi Cristian,

    I pass through this situation many times with many processes and the finally recommendation of Sybase or SAP today its not having any object in witch both instances make dml operations because of internal sync of locks and pages. The processes sleeps in events mostly related with CLM or OCM.

    SAP releases SP 130 with many changes, one its single instance database in order to config an ownership to a database on an instance. Have you taken a look at it? Perhaps it may help you.

    Regards.
    Javier.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 27, 2014 at 07:21 PM

    Hi Cristian,

    have you figured out the reason of this events?

    Recently I´ve had the same situation, and in some circumstances the Cluster (with 2 nodes) hanged.

    In my case the problem was the configuration of two parameters, related to cache replacement.

    Both was set to 2000, and we change to 0.

    "number of index trips"

    "number of oam trips"

    Fernando

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 14, 2016 at 08:57 PM

    Is this resolved? Is SAP still recommending to only use one half of the cluster for write operations to a particular object? If so, how will it compete with Oracle RAC? They seem to have no issues writing to both sides of the RAC to the same object.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.