Kbase P90913: _sqlsrv2 memory violates and database periodically shutsdown
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/16/2005 |
|
Status: Verified
SYMPTOM(s):
_sqlsrv2 process memory violates
SYSTEM ERROR: Memory violation. (49)
Stack trace from _sqlsrv2 reads:
opt_gen_idx_canddts__FP14sql_qexpinfo_tP11sql_qtree_tiP14sql_predlist_tPPvT3UcT7PP13sql_idxlist_t
opt_get_tidpred__14sql_et_relop_tFP14sql_qexpinfo_tP11sql_qtree_tP13sql_tblinfo_tPPviP15tid_optinfo_tag
opt_get_tidpred__14sql_et_logop_tFP14sql_qexpinfo_tP11sql_qtree_tP13sql_tblinfo_tPPviP15tid_optinfo_tag
opt_tid_for_restricts__17sql_qt_restrict_tFP14sql_qexpinfo_tPP11sql_qtree_t
_sqlsrv2 process terminates with 2526 errors.
Disconnecting client <number> of dead server <number>. (2526)
The database broker process starts backing out the transactions associated with the dead server.
Begin transaction backout. (2252)
Transaction backout completed. (2253)
Sometimes the broker process detects the dead server and issues an 1153 error
BROKER detects death of server <pid>. (1153)
Database may abnormally shut down as a result of the 2252 and 2253 errors if the dead server was holding a shared memory resource at the time of the failure.
CAUSE:
Bug# 20040518-029
FIX:
Upgrade to 9.1E.
Upgrade to 10.0B