Kbase P43476: Error 1153 occurs to an SQL92 server, creating a very large core file.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/25/2010 |
|
Status: Verified
SYMPTOM(s):
Error 1153 occurs to an SQL92 server, creating a very large core file.
BROKER detects death of server <pid>. (1153)
FACT(s) (Environment):
UNIX
Progress 9.1x
OpenEdge 10.x
CAUSE:
The client program that is running on that particular SQL92 Server process is not designed efficiently and is causing the server process to exceed the amount of memory available to it.
The process then crashes and generates a very large core file.
FIX:
Review the SQL code being run and improve the query that is causing this high memory usage.
Using the SQL command UPDATE STATISTICS could also help improve the query's index selection.