SAP Knowledge Base Article - Preview

2302143 - Replication latency increased and DSI connection to the standby ASE seems to hang.

Symptom

  • The replication latency increased.
  • The DSI connection to the standby database seems to hang.
  • Dbcc stacktrace on the DSI connecion in standby ASE show the following stack:

    Start dbcc stacktrace...
    pc: 0x00000001006fbf7c pthread_self+0x4c()
    pc: 0x00000001000bdee0 kpsuspend.fdpr.chunk.1+0x8()
    pc: 0x0000000100668510 upsleepgeneric+0x2ac()
    pc: 0x000000010007c434 kbpsema.fdpr.chunk.2+0x6c()
    pc: 0x00000001005d3420 ubfgrow+0xa8()
    pc: 0x00000001005d31b0 kbfalloc.fdpr.chunk.5+0x7c()
    pc: 0x0000000100653a1c ubfallocf+0x24()
    pc: 0x0000000100e50b8c ssql_save_SQL+0x494()
    [Handler pc: 0x00000001007747a4 ut_handle installed by the following function:-]
    pc: 0x00000001017c7aec lwp_create.fdpr.chunk.1+0x250()
    pc: 0x000000010077a5e4 proccreate.fdpr.chunk.2+0xc()
    pc: 0x0000000100702bf0 s_crtproc.fdpr.chunk.1+0x100()
    pc: 0x0000000101bbe81c s_cache_stmt+0x214()
    pc: 0x0000000100dc80c4 s_normalize.fdpr.chunk.19+0xb8()
    [Handler pc: 0x00000001007903c4 hdl_stack installed by the following function:-]
    [Handler pc: 0x0000000100899ce8 s_handle installed by the following function:-]
    pc: 0x0000000100703114 sequencer.fdpr.chunk.8+0xe0()
    pc: 0x000000010071d3c4 tdsrecv_language+0x258()
    [Handler pc: 0x00000001007747a4 ut_handle installed by the following function:-]
    pc: 0x000000010071cfc0 conn_hdlr.fdpr.chunk.12+0xc4()
    dbcc stacktrace finished.


Read more...

Environment

ASE 15.7 SP134

Product

SAP Adaptive Server Enterprise 15.7

Keywords

KBA , BC-SYB-REP , Sybase Replication Server (standalone) , 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 ONE Support launchpad (Login required).

Search for additional results

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