You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:15:14 UTC

[jira] [Created] (TRAFODION-211) LP Bug: 1301514 - JDBC T2: Multithreaded test fails with core

Alice Chen created TRAFODION-211:
------------------------------------

             Summary: 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: justin.du@hp.com
            Priority: Critical


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)