[ 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)