Symptom
SELECT queries accessing the MDA table, monDeviceSpaceUsage, fail with timeslice errors when:
- "dump database' is running alongside heavy activity on the system
- The ASE database devices, are NFS-mounted
The offending queries are:
SELECT distinct FileSystemName, FileSystemSizeMB, FileSystemFreeMB FROM master..monDeviceSpaceUsage
INSERT #filesystem_metrics SELECT DISTINCT InstanceID, FileSystemName, FileSystemFreeMB, FileSystemSizeMB, getutcdate() AS TIMESTAMP_UTC FROM master..monDeviceSpaceUsage
Timeslice errors are reported in the ASE errorlog for this query execution.
The accompanying stacktrace references any or all of the functions: __xstat64, __lxstat, mda__get_FileInfo(), mda_populate_monDeviceSpaceUsage()
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP NetWeaver (NW) - All versions
Product
Keywords
monDeviceSpaceUsage, NFS, dump database, backups, stat, CR 792402, __xstat64, timeslice , KBA , __xstat , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , 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.