Kbase P123086: SQL: server crashes with 'Socket closed.' and 'Server crash likely. ' errors executing a complex que
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/01/2009 |
|
Status: Verified
SYMPTOM(s):
SQL: server crashes with 'Socket closed' and 'Server crash likely. ' errors executing a complex query.
Errors generated by the ODBC client:
Error: Socket closed. (State:08S01, Native Code: 1D4F)
Error: Server crash likely. (State:S1000, Native Code: FFFFFFFC)
Query includes joins and unions and crashes the server if run more than one time. It executes without error the first time but crashes the server when executed a second time.
The server crash occurs and PROGRESS stack trace is generated when the query is executing using either ODBC or JDBC connections.
PROGRESS stack trace includes when executing with ODBC client:
dbut_uttraceback+0x88 from /usr/dlc/bin/_sqlsrv2
dbut_uttrace+0x12b from /usr/dlc/bin/_sqlsrv2
dbExit+0x2f from /usr/dlc/bin/_sqlsrv2
drSigFatal+0xc4 from /usr/dlc/bin/_sqlsrv2
_fini+0x8026ec8 from /lib/libnsl.so.1
xec_clear_rsshdls__14sql_qt_union_tP14sql_qexpinfo_t+0x66 from /usr/dlc/bin/_sqlsrv2
xec_clear_rsshdls__11sql_qtree_tP14sql_qexpinfo_t+0x1f from /usr/dlc/bin/_sqlsrv2
xec_clear_rsshdls__13sql_qt_sort_tP14sql_qexpinfo_t+0x19 from /usr/dlc/bin/_sqlsrv2
xec_clear_rsshdls__11sql_qtree_tP14sql_qexpinfo_t+0x1f from /usr/dlc/bin/_sqlsrv2
xec_clear_rsshdls__16sql_qt_project_tP14sql_qexpinfo_t+0x15 from /usr/dlc/bin/_sqlsrv2
xec_clear_rsshdls__11sql_qtree_tP14sql_qexpinfo_t+0x37 from /usr/dlc/bin/_sqlsrv2
xec_clear_rsshdls__14sql_qt_union_tP14sql_qexpinfo_t+0x15 from /usr/dlc/bin/_sqlsrv2
xec_clear_rsshdls__11sql_qtree_tP14sql_qexpinfo_t+0x1f from /usr/dlc/bin/_sqlsrv2
xec_clear_rsshdls__13sql_qt_sort_tP14sql_qexpinfo_t+0x19 from /usr/dlc/bin/_sqlsrv2
xec_clear_rsshdls__11sql_qtree_tP14sql_qexpinfo_t+0x1f from /usr/dlc/bin/_sqlsrv2
xec_clear_rsshdls__16sql_qt_project_tP14sql_qexpinfo_t+0x15 from /usr/dlc/bin/_sqlsrv2
xec_clear_rsshdls__11sql_qtree_tP14sql_qexpinfo_t+0x37 from /usr/dlc/bin/_sqlsrv2
xec_clear_rsshdls__14sql_qt_union_tP14sql_qexpinfo_t+0x15 from /usr/dlc/bin/_sqlsrv2
xec_clear_rsshdls__11sql_qtree_tP14sql_qexpinfo_t+0x1f from /usr/dlc/bin/_sqlsrv2
xec_clear_rsshdls__13sql_qt_sort_tP14sql_qexpinfo_t+0x19 from /usr/dlc/bin/_sqlsrv2
xec_clear_rsshdls__11sql_qtree_tP14sql_qexpinfo_t+0x1f from /usr/dlc/bin/_sqlsrv2
xec_clear_rsshdls__16sql_qt_project_tP14sql_qexpinfo_t+0x15 from /usr/dlc/bin/_sqlsrv2
xec_clear_rsshdls__12sql_select_t+0x34 from /usr/dlc/bin/_sqlsrv2
ssm_prepare__FP9rds_env_tPCcP12sql_stmuid_tUcT1PUlP5sqlca+0x740 from /usr/dlc/bin/_sqlsrv2
sql_fn+0x234 from /usr/dlc/bin/_sqlsrv2
process_request__15prepare_reply_t+0xb5 from /usr/dlc/bin/_sqlsrv2
execute_reply__14server_reply_tPPUcPl+0x71 from /usr/dlc/bin/_sqlsrv2
execute__15prepare_reply_tPUcPPUcPlT311sqlm_type_t+0x3c from /usr/dlc/bin/_sqlsrv2
dsn_listen_10__12srv_nw_hdl_tlPvP10svr_args_t+0x454 from /usr/dlc/bin/_sqlsrv2
dmn_main+0xd1 from /usr/dlc/bin/_sqlsrv2
run_sql_thread__FPv+0x88 from /usr/dlc/bin/_sqlsrv2
start_thread+0x81 from /lib/tls/libpthread.so.0
PROGRESS stack trace includes when executing with JDBC client:
Exception code: C0000005 ACCESS_VIOLATION
Fault address: 00000002 00:00000000
Registers:
EAX:00D1D42C
EBX:028885F0
ECX:00D1D4FC
EDX:00000145
ESI:028343C0
EDI:0288A70C
CS:EIP:001B:00000002
SS:ESP:0023:026FEFB4 EBP:0288A70C
DS:0023 ES:0023 FS:003B GS:0000
Flags:00010206
Call Stack:
Address Frame
00000002 026FEFB0 0000:00000000
004BAF63 0288A70C tpe_validate+19D23
FACT(s) (Environment):
OpenEdge 10.1A
OpenEdge 10.1B
All Supported Operating Systems
CAUSE:
Bug# OE00148697
FIX:
Upgrade to OpenEdge 10.1C or later