Kbase P124536: AppServer becomes runaway and consumes CPU
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/8/2008 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
AppServer Agent becomes runaway
AppServer Agent consumes many CPU cycles
AppServer is running a poor performance query
Connection between client an AppServer drops while AppServer is processing a request to REPOSITION this query
WHERE and BY conditions of the query mean it can use an index, instead of building a result set on the AppServer
AppServer Agent status is CONNECTED
AppServer connection mode is state-reset
CAUSE:
This is a Known issue.
FIX:
Add a INDEXED-REPOSITION to the query to improve the query performance.