SAP Knowledge Base Article - Preview

2130834 - monMemoryUsage queries fail in kbfusage, mda__MemUsg_one_FragmentPool - SAP ASE

Symptom

You are running applications on SAP ASE database.

  • On non-SAP systems, you execute a query against monMemoryUsage monitoring table.  For example: select * from master..monMemoryUsage 
  • On SAP systems, you have enabled Memory  Usage data collector  in DBACockpit->Data Collector Framework

  • In both scenarios, the process terminates with a timeslice or signal 11 errors in the ASE errorlog at address kbfusage:

Current process (0x3b2f0086) infected with signal 11 (SIGSEGV)
Address 0x0x0000000001d85c7d (kbfusage+0x36d)

  • The errors are accompanied by a stacktrace referencing the functions:

kbfusage
ubfprop
mda__MemUsg_one_FragmentPool
mda__MemUsg_FragmentPool
mda__MemUsg_PoolList
mda_populate_monMemoryUsage
mda_exec

  • And SQL Text and/or SQL causing error section showing query on MDA table monMemoryUsage
    • Below an example snippet that is commonly seen for a DBACockpit query:

....
AS UsedSize_Delta_KB, ((UsedSize/1024)) AS UsedSize_KB FROM  master..monMemoryUsage AS SRC_MONMEMORYUSAGE

  • Subsequently, further messages including error 1601 may be seen:

ksepollnetctlrWaitForCompletion:polled events 0x18 for vsn 127 psn 120 flags 0x80000000 kpid 994115631

Error: 1601, Severity: 17, State: 3
There are not enough 'user connections' available to start a new process. Retry when there are fewer active users, or ask your System Administrator to reconfigure ASE with more user connections.

See attached file Stack_Error_Example.txt for a full example from ASE log.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

kbfusage+0x15a() , ubfprop+0xfa() , mda__MemUsg_one_FragmentPool+0x4c() , mda__MemUsg_FragmentPool+0xd8() , mda_populate_monMemoryUsage+0x1c2() , mda_exec+0xb2() ,
kbfusage.fdpr.chunk.3 , ubfprop.fdpr.chunk.3, mda__MemUsg_PoolList+0x2af(), monMemoryUsage , KBA , monitoring table , mda , memory corruption , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , Bug Filed

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.