Consultor Eletrônico



Kbase P83443: SQL92 remote server process receives a memory violation error associated with sortrec_get_hash__10nv
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   18/01/2005
Status: Verified

FACT(s) (Environment):

Progress 9.1D
Progress 9.1D 64-bit

SYMPTOM(s):

_sqlsrv2 process Memory violates when running a SQL application

SYSTEM ERROR: Memory violation. (49)

Stack trace from _sqlsrv2 reads:
sortrec_get_hash__10nvarchar_tFPvRUiT2
get_first_slot__10mm_ihtbl_tFR9mm_elem_tRUiT2
get_new_slot__10mm_ihtbl_tFRUiR9mm_elem_t
tpl_insert__10mm_ihtbl_tFRUiR10fldl_val_t

The database broker process starts cleaning up the remote clients connected to the dead server and backing out the transactions as necessary.

BROKER detects death of server <pid>. (1153)

Disconnecting client <number> of dead server <number>. (2526)

SQL query was performing a dynamic index join

Abnormal shutdown of database only occurs if the server was holding latches when it terminated.

CAUSE:

Bug# 20030211-009

CAUSE:

The varchar value was not correctly handling 0 length values in a sort record

FIX:

Upgrade to 9.1E.

Upgrade to 10.0A.