[jira] [Created] (TRAFODION-223) LP Bug: 1306259 - Query plan executing query cache ISP sent to wrong tdm_arkcmp

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-223:
------------------------------------

             Summary: LP Bug: 1306259 - Query plan executing query cache ISP sent to wrong tdm_arkcmp
                 Key: TRAFODION-223
                 URL: https://issues.apache.org/jira/browse/TRAFODION-223
             Project: Apache Trafodion
          Issue Type: Bug
            Reporter: Qifan Chen
            Assignee: Howard Qin
            Priority: Critical
             Fix For: 1.0 (pre-incubation)


. When executing a plan against a virtual table implemented via ISP, 
CLI does not send the request to the embedded compiler. 
2. Instead, the request is sent to the remote TDM_ARKCMP process. 
3. This leads to confusion about which query cache one is under examination.
4. possible fix: 
	store the location of the cmp-instance inside the plan and send the plan to the right compile instance. 
	we also need a 
  



Breakpoint 1, QueryCacheEntriesStoredProcedure::sp_Process (
    action=SP_PROC_OPEN, inputData=0x7fff9f698fb0, eFunc=
    0x7ffff3f9f3a4 <CmpSPExtractFunc_(int, void*, int, void*, int)>,
    outputData=0x7fff9f699048,
    fFunc=0x7ffff3f9f45b <CmpSPFormatFunc_(int, void*, int, void*, int)>,
    spProcHandle=0x7fff9f693158, error=0x7fff9f693160)
    at ../arkcmp/QueryCacheSt.cpp:250
250       switch (action) {
(gdb) bt
#0  QueryCacheEntriesStoredProcedure::sp_Process (action=SP_PROC_OPEN,
    inputData=0x7fff9f698fb0,
    eFunc=0x7ffff3f9f3a4 <CmpSPExtractFunc_(int, void*, int, void*, int)>,
    outputData=0x7fff9f699048,
    fFunc=0x7ffff3f9f45b <CmpSPFormatFunc_(int, void*, int, void*, int)>,
    spProcHandle=0x7fff9f693158, error=0x7fff9f693160)
    at ../arkcmp/QueryCacheSt.cpp:250
#1  0x00007ffff3faca88 in CmpInternalSP::open (this=0x7fff9f692cc8, data=...)
    at ../arkcmp/CmpStoredProc.cpp:1089
#2  0x00007ffff3fa7837 in CmpStatementISP::process (this=0x7fff9f66d9f0, isp=
    ...) at ../arkcmp/CmpStatement.cpp:1648
#3  0x00007ffff3f94787 in ExCmpMessage::actOnReceive (this=0x7fffffffc350)
    at ../arkcmp/CmpConnection.cpp:545
#4  0x00007ffff72d743d in IpcMessageStream::internalActOnReceive (
    this=0x7fffffffc350, buffer=0x1734260, connection=0xbc2ec0)
    at ../common/Ipc.cpp:3787
#5  0x00007ffff72d5363 in IpcMessageBuffer::callReceiveCallback (
    this=0x1734260, conn=0xbc2ec0) at ../common/Ipc.cpp:2654
#6  0x00007ffff72e944c in GuaConnectionToClient::acceptBuffer (this=0xbc2ec0,
    buffer=0x113f6c0, receivedDataLength=3576) at ../common/IpcGuardian.cpp:2880
#7  0x00007ffff72eae63 in GuaReceiveControlConnection::wait (this=0xbb26f0,
    timeout=-1, eventConsumed=0x0, ipcAwaitiox=0x0)
    at ../common/IpcGuardian.cpp:3834
#8  0x00007ffff72e886a in GuaConnectionToClient::wait (this=0xbc2ec0,
    timeout=-1, eventConsumed=0x0, ipcAwaitiox=0x0)
    at ../common/IpcGuardian.cpp:2518
#9  0x00007ffff72d37f5 in IpcSetOfConnections::waitOnSet (this=0x7fffffffc4f0,
---Type <return> to continue, or q <return> to quit---
    timeout=-1, calledByESP=0, timedout=0x0) at ../common/Ipc.cpp:1854
#10 0x00007ffff72d6a83 in IpcMessageStream::waitOnMsgStream (
    this=0x7fffffffc350, timeout=-1) at ../common/Ipc.cpp:3502
#11 0x00007ffff72d69f1 in IpcMessageStream::receive (this=0x7fffffffc350,
    waited=1) at ../common/Ipc.cpp:3484
#12 0x0000000000407ad7 in main (argc=2, argv=0x7fffffffcae8)
    at ../bin/arkcmp.cpp:745



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