Kbase P129472: _SQLSRV2 dies when executing multi-join query in OpenEdge 10.1B and 10.1C
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/11/2009 |
|
Status: Verified
SYMPTOM(s):
_SQLSRV2.EXE crashes when executing multi-join query
SQL .TRC file contains PANIC error
: PANIC - XEC sort::psr_copy psr_addttbl failed PID <PID>
SQL Query Tool executing statement returns such details as:
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed.
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Server crash likely.
SQLFreeStmt Failed!
Database log file contains:
[YYYY/MM/DD@HH:MM:SS.296+0100] P-1048 T-2632 I BROKER 0: (2526) Disconnecting client 24 of dead server 1.
[YYYY/MM/DD@HH:MM:SS.296+0100] P-1048 T-2632 I BROKER 0: (2252) Begin transaction backout.
[YYYY/MM/DD@HH:MM:SS.296+0100] P-1048 T-2632 I BROKER 0: (2253) Transaction backout completed.
[YYYY/MM/DD@HH:MM:SS.296+0100] P-1048 T-2632 I BROKER 0: (2525) Disconnecting dead server 1.
No protrace file is created
FACT(s) (Environment):
OpenEdge 10.1B
OpenEdge 10.1C
OpenEdge 10.1B03 32-bit Service Pack
CAUSE:
Bug# OE00166077
FIX:
Upgrade to OpenEdge 10.1C01 or OpenEdge 10.2A