2433845 - Running sp_config_rep_agent will generate stacktrace and timeslice in ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2433845 - Running sp_config_rep_agent will generate stacktrace and timeslice in ASE

Symptom

  • Running the following Replication Server commands in a batch:

use DBNAME
go

dump tran DBNAME with truncate_only
dbcc settrunc(ltm,valid)
exec sp_config_rep_agent DBNAME, 'enable', '<repserver name>', '<rep server ra user>', '<ra user password>'
exec sp_config_rep_agent DBNAME, 'send warm standby xacts', 'true'
go

  • The following timeslice error is reported in the ASE error log:

timeslice error: spid 735 exhausted its 'time slice' of 100 milliseconds and additional 'cpu grace time' of 500 ticks (50000 milliseconds). It has been marked for termination.
This Adaptive Server process has had 15 major and 9572 minor page faults since boot.

  • The following stack trace is reported in the ASE errorlog:

pcstkwalk.fdpr.chunk.1+0xac()
ucstkgentrace+0x418()
ucbacktrace+0xc8()
terminate_process.fdpr.chunk.6+0x3ec()
kitermproc+0x174()
oh_findendoffset_inobuf+0xc()
rvm__auditrecord_from_cmdtxt+0xb8()
rvm__audit_getcommand_subcommand+0xc0()
form_and_send_audit+0x2f4()
rvm__audit_table_view_access+0x5f8()
rvm_dispatch.fdpr.chunk.9+0xdc()
rvm_process_dispatch+0x30()
s_execute.fdpr.chunk.26+0xbf0()
sequencer+0x4d0()
execproc+0x600()
s_execute.fdpr.chunk.52+0xc8()
tdsrecv_language+0x240()
end of stack trace, spid 735, kpid 1346437344, suid 150

  • ASE server has auditing enabled:

sp_configure "enable auditing", 1
go


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0
  • SAP Replication Server (SRS) 15.7

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 15.7

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-REP , Sybase Replication Server (standalone) , 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.