[
https://issues.apache.org/jira/browse/TRAFODION-1825?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on TRAFODION-1825 started by Anoop Sharma.
-----------------------------------------------
> Phoenix tests failure while running DescColumnSortOrderTest
> -----------------------------------------------------------
>
> Key: TRAFODION-1825
> URL: https://issues.apache.org/jira/browse/TRAFODION-1825
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Affects Versions: 2.0-incubating
> Environment: Daily builds starting from 2/9, possibly linked to
> changes in JIRA 1807.
> Reporter: Arvind Narain
> Assignee: Anoop Sharma
>
> Daily builds are failing while running Phoenix test DescColumnSortOrderTest
> for both T2 and T4 env.
> To simulate (for T4)
> ./phoenix_test.py --target=localhost:<port> --user=dontcare --pw=dontcare \
> --targettype=TR --javahome=$JAVA_HOME
> --jdbccp=$MY_SQROOT/export/lib/jdbcT4.jar --tests=DescColumnSortOrderTest
> Following is the core stack generated for T2:
> #12 <signal handler called>
> #13 0x00000230840fc085 in ?? ()
> #14 0x00007fb3bb1b4cea in ExScheduler::work (this=0x7fb36c90a9c8,
> prevWaitTime=0) at ../executor/ExScheduler.cpp:331
> #15 0x00007fb3bb088cff in ex_root_tcb::oltExecute (this=0x7fb36c90bab8,
> glob=0x7fb36c928150, input_desc=0x7fb36c92d238, output_desc=0x0,
> diagsArea=@0x7fb3d4b19a98) at ../executor/ex_root.cpp:2166
> #16 0x00007fb3ba8ff435 in CliStatement::doOltExecute (this=0x7fb36c9268d8,
> cliGlobals=0x7fb3ccbf3c30, input_desc=0x7fb36c92d238, output_desc=0x0,
> diagsArea=..., doNormalExecute=@0x7fb3d4b19bdc, reExecute=@0x7fb3d4b19bd8) at
> ../cli/Statement.cpp:5504
> #17 0x00007fb3ba87ead6 in SQLCLI_PerformTasks(CliGlobals *, ULng32,
> SQLSTMT_ID *, SQLDESC_ID *, SQLDESC_ID *, Lng32, Lng32, typedef __va_list_tag
> __va_list_tag *, SQLCLI_PTR_PAIRS *, SQLCLI_PTR_PAIRS *)
> (cliGlobals=0x7fb3ccbf3c30, tasks=8063, statement_id=0x7fb3cd04e800,
> input_descriptor=0x7fb3cd04e830, output_descriptor=0x0,
> num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fb3d4b19dd0,
> input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3257
> #18 0x00007fb3ba87fef2 in SQLCLI_ClearExecFetchClose(CliGlobals *, SQLSTMT_ID
> *, SQLDESC_ID *, SQLDESC_ID *, Lng32, Lng32, Lng32, typedef __va_list_tag
> __va_list_tag *, SQLCLI_PTR_PAIRS *, SQLCLI_PTR_PAIRS *)
> (cliGlobals=0x7fb3ccbf3c30, statement_id=0x7fb3cd04e800,
> input_descriptor=0x7fb3cd04e830, output_descriptor=0x0,
> num_input_ptr_pairs=0, num_output_ptr_pairs=0, num_total_ptr_pairs=0,
> ap=0x7fb3d4b19dd0, input_ptr_pairs=0x0, output_ptr_pairs=0x0) at
> ../cli/Cli.cpp:3788
> #19 0x00007fb3ba9133c9 in SQL_EXEC_ClearExecFetchClose
> (statement_id=0x7fb3cd04e800, input_descriptor=0x7fb3cd04e830,
> output_descriptor=0x0, num_input_ptr_pairs=0, num_output_ptr_pairs=0,
> num_total_ptr_pairs=0) at ../cli/CliExtern.cpp:2630
> #20 0x00007fb3c0f3b15a in EXECUTE (pSrvrStmt=0x7fb3cd04e1f0) at
> native/SqlInterface.cpp:1142
> #21 0x00007fb3c0f361b6 in SRVR_STMT_HDL::Execute (this=0x7fb3cd04e1f0,
> inCursorName=0x0, totalRowCount=1, inSqlStmtType=0,
> inValueList=0x7fb3d4b1a2b0, inSqlAsyncEnable=0, inQueryTimeout=0,
> outValueList=0x7fb3d4b1a2c0) at native/CSrvrStmt.cpp:260
> #22 0x00007fb3c0f57a7e in odbc_SQLSvc_ExecuteN_sme_ (objtag_=0x0,
> call_id_=0x0, exception_=0x7fb3d4b1a280, dialogueId=140410204143200,
> stmtId=140410215522800, cursorName=0x0, sqlStmtType=0, totalRowCount=1,
> inputValueList=0x7fb3d4b1a2b0, sqlAsyncEnable=0, queryTimeout=0,
> outputValueList=0x7fb3d4b1a2c0, sqlWarning=0x7fb3d4b1a2e0) at
> native/SrvrOthers.cpp:310
> #23 0x00007fb3c0f50451 in
> Java_org_trafodion_jdbc_t2_SQLMXPreparedStatement_execute
> (jenv=0x7fb3cc0089d8, jobj=0x7fb3d4b1a4d8, server=0x0,
> dialogueId=140410204143200, txid=0, autoCommit=1 '\001', txnMode=2,
> stmtId=140410215522800, cursorName=0x0, isSelect=0 '\000', paramRowCount=1,
> paramCount=2, paramValues=0x7fb3d4b1a470, queryTimeout=0, isAnyLob=0 '\000',
> iso88591Encoding=0x0, resultSet=0x0, contBatchOnError=0 '\000') at
> native/SQLMXPreparedStatement.cpp:365
> #24 0x00007fb3c9012d98 in ?? ()
> #25 0x0000000000000002 in ?? ()
> #26 0x00007fb3cd04e1f0 in ?? ()
> #27 0x0000000000000000 in ?? ()
> Similar stack seen for T4, though currently in daily builds the logs do not
> have the stack trace:
> Running test.java.org.trafodion.phoenix.end2end.DescColumnSortOrderTest
> test.java.org.trafodion.phoenix.end2end.DescColumnSortOrderTest
> Tests run: 32, Failures: 1, Errors: 8, Skipped: 0, Time elapsed: 308.115 sec
> <<< FAILURE! - in
> test.java.org.trafodion.phoenix.end2end.DescColumnSortOrderTest
> lessThanLeadingDescCompositePK(test.java.org.trafodion.phoenix.end2end.DescColumnSortOrderTest)
> Time elapsed: 3.121 sec <<< ERROR!
> org.trafodion.jdbc.t4.HPT4Exception: There was a problem reading from the
> server
> at
> org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.java:284)
> at org.trafodion.jdbc.t4.InputOutput.doIO(InputOutput.java:376)
> at
> org.trafodion.jdbc.t4.T4Connection.getReadBuffer(T4Connection.java:157)
> at org.trafodion.jdbc.t4.T4Statement.getReadBuffer(T4Statement.java:196)
> at org.trafodion.jdbc.t4.T4Statement.Execute(T4Statement.java:62)
> at
> org.trafodion.jdbc.t4.InterfaceStatement.execute(InterfaceStatement.java:1242)
> at
> org.trafodion.jdbc.t4.TrafT4PreparedStatement.execute(TrafT4PreparedStatement.java:2278)
> at
> org.trafodion.jdbc.t4.TrafT4PreparedStatement.execute(TrafT4PreparedStatement.java:239)
> at
> test.java.org.trafodion.phoenix.end2end.DescColumnSortOrderTest.runQueryTest(DescColumnSortOrderTest.java:513)
> at
> test.java.org.trafodion.phoenix.end2end.DescColumnSortOrderTest.runQueryTest(DescColumnSortOrderTest.java:475)
> at
> test.java.org.trafodion.phoenix.end2end.DescColumnSortOrderTest.lessThanLeadingDescCompositePK(DescColumnSortOrderTest.java:449)
> Stack trace from a workstation run:
> (gdb) bt
> #0 0x00007f539dfa8625 in raise () from /lib64/libc.so.6
> #1 0x00007f539dfa9d8d in abort () from /lib64/libc.so.6
> #2 0x00007f539f4ab785 in ?? ()
> from
> /usr/lib/jvm/java-1.7.0-openjdk-1.7.0.91.x86_64/jre/lib/amd64/server/libjvm.so
> #3 0x00007f539f61f03f in ?? ()
> from
> /usr/lib/jvm/java-1.7.0-openjdk-1.7.0.91.x86_64/jre/lib/amd64/server/libjvm.so
> #4 0x00007f539f4b0322 in JVM_handle_linux_signal ()
> from
> /usr/lib/jvm/java-1.7.0-openjdk-1.7.0.91.x86_64/jre/lib/amd64/server/libjvm.so
> #5 <signal handler called>
> #6 0x00007f539c134cc8 in ExScheduler::work (this=0x7f53895a2118,
> prevWaitTime=
> 0) at ../executor/ExScheduler.cpp:331
> #7 0x00007f539c008cdf in ex_root_tcb::oltExecute (this=0x7f53895a32e0, glob=
> 0x7f5375311ef8, input_desc=0x7f5375334af8, output_desc=0x0, diagsArea=
> @0x7f538aa566b8) at ../executor/ex_root.cpp:2166
> #8 0x00007f539d8af405 in CliStatement::doOltExecute (this=0x7f5375333ce8,
> cliGlobals=0x14160c0, input_desc=0x7f5375334af8, output_desc=0x0,
> diagsArea=..., doNormalExecute=@0x7f538aa567fc, reExecute=@0x7f538aa567f8)
> at ../cli/Statement.cpp:5504
> #9 0x00007f539d82eaa6 in SQLCLI_PerformTasks(CliGlobals *, ULng32,
> SQLSTMT_ID *, SQLDESC_ID *, SQLDESC_ID *, Lng32, Lng32, typedef __va_list_tag
> __va_list_tag ---Type <return> to continue, or q <return> to quit---
> *, SQLCLI_PTR_PAIRS *, SQLCLI_PTR_PAIRS *) (cliGlobals=0x14160c0, tasks=8063,
> statement_id=0x20257b8, input_descriptor=0x20257e8,
> output_descriptor=0x0,
> num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7f538aa569f0,
> input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3257
> #10 0x00007f539d82fec2 in SQLCLI_ClearExecFetchClose(CliGlobals *, SQLSTMT_ID
> *, SQLDESC_ID *, SQLDESC_ID *, Lng32, Lng32, Lng32, typedef __va_list_tag
> __va_list_tag *, SQLCLI_PTR_PAIRS *, SQLCLI_PTR_PAIRS *)
> (cliGlobals=0x14160c0,
> statement_id=0x20257b8, input_descriptor=0x20257e8,
> output_descriptor=0x0,
> num_input_ptr_pairs=0, num_output_ptr_pairs=0, num_total_ptr_pairs=0, ap=
> 0x7f538aa569f0, input_ptr_pairs=0x0, output_ptr_pairs=0x0)
> at ../cli/Cli.cpp:3788
> #11 0x00007f539d8c3399 in SQL_EXEC_ClearExecFetchClose (statement_id=
> 0x20257b8, input_descriptor=0x20257e8, output_descriptor=0x0,
> num_input_ptr_pairs=0, num_output_ptr_pairs=0, num_total_ptr_pairs=0)
> at ../cli/CliExtern.cpp:2630
> #12 0x00007f53a03b524f in SRVR::WSQL_EXEC_ClearExecFetchClose (statement_id=
> 0x20257b8, input_descriptor=0x20257e8, output_descriptor=0x0,
> num_input_ptr_pairs=0, num_output_ptr_pairs=0, num_total_ptr_pairs=0)
> at SQLWrapper.cpp:462
> #13 0x00007f53a039e845 in SRVR::EXECUTE2 (pSrvrStmt=0x20251a0)
> at sqlinterface.cpp:5578
> #14 0x00007f53a03f6083 in odbc_SQLSvc_Execute2_sme_ (objtag_=0x2dcc220,
> call_id_=0x2dcc278, dialogueId=1508593610, sqlAsyncEnable=0, queryTimeout=
> ---Type <return> to continue, or q <return> to quit---
> 0, inputRowCnt=1, sqlStmtType=256, stmtHandle=33706400, cursorLength=0,
> cursorName=0x0, cursorCharset=0, holdableCursor=0, inValuesLength=24,
> inValues=0x14152f1 "\001", returnCode=0x7f538aa5743c,
> sqlWarningOrErrorLength=0x7f538aa57438,
> sqlWarningOrError=@0x7f538aa57430,
> rowsAffected=0x7f538aa5742c, outValuesLength=0x7f538aa57428, outValues=
> @0x7f538aa57420) at srvrothers.cpp:1530
> #15 0x000000000058b8b7 in odbc_SQLSrvr_Execute2_ame_ (objtag_=0x2dcc220,
> call_id_=0x2dcc278, dialogueId=1508593610, sqlAsyncEnable=0, queryTimeout=
> 0, inputRowCnt=1, sqlStmtType=256, stmtHandle=33706400, cursorName=0x0,
> cursorCharset=0, inValuesLength=24, inValues=0x14152f1 "\001",
> sqlQueryType=0, outputDescLength=0, outputDesc=0x0, rowLength=0, txnID=0,
> holdableCursor=0) at SrvrConnect.cpp:8262
> ========
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
