[
https://issues.apache.org/jira/browse/TRAFODION-211?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14698001#comment-14698001
]
Atanu Mishra commented on TRAFODION-211:
----------------------------------------
Justin Du (justin-du-2) wrote on 2014-05-09: #2
The code changes needed to fix the core problem are checked into the datalake
branch, revision 40304.
This multi-threaded test would still have failure with SQL error:
java.sql.SQLException: *** ERROR[8813] Trying to fetch from a statement that is
in the closed state.
But that would be a different issue.
Justin Du (justin-du-2) on 2014-05-09
Changed in trafodion:
status: In Progress → Fix Committed
Stacey Johnson (sjohnson-w) on 2014-06-10
information type: Proprietary → Public
Aruna Sadashiva (aruna-sadashiva) on 2014-06-10
Changed in trafodion:
status: Fix Committed → Fix Released
> LP Bug: 1301514 - JDBC T2: Multithreaded test fails with core
> -------------------------------------------------------------
>
> Key: TRAFODION-211
> URL: https://issues.apache.org/jira/browse/TRAFODION-211
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: Aruna Sadashiva
> Assignee: [email protected]
> Priority: Critical
> Fix For: 1.0 (pre-incubation)
>
>
> Multithreaded JDBC test app creates a core when run with T2 driver, it works
> ok with T4 driver. The test creates 3 threads, one insert and 2 selects on
> the same table.
> info from emails:
> This build is based on 38655 revision of datalake
> FYI, here is the core stack:
> (gdb) bt
> #0 0x000000352cc328a5 in raise () from /lib64/libc.so.6
> #1 0x000000352cc34085 in abort () from /lib64/libc.so.6
> #2 0x00007ffff73d5865 in os::abort(bool) ()
> from /opt/home/tools/jdk1.7.0_21_64/jre/lib/amd64/server/libjvm.so
> #3 0x00007ffff7535b77 in VMError::report_and_die() ()
> from /opt/home/tools/jdk1.7.0_21_64/jre/lib/amd64/server/libjvm.so
> #4 0x00007ffff73d9370 in JVM_handle_linux_signal ()
> from /opt/home/tools/jdk1.7.0_21_64/jre/lib/amd64/server/libjvm.so
> #5 <signal handler called>
> #6 0x00007fffd822b622 in QueryAnalysis::dontSurfTheWave (this=0x7fffcf6225c8)
> at ../optimizer/Analyzer.h:538
> #7 0x00007fffd87cc811 in GroupByTernarySplitRule::isContextSensitive (
> this=0x7fffcf678ab0) at ../optimizer/TransRule.cpp:4146
> #8 0x00007fffd87280bc in RuleSet::insert (this=0x7fffcf71ea68,
> r=0x7fffcf678ab0) at ../optimizer/Rule.cpp:440
> #9 0x00007fffd87c15df in CreateTransformationRules ()
> at ../optimizer/TransRule.cpp:601
> #10 0x00007fffd8726f65 in InitRuleSet () at ../optimizer/Rule.cpp:50
> #11 0x00007fffdee65a80 in CmpContext::CmpContext (this=0x7fffcf6ed090, f=1, h=
> 0x7fffd0f98ac0) at ../arkcmp/CmpContext.cpp:228
> #12 0x00007fffdf0af2fc in arkcmp_main_entry ()
> at ../common/arkcmp_proc.cpp:167
> #13 0x00007fffddb735e5 in CliStatement::prepare2 (this=0x7fffd0f8c928,
> source=0x7fffd0f8e0c8 "CONTROL QUERY DEFAULT JDBC_PROCESS 'TRUE'",
> diagsArea=..., passed_gen_code=0x0, passed_gen_code_len=0, charset=15,
> unpackTdbs=1, cliFlags=144) at ../cli/Statement.cpp:1515
> #14 0x00007fffddb730f0 in CliStatement::prepare (this=0x7fffd0f8c928,
> source=0x7fffd0f8e0c8 "CONTROL QUERY DEFAULT JDBC_PROCESS 'TRUE'",
> diagsArea=..., passed_gen_code=0x0, passed_gen_code_len=0, charset=15,
> unpackTdbs=1, cliFlags=144) at ../cli/Statement.cpp:1373
> #15 0x00007fffddb290e6 in SQLCLI_Prepare (cliGlobals=0x117ab60,
> statement_id=0x1c27440, sql_source=0x7fffcfd75bf0) at ../cli/Cli.cpp:5831
> #16 0x00007fffddb92f0c in SQL_EXEC_Prepare (statement_id=0x1c27440,
> sql_source=0x7fffcfd75bf0) at ../cli/CliExtern.cpp:4846
> #17 0x00007fffdfe257a1 in PREPARE (pSrvrStmt=0x1c26e30)
> at native/SqlInterface.cpp:1452
> #18 0x00007fffdfe20421 in SRVR_STMT_HDL::Prepare (this=0x1c26e30,
> inSqlString=0x7fffcfd76370, inStmtType=1, inHoldability=0,
> inQueryTimeout=0, isISUD=false) at native/CSrvrStmt.cpp:152
> #19 0x00007fffdfe20c6e in SRVR_STMT_HDL::ExecDirect (this=0x1c26e30,
> inCursorName=0x0, inSqlString=0x7fffcfd76370, inStmtType=1,
> inSqlStmtType=0, inHoldability=0, inQueryTimeout=0)
> at native/CSrvrStmt.cpp:374
> #20 0x00007fffdfe3ff04 in odbc_SQLSvc_SetConnectionOption_sme_ (objtag_=0x0,
> call_id_=0x0, exception_=0x7fffcfd76420, dialogueId=20006400,
> connectionOption=1009, optionValueNum=0, optionValueStr=0x0,
> sqlWarning=0x7fffcfd76440) at native/SrvrOthers.cpp:1170
> #21 0x00007fffdfe3582d in Java_org_trafodion_sql_SQLMXConnection_connectInit (
> jenv=0x76d1d8, jobj=0x7fffcfd765e8, server=0x0, dialogueId=20006400,
> catalog=0x0, schema=0x0, mploc=0x0, isReadOnly=0 '\000',
> transactionIsolation=2, loginTimeout=0, queryTimeout=0,
> modulecaching=0x7fffcfd76590, compiledmodulelocation=0x7fffcfd76588,
> blnDoomUsrTxn=0 '\000') at native/SQLMXConnection.cpp:437
> #22 0x00007ffff3318f90 in ?? ()
> #23 0x0000000000000000 in ?? ()
> This is on sq154.houston.hp.com/squser2/redhat06
> /opt/home/squser2/aruna/traf/jdbc/tests> java -Dprop=t2prop MTtest
> ===thread0===
> ===thread0===
> ===thread0===
> >>>>>>>>
> java.sql.SQLException: *** ERROR[8813] Trying to fetch from a statement that
> is in the closed state.
> >>>>>>>>
> >>>>>>>>
> java.sql.SQLException: *** ERROR[8813] Trying to fetch from a statement that
> is in the closed state.
> >>>>>>>>
> ===thread1===
> ===thread1===
> #
> # A fatal error has been detected by the Java Runtime Environment:
> #
> # SIGSEGV (0xb) at pc=0x00007fffd822b622, pid=26341, tid=140736680392448
> #
> # JRE version: 7.0_21-b11
> # Java VM: Java HotSpot(TM) 64-Bit Server VM (23.21-b01 mixed mode
> linux-amd64 compressed oops)
> # Problematic frame:
> # C [liboptimizer.so+0x4a8622] QueryAnalysis::dontSurfTheWave()+0xc
> #
> # Core dump written. Default location:
> /opt/home/squser2/aruna/traf/jdbc/tests/core or core.26341
> #
> # An error report file with more information is saved as:
> # /opt/home/squser2/aruna/traf/jdbc/tests/hs_err_pid26341.log
> #
> # If you would like to submit a bug report, please visit:
> # http://bugreport.sun.com/bugreport/crash.jsp
> # The crash happened outside the Java Virtual Machine in native code.
> # See problematic frame for where to report the bug.
> #
> Aborted (core dumped)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
