Kbase P124771: SQL-92: Server crash executing an SQL-92 query that uses an inequality operator
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/08/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1B01 32-bit Service Pack
All Supported Operating Systems
SYMPTOM(s):
SQL-92: Server crash executing an SQL-92 query that uses an inequality operator
The error on Linux:
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=0
[DataDirect][OpenEdge JDBC Driver]A server crash is likely.
[DataDirect][OpenEdge JDBC Driver]A server crash is likely.
The error on Windows XP:
=== SQL Exception 1 ===
SQLState=08S01
ErrorCode=0
[DataDirect][OpenEdge JDBC Driver]Connection reset
[DataDirect][OpenEdge JDBC Driver]Connection reset by peer: socket write error
No database connected. (8934)
Using the 'Not Equal' Relational Operator in any of its forms '!=", '<>' or '^=' crashes the SQL-92 server, generates a protrace file and throws the 'A server crash is likely.' error on Linux and a 'Connection reset by peer: socket write error No database connected. (8934)' error on Windows XP. Following is the texts of the error by platform:
PROGRESS stack trace on linux includes:
dbut_uttraceback+0x88 from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
dbut_uttrace+0x12b from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
dbExit+0x33 from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
pthread_sighandler+0x9b from /lib/libpthread.so.0
__libc_sigaction+0x128 from /lib/libc.so.6
keyGetComponents+0x2c3 from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
ix_extract_fields__14stub_ix_scan_tP6dsmKeyUlUl+0xc6 from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
do_ix_scan_fetch__14stub_ix_scan_t9ix_oper_tP6dsmKeyP8dh_tid_t+0x400 from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
do_ix_scan_fetch_keybuf__14stub_ix_scan_t9ix_oper_tP8dh_tid_t+0x1e from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
ix_scan_fetch__14stub_ix_scan_t9ix_oper_tP10fldl_val_tT2P8dh_tid_t+0x5d from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
execute__15sql_ix_mfetch_tP14sql_qexpinfo_tP8dh_tid_t+0x18a from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
xec_do_idxscan__12sql_qt_tbl_tP14sql_qexpinfo_tUcRUc+0x83f from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
xec_execute__12sql_qt_tbl_tP14sql_qexpinfo_tRUc+0x1d9 from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
xec_execute__16sql_qt_project_tP14sql_qexpinfo_tRUc+0xc8 from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
xec_execute__17sql_qt_restrict_tP14sql_qexpinfo_tRUc+0x317 from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
xec_execute__16sql_qt_project_tP14sql_qexpinfo_tRUc+0xc8 from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
xec_execute__16sql_qt_project_tP14sql_qexpinfo_tRUc+0xc8 from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
xec_execute__12sql_select_tPCcP5sqlca+0xdc from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
ssm_fetch__FP9rds_env_tPCcP12sql_stmuid_tUcT1P5sqldaP5sqlca+0x2db from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
sql_fn+0x627 from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
process_request__13query_reply_t+0xf6 from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
execute_reply__14server_reply_tPPUcPl+0x74 from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
execute__13query_reply_tPUcPPUcPlT311sqlm_type_t+0x3c from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
dsn_listen_10__12srv_nw_hdl_tlPvP10svr_args_t+0x454 from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
dmn_main+0xd1 from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
run_sql_thread__FPv+0xb8 from /view/rdl101b_sp1_linuxx86/vobs_prgs/linuxx86/dlc/bin/_sqlsrv2
pthread_start_thread+0xf0 from /lib/libpthread.so.0
PROGRESS stack trace on Windows XP includes:
//=====================================================
PROGRESS stack trace as of Wed May 30 12:58:26 2007
//=====================================================
Exception code: C0000005 ACCESS_VIOLATION
Fault address: 10061A54 01:00060A54 C:\Progress\OpenEdge101B\bin\rocket.dll
Registers:
EAX:00000004
EBX:00000002
ECX:00000024
EDX:00000000
ESI:00D466B0
EDI:00000000
CS:EIP:001B:10061A54
SS:ESP:0023:0277D4A4 EBP:0277D4F0
DS:0023 ES:0023 FS:003B GS:0000
Flags:00010202
Call Stack:
Address Frame
10061A54 0277D4F0 fmaFeatureGetExtDef+1784
FFFFFFFF FFB523A4 0000:00000000
CAUSE:
Bug# OE00151690
CAUSE:
If SQL-92 uses an index scan, and all needed values are fetched from key itself, and some leading keys are not referenced, and one of the omitted keys is decimal, then the server may crash.
FIX:
Upgrade to OpenEdge 10.1B02