SAP Knowledge Base Article - Preview

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

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

replication latency, ELC flushing , 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 for Me (Login required).

Search for additional results

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