Kbase P148669: SQL-92: Query using CASE statement crashes with: "A server crash is likely.. (8933)"
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/09/2009 |
|
Status: Unverified
SYMPTOM(s):
Error: [DataDirect][OpenEdge JDBC Driver]A server crash is likely.. (8933)
Protrace reads:
PROGRESS stack trace as of Fri Jun 26 11:49:54 2009
command line not initialized
(1) ??() +0x830220d4 from: ??
(2) dbExit() +0x34 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(3) drExitOnTerm() +0x2a0 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(4) _setitimer() +0xb4 from: /usr/lib/sparcv9/libthread.so.1
(5) _sema_post() +0x530 from: /usr/lib/sparcv9/libthread.so.1
(6) _sema_post() +0x6f4 from: /usr/lib/sparcv9/libthread.so.1
(7) __1cNsql_qt_join_tJopt_joins6MpnOsql_qexpinfo_t_ppnLsql_qtree_t__i_() +0x628 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(8) __1cLsql_qtree_tJopt_joins6MpnOsql_qexpinfo_t_pp0_i_() +0x24 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(9) __1cLsql_qtree_tJopt_joins6MpnOsql_qexpinfo_t_pp0_i_() +0x24 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(10) __1cLsql_qtree_tJopt_joins6MpnOsql_qexpinfo_t_pp0_i_() +0x24 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(11) __1cNsql_qt_join_tJopt_joins6MpnOsql_qexpinfo_t_ppnLsql_qtree_t__i_() +0x628 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(12) __1cLsql_qtree_tJopt_joins6MpnOsql_qexpinfo_t_pp0_i_() +0x24 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(13) __1cLsql_qtree_tJopt_joins6MpnOsql_qexpinfo_t_pp0_i_() +0x24 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(14) __1cLsql_qtree_tJopt_joins6MpnOsql_qexpinfo_t_pp0_i_() +0x24 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(15) __1cLsql_qtree_tJopt_joins6MpnOsql_qexpinfo_t_pp0_i_() +0x24 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(16) __1cLsql_qtree_tJopt_joins6MpnOsql_qexpinfo_t_pp0_i_() +0x24 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(17) __1cNsql_qt_join_tJopt_joins6MpnOsql_qexpinfo_t_ppnLsql_qtree_t__i_() +0x628 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(18) __1cLsql_qtree_tJopt_joins6MpnOsql_qexpinfo_t_pp0_i_() +0x24 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(19) __1cLsql_qtree_tJopt_joins6MpnOsql_qexpinfo_t_pp0_i_() +0x24 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(20) __1cLsql_qtree_tJopt_joins6MpnOsql_qexpinfo_t_pp0_i_() +0x24 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(21) __1cLsql_qtree_tJopt_joins6MpnOsql_qexpinfo_t_pp0_i_() +0x24 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(22) __1cLsql_qtree_tJopt_joins6MpnOsql_qexpinfo_t_pp0_i_() +0x24 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(23) __1cOsql_qexpinfo_tMopt_optimize6MpnFsqlca_nKsql_stmt_t__i_() +0x578 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(24) __1cMsql_select_tMopt_optimize6MpnFsqlca__i_() +0x18 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(25) __1cJssm_env_tKbuild_tree6MrknRssm_user_name_tag_pknMsql_stmuid_t_Cpkcp7ppnQssm_stmtinfo_tag_pnFsqlca_pnKstmtTmpl_t__i_() +0x6bc from: /progress/
solaris/64bit/101c02/dlc/bin/_sqlsrv2
(26) __1cLssm_prepare6FpnJrds_env_t_pkcpnMsql_stmuid_t_Cp26pIpnFsqlca__i_() +0x37c from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(27) sql_fn() +0x2c4 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(28) __1cPprepare_reply_tPprocess_request6M_i_() +0x70 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
(29) __1cOserver_reply_tNexecute_reply6MppCpi_i_() +0x78 from: /progress/solaris/64bit/101c02/dlc/bin/_sqlsrv2
Database logfile reads:
[2009/06/26@11:50:22.713+1000] P-3119 T-1 I BROKER 0: (2526) Disconnecting client 24 of dead server 1.
[2009/06/26@11:50:22.726+1000] P-3119 T-1 I BROKER 0: (2252) Begin transaction backout.
[2009/06/26@11:50:22.726+1000] P-3119 T-1 I BROKER 0: (2253) Transaction backout completed.
[2009/06/26@11:50:22.727+1000] P-3119 T-1 I BROKER 0: (2525) Disconnecting dead server 1.
FACT(s) (Environment):
SQL query uses CASE expression
All Supported Operating Systems
NEGATED FACT(s) Environment):
OpenEdge 10.1C
OpenEdge 10.1C01 Service Pack
OpenEdge 10.1C02 Service Pack
OpenEdge 10.1C03 Service Pack
OpenEdge 10.2x
CAUSE:
CR# OE00186877
FIX:
Upgrade to OE10.2A02 or later