[
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: --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
> #13 0x0230840fc085 in ?? ()
> #14 0x7fb3bb1b4cea in ExScheduler::work (this=0x7fb36c90a9c8,
> prevWaitTime=0) at ../executor/ExScheduler.cpp:331
> #15 0x7fb3bb088cff in ex_root_tcb::oltExecute (this=0x7fb36c90bab8,
> glob=0x7fb36c928150, input_desc=0x7fb36c92d238, output_desc=0x0,
> diagsArea=@0x7fb3d4b19a98) at ../executor/ex_root.cpp:2166
> #16 0x7fb3ba8ff435 in CliStatement::doOltExecute (this=0x7fb36c9268d8,
> cliGlobals=0x7fb3ccbf3c30, input_desc=0x7fb36c92d238, output_desc=0x0,
> diagsArea=..., doNormalExecute=@0x7fb3d4b19bdc, reExecute=@0x7fb3d4b19bd8) at
> ../cli/Statement.cpp:5504
> #17 0x7fb3ba87ead6 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 0x7fb3ba87fef2 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 0x7fb3ba9133c9 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 0x7fb3c0f3b15a in EXECUTE (pSrvrStmt=0x7fb3cd04e1f0) at
> native/SqlInterface.cpp:1142
> #21 0x7fb3c0f361b6 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 0x7fb3c0f57a7e 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 0x7fb3c0f50451 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 0x7fb3c9012d98 in ?? ()
> #25 0x0002 in ?? ()
> #26 0x7fb3cd04e1f0 in ?? ()
> #27 0x 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
