[ https://issues.apache.org/jira/browse/TRAFODION-227?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Atanu Mishra closed TRAFODION-227. ---------------------------------- Resolution: Fixed Assignee: (was: Qifan Chen) Fix Version/s: 0.8 (pre-incubation) > LP Bug: 1308306 - Tdm_arkcmp cores when running Opencart queries > ---------------------------------------------------------------- > > Key: TRAFODION-227 > URL: https://issues.apache.org/jira/browse/TRAFODION-227 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp > Reporter: Weishiun Tsai > Priority: Critical > Fix For: 0.6 (pre-incubation), 0.8 (pre-incubation) > > > With the set of Opencart queries that Venkat ported over for Trafodion, they > generated lots of tdm_arkcmp cores. Opencart DDLs and DMLs have been ported > as part of the QA regression test. The select queries that caused the cores > did not return error messages, but running the entire set of Opencart queries > left about 166 of cores on the node. The core files can be found at the > $SQ_HOME directory of the node where mxosrvr runs. After the test is > started, one can check the DCS master-status page when the DMLs are running > to find out the connection node where the cores could be found. > This is seen on the beta v39140 build installed on the cluster centos-mapr1. > A typical stack trace of such core looks like the following. > (gdb) bt > #0 0x0000003db38328e5 in raise () from /lib64/libc.so.6 > #1 0x0000003db38340c5 in abort () from /lib64/libc.so.6 > #2 0x00007f0446b0a8b5 in ?? () > from /usr/lib/jvm/java/jre/lib/amd64/server/libjvm.so > #3 0x00007f0446c7878f in ?? () > from /usr/lib/jvm/java/jre/lib/amd64/server/libjvm.so > #4 0x00007f0446b0fa82 in JVM_handle_linux_signal () > from /usr/lib/jvm/java/jre/lib/amd64/server/libjvm.so > #5 <signal handler called> > #6 0x00007f044a417954 in > RangePartitionBoundaries::getOptimizedNumberOfPartKeys (this=<value optimized > out>) at ../optimizer/PartFunc.cpp:3158 > #7 0x00007f044a4293eb in > RangePartitioningFunction::createPartitioningFunctionForIndexDesc > (this=0x7f042ae87ec0, idesc=0x7f042ae3d4e0) > at ../optimizer/PartFunc.cpp:4152 > #8 0x00007f044a1b8e48 in IndexDesc::IndexDesc (this=0x7f042ae3d4e0, > tdesc=0x7f042ae36f50, fileSet=0x7f042ae88138, cmpContext=0x7f042ae88138) > at ../optimizer/IndexDesc.cpp:225 > #9 0x00007f044a09070e in createTableDesc2 (bindWA=<value optimized out>, > naTable=0x7f042ae7f0f8, corrName=..., hint=0x0) > at ../optimizer/BindRelExpr.cpp:1568 > #10 0x00007f044a091e7f in BindWA::createTableDesc (this=0x7fffd8cc4f80, > naTable=0x7f042ae7f0f8, corrName=..., catmanCollectUsages=0, > hint=<value optimized out>) at ../optimizer/BindRelExpr.cpp:1646 > #11 0x00007f044a0a5f87 in Scan::bindNode (this=0x7f042bcc2fa8, > bindWA=0x7fffd8cc4f80) at ../optimizer/BindRelExpr.cpp:6723 > #12 0x00007f044a07ce57 in RelExpr::bindChildren (this=0x7f042bcc3a20, > bindWA=0x7fffd8cc4f80) at ../optimizer/BindRelExpr.cpp:2164 > #13 0x00007f044a0b9ea1 in Join::bindNode (this=0x7f042bcc3a20, > bindWA=0x7fffd8cc4f80) at ../optimizer/BindRelExpr.cpp:2498 > #14 0x00007f044a07ce57 in RelExpr::bindChildren (this=0x7f042bccf1a8, > bindWA=0x7fffd8cc4f80) at ../optimizer/BindRelExpr.cpp:2164 > #15 0x00007f044a0b9ea1 in Join::bindNode (this=0x7f042bccf1a8, > bindWA=0x7fffd8cc4f80) at ../optimizer/BindRelExpr.cpp:2498 > #16 0x00007f044a07ce57 in RelExpr::bindChildren (this=0x7f042bcd3bf0, > bindWA=0x7fffd8cc4f80) at ../optimizer/BindRelExpr.cpp:2164 > #17 0x00007f044a0b7296 in RelRoot::bindNode (this=0x7f042bcd3bf0, > bindWA=0x7fffd8cc4f80) at ../optimizer/BindRelExpr.cpp:5001 > #18 0x00007f044ce6b524 in CmpMain::compile (this=0x7fffd8cc71b0, > input_str=0x7f042bcc7c28 "SELECT COUNT(DISTINCT p.product_id) AS total > FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON > (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id > = p.product_i"..., > charset=15, queryExpr=@0x7fffd8cc70e8, gen_code=0x7f042ae96b88, > gen_code_len=0x7f042ae96b80, heap=0x7f043e40adb8, phase=CmpMain::END, > fragmentDir=0x7fffd8cc7308, op=3004, useQueryCache=<value optimized out>, > cacheable=0x7fffd8cc70f8, begTime=0x7fffd8cc70d0, shouldLog=0) > at ../sqlcomp/CmpMain.cpp:1755 > #19 0x00007f044ce6de5e in CmpMain::sqlcomp (this=0x7fffd8cc71b0, > input_str=0x7f042bcc7c28 "SELECT COUNT(DISTINCT p.product_id) AS total > FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON > (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id > = p.product_i"..., > charset=15, queryExpr=@0x7fffd8cc70e8, gen_code=0x7f042ae96b88, > gen_code_len=0x7f042ae96b80, heap=0x7f043e40adb8, phase=CmpMain::END, > fragmentDir=0x7fffd8cc7308, op=3004, useQueryCache=1, > cacheable=0x7fffd8cc70f8, begTime=0x7fffd8cc70d0, shouldLog=0) > at ../sqlcomp/CmpMain.cpp:1425 > #20 0x00007f044ce6f039 in CmpMain::sqlcomp (this=0x7fffd8cc71b0, input=..., > gen_code=0x7f042ae96b88, gen_code_len=0x7f042ae96b80, heap=0x7f043e40adb8, > phase=CmpMain::END, fragmentDir=0x7fffd8cc7308, op=3004) > at ../sqlcomp/CmpMain.cpp:762 > #21 0x00007f044976849f in CmpStatement::process (this=0x7f042bce6ef8, > sqltext=<value optimized out>) at ../arkcmp/CmpStatement.cpp:474 > #22 0x00007f044975a825 in ExCmpMessage::actOnReceive (this=0x7fffd8cc8040) > at ../arkcmp/CmpConnection.cpp:348 > #23 0x00007f044c564f96 in IpcMessageStream::internalActOnReceive ( > this=0x7fffd8cc8040, buffer=<value optimized out>, connection=0x25f4030) > at ../common/Ipc.cpp:3541 > #24 0x00007f044c57bfeb in GuaConnectionToClient::acceptBuffer (this=0x25f4030, > buffer=<value optimized out>, receivedDataLength=<value optimized out>) > at ../common/IpcGuardian.cpp:2455 > #25 0x00007f044c57ccef in GuaReceiveControlConnection::wait (this=0x25e3860, > timeout=-1, eventConsumed=<value optimized out>, > ipcAwaitiox=0x7fffd8cc79f0) at ../common/IpcGuardian.cpp:3152 > #26 0x00007f044c57e0d2 in GuaConnectionToClient::wait (this=0x25f4030, > timeout=<value optimized out>, eventConsumed=0x0, ipcAwaitiox=0x0) > at ../common/IpcGuardian.cpp:2124 > #27 0x00007f044c5716ea in IpcSetOfConnections::waitOnSet (this=0x7fffd8cc81e0, > timeout=-1, calledByESP=0, timedout=0x0) at ../common/Ipc.cpp:1697 > #28 0x00007f044c57222d in IpcMessageStream::waitOnMsgStream ( > this=0x7fffd8cc8040, timeout=-1) at ../common/Ipc.cpp:3260 > #29 0x00007f044c572572 in IpcMessageStream::receive (this=0x7fffd8cc8040, > waited=1) at ../common/Ipc.cpp:3242 > #30 0x0000000000405c1a in main (argc=2, argv=0x7fffd8cc87b8) > at ../bin/arkcmp.cpp:341 > (gdb) -- This message was sent by Atlassian JIRA (v6.3.4#6332)