Error 842

Severity

20

Message text

Attempt to set bufclaims in PSS structure for process %d to negative value while unclaiming cache.

Explanation

Adaptive Server manages physical disk pages while they are in memory by maintaining buffer pools of logical pages in cache. It allocates buffers to server tasks as needed, keeps track of the buffers assigned to caches and tasks, and releases buffers that are no longer needed by a task. It also accesses the process status structure (PSS), which is a memory structure associated with each process describing the state of the process.

Error 842 occurs when a buffer is released, and the task is found to have a negative buffer count as a result. This error is at times seen during sort operations; for example, during index creation.

Error 842 breaks your connection to Adaptive Server.

Action

Reconnect to the server.

If the error persists:

  1. Configure the server to obtain a shared memory dump for future occurrences of error 842; and

  2. Contact Sybase Technical Support after collecting the memory dump and related error data.

    To configure the server to dump shared memory upon future occurrence of error 842:

    1> sp_configure "dump on conditions",1
    2> go
    
    
    1> sp_shmdumpconfig "add", error, 842, 1, <directory>, <file_name>
    2> go
    

Additional information

Have the information listed in “Reporting errors” on hand when you call Sybase Technical Support, including the output of sp_shmdumpconfig.

Versions in which this error is raised

All versions