Kbase P132217: AppServer becomes runaway and consumes CPU running a poor performance query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/07/2008 |
|
Status: Unverified
SYMPTOM(s):
AppServer becomes runaway and consumes CPU running a poor performance query
AppServer Agent consumes many CPU cycles
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
FACT(s) (Environment):
AppServer connection mode is state-reset
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
Bug# OE00152748
FIX:
Upgrade to OpenEdge 10.1B03, 10.1C or later.
As a workaround, add an INDEXED-REPOSITION to the query to improve the query performance.