[
https://issues.apache.org/jira/browse/TRAFODION-223?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Atanu Mishra closed TRAFODION-223.
----------------------------------
Resolution: Fixed
Assignee: (was: Howard Qin)
> 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
> 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)
