[ 
https://issues.apache.org/jira/browse/TRAFODION-939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15282278#comment-15282278
 ] 

Prashanth Vasudev commented on TRAFODION-939:
---------------------------------------------

Jira TRAFODION-1798 addresses this issue. Please verify and close.

Thanks,
Prashanth

> LP Bug: 1413831 - Phoenix tests run into several error 8810 when other tests 
> are run in parallel with it
> --------------------------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-939
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-939
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-exe
>            Reporter: Aruna Sadashiva
>            Assignee: Prashanth Vasudev
>            Priority: Critical
>             Fix For: 2.1-incubating
>
>
> Running phoenix and jdbc catalog api tests at the same time resulted in 16 
> failures in phoenix with error 8810, during ddl operations as shown below. 
> All the jdbc catalog api tests passed. 
> Phoenix runs fine when no other tests are running on the system. 
> test.java.com.hp.phoenix.end2end.ToNumberFunctionTest
> ....*** ERROR[8810] Executor ran into an internal failure and returned an 
> error without populating the diagnostics area. This error is being injected 
> to indicate that. [2015-01-22 08:32:31]
> E.E.............
> Time: 701.811
> There were 2 failures:
> 1) 
> testKeyProjectionWithIntegerValue(test.java.com.hp.phoenix.end2end.ToNumberFunctionTest)
> java.lang.AssertionError: Failed to drop object: table TO_NUMBER_TABLE
>       at org.junit.Assert.fail(Assert.java:88)
>       at 
> test.java.com.hp.phoenix.end2end.BaseTest.dropTestObjects(BaseTest.java:180)
>       at 
> test.java.com.hp.phoenix.end2end.BaseTest.doBaseTestCleanup(BaseTest.java:112)
> On Justin's sugegstion, added ABORT_ON_ERROR for 8810 and the core has this 
> stack:
> #0  0x00007ffff4a458a5 in raise () from /lib64/libc.so.6
> #1  0x00007ffff4a4700d in abort () from /lib64/libc.so.6
> #2  0x00007ffff1248114 in ComCondition::setSQLCODE (
>     this=<value optimized out>, newSQLCODE=-8810)
>     at ../export/ComDiags.cpp:1425
> #3  0x00007ffff3f66e36 in operator<< (d=..., dgObj=...)
>     at ../common/DgBaseType.cpp:138
> #4  0x00007ffff437e4e3 in CliStatement::fetch (this=<value optimized out>, 
>     cliGlobals=0xeeade0, output_desc=<value optimized out>, diagsArea=..., 
>     newOperation=1) at ../cli/Statement.cpp:5310
> #5  0x00007ffff4324e0f 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=0xeeade0, tasks=8063, 
>     statement_id=0x1fbea88, input_descriptor=0x1fbeab8, 
> output_descriptor=0x0, 
>     num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffe41ef030, 
>     input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3382
> #6  0x00007ffff438a40b in SQL_EXEC_ClearExecFetchClose (
>     statement_id=0x1fbea88, input_descriptor=0x1fbeab8, 
> output_descriptor=0x0, 
>     num_input_ptr_pairs=0, num_output_ptr_pairs=0, num_total_ptr_pairs=0)
>     at ../cli/CliExtern.cpp:2627
> #7  0x00007ffff68703bf in SRVR::WSQL_EXEC_ClearExecFetchClose (
>     statement_id=0x1fbea88, input_descriptor=<value optimized out>, 
>     output_descriptor=<value optimized out>, 
>     num_input_ptr_pairs=<value optimized out>, 
>     num_output_ptr_pairs=<value optimized out>, 
>     num_total_ptr_pairs=<value optimized out>) at SQLWrapper.cpp:459
> #8  0x00007ffff6866cff in SRVR::EXECUTE2 (pSrvrStmt=0x1fbe470)
>     at sqlinterface.cpp:5520
> #9  0x00007ffff689733e in odbc_SQLSvc_Execute2_sme_ (
>     objtag_=<value optimized out>, call_id_=<value optimized out>, 
>     dialogueId=<value optimized out>, sqlAsyncEnable=<value optimized out>, 
> ---Type <return> to continue, or q <return> to quit---
>     queryTimeout=<value optimized out>, inputRowCnt=<value optimized out>, 
>     sqlStmtType=128, stmtHandle=33285232, cursorLength=0, cursorName=0x0, 
>     cursorCharset=1, holdableCursor=0, inValuesLength=0, inValues=0x0, 
>     returnCode=0x7fffe41ef928, sqlWarningOrErrorLength=0x7fffe41ef924, 
>     sqlWarningOrError=@0x7fffe41ef900, rowsAffected=0x7fffe41ef920, 
>     outValuesLength=0x7fffe41ef914, outValues=@0x7fffe41ef8f8)
>     at srvrothers.cpp:1517
> #10 0x00000000004cbc42 in odbc_SQLSrvr_ExecDirect_ame_ (objtag_=0x24a84d0, 
>     call_id_=0x24a8528, dialogueId=1492150530, 
>     stmtLabel=<value optimized out>, cursorName=0x0, 
>     stmtExplainLabel=<value optimized out>, stmtType=0, sqlStmtType=128, 
>     sqlString=0x2d43ea4 "drop table PRODUCT_METRICS cascade", 
>     sqlAsyncEnable=0, queryTimeout=0, inputRowCnt=0, txnID=0, 
> holdableCursor=0)
>     at SrvrConnect.cpp:7636
> #11 0x0000000000494086 in SQLEXECUTE_IOMessage (objtag_=0x24a84d0, 
>     call_id_=0x24a8528, operation_id=3012) at Interface/odbcs_srvr.cpp:1734
> #12 0x0000000000494134 in DISPATCH_TCPIPRequest (objtag_=0x24a84d0, 
>     call_id_=0x24a8528, operation_id=<value optimized out>)
>     at Interface/odbcs_srvr.cpp:1799
> #13 0x0000000000433822 in BUILD_TCPIP_REQUEST (pnode=0x24a84d0)
>     at ../Common/TCPIPSystemSrvr.cpp:603
> #14 0x00000000004341bd in PROCESS_TCPIP_REQUEST (pnode=0x24a84d0)
>     at ../Common/TCPIPSystemSrvr.cpp:581
> #15 0x0000000000462396 in CNSKListenerSrvr::tcpip_listener (arg=0xda6310)
>     at Interface/linux/Listener_srvr_ps.cpp:397
> #16 0x00007ffff47f9290 in sb_thread_sthr_disp (pp_arg=0xeb5490)
>     at threadl.cpp:253
> #17 0x00007ffff45c5851 in start_thread () from /lib64/libpthread.so.0
> #18 0x00007ffff4afb90d in clone () from /lib64/libc.so.6
> (gdb)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to