Kbase P139514: Remote server process (_mprosrv) crashing / died after posting 163 error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/05/2011 |
|
Status: Verified
SYMPTOM(s):
Remote server process (_mprosrv) crashing after posting 163 error
SYSTEM ERROR: Seek error <value>, file <value>, addr <value>. (163)
SYSTEM ERROR: Seek error 22, file 329, addr -2147377152. (163)
** Save file named core for analysis by Progress Software Corporation. (439)
Disconnecting client <number> of dead server <number>. (2526)
Disconnecting dead server <number>. (2525)
The issue can be duplicated by having multiple users performing the same functions within a specific piece of the application.
Stack trace from _mprosrv reads:
seektobdll
writetobdll
writeto
uttfbkd
qrTmpBlkFree_19_7
qrTmpClose_20_16
qrBoolTerm
Client log file shows that the clients that are connected to the remote client server process when it crashed are not connecting via the AppServer.
FACT(s) (Environment):
Clients connect to database in a client server mode (using -H and -S)
Clients also connect to AppServers that are local to the database server machine.
Clients are on a Windows Terminal Server machine.
Database is on AIX 64 bit machine.
PowerPC 64-bit
OpenEdge 10.1B03 Service Pack
CAUSE:
Bug# OE00207114
CAUSE:
The _mprosrv process that was spawned to handle the client requests, crashed because the temporary srt file tried to exceed the 2 GB temporary file size limit. The _mprosrv has a global temporary file that is used to handle requests for all clients connected to that server process.
Prior to 10.1C the temporary files were limited to 2 GB. In 10.1C and later the files are no longer limited to 2 GB. However this defect prevented the server from exceeding 2 GB for the sort file.
FIX:
A possible workaround would be to decrease the number of clients connected per server (-Ma) so that the temporary sort file does not exceed 2 GB for the types of queries being executed on behalf of the remote clients.
Wen reducing the number of clients per server, you may want to increase the total number of servers (-Mn) to accommodate the number of remote clients that need to access your database.
FIX:
Upgrade to 10.2B05 or 11.0.
There is a hot fix (10.1C04p2) for this issue on AIX 64 bit.