Kbase P27786: _sqlsrv2 processes remaining after DB is shutdown
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/03/2009 |
|
Status: Verified
SYMPTOM(s):
_sqlsrv2 processes remaining after DB is shutdown
these _sqlsrv2 processes use all real and virtual memory of the machine
Database log file filled with SYSTEM ERROR: Memory violation. (49)
No core/protrace file generated
Following messages within the database log file
Server shutdown started by <user-id> on <tty>. (542)
SQLSRV2: dsmUserDisconnect called for invalid user. rtc: -20031. (7132)
called for invalid user. rtc: . (7132)
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.1x
All Supported Operating Systems
CAUSE:
The problem might have been generated by SQL92 users ending their session abnormally (by switching off their terminal for example) at the time the shutdown requested was trying to kill them.
FIX:
TEMPORARY WORKAROUND:
Limit the memory usage for processes (using "ulimit -m")
DEBUGGING STEPS:
1. Send a "kill -8" /* Floating Point Signal*/ to the _sqlsrv2 processes so that a core file is produced.
2. Send to Technical Support the corresponding stacktrace (either to be found in a protrace file generated at the same time as the core file, or by using a OS tool like adb, sdb or dbx).