Kbase P97472: SQL query crashes the SQL-92 server with "mm_table_t::compare_tuple" panic
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/11/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
IBM AIX
SYMPTOM(s):
Certain SQL-92 queries crash the SQL-92 server with ErrorCode=-20211
Server not reachable or possible RPC error
SQL-92 server crashes with "mm_table_t::compare_tuple" panic.
MM exception - status = -16003
PANIC - TPEUTIL mm_table_t::compare_tuple both ptrs 0 PID 28720
CHANGE:
Increased the -SQLTempPgSize parameter to 100 or more.
CAUSE:
Bug# 20041102-002
CAUSE:
Bug# 20040220-010
CAUSE:
There is an underlying resource shortage of temp table buffers.
FIX:
Increase the startup parameter -SQLTempBuff to solve the resource shortage of temp table buffers.
To determine the appropriate setting for -SQLTempBuff divide the setting for -SQLTempPgSize by 8 and multiply that number by 1000. For example if -SQLTempPgSize is 256 then -SQLTempBuff needs to be 32000 ((256/8) * 1000 = 32000).