SAP Knowledge Base Article - Preview

2847078 - Errors on the sybsystemdb reported and now the server will not reboot - SAP ASE

Symptom

Restored sybsytemdb several days before, but received the following errors in an 8 minute period days before and then stopped:

  • Over 2700 error:
    Error: 692, Severity: 20, State: 1
    Uninitialized logical page '2560' was read while accessing database 'sybsystemdb' (31513), object '' (99), index '<Unknown>' (0), partition '<Unknown>' (99). Please contact SAP Technical Support.
  • 18 error:
    Error: 1251, Severity: 26, State: 1
    An in-use preallocated semaphore cursor was encountered.
  • 12 error:
    Error while undoing log row in database 'sybsystemdb'.  Rid pageid = 0; row num = 0.
  • Another symptom was that no checkpoints were finishing and some databases hit 1105 errors
  • Finally did a shutdown with nowait and the server would not come backup
  • The reboot failed and now the server will not come backup with stack trace:

    Started recovery checkpoint for database 'sybsystemdb'.
    Current process (0x50003) infected with signal 11 (SIGSEGV)
    Current Process is running on Engine 0
    pg__find_ext
    General Registers (uc_mcontext.gregs)

    plcblock__flush
    xls_flush_plcqueue
    plc__flush
    xls_preflush
    ckpt_write_new_record
    checkpoint
    recovery
    hdl_backout_msg
    specialrecover
    ds__recoverdbs
    dsinit

  • The server then shuts down

    shutdownproc: shutting down server
    ueshutdown: exiting
    Main thread performing final shutdown.
    bucket manager consolidator terminating
    Blocking call queue shutdown.


Read more...

Product

SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.