[ https://issues.apache.org/jira/browse/TRAFODION-2523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15906965#comment-15906965 ]
ASF GitHub Bot commented on TRAFODION-2523: ------------------------------------------- GitHub user prashanth-vasudev opened a pull request: https://github.com/apache/incubator-trafodion/pull/1006 [TRAFODION-2523] Fixes drop schema cascade memory corruption. You can merge this pull request into a Git repository by running: $ git pull https://github.com/prashanth-vasudev/incubator-trafodion traf2523 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/1006.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #1006 ---- commit b281c92336bde5985a032ef342047c8c01847163 Author: Prashanth Vasudev <vasudevp@edev11.esgyn.local> Date: 2017-03-04T04:08:16Z fix memory corruption caused by Int32 vs Int64 in executeImmediate calls. (cherry picked from commit dd2ad5c59c85882466c1c170e0edd6527a6d13a8) commit aff0f4991583e6cc663dc283ab58a0750c8b7c22 Author: Prashant Vasudev <prashanth.vasu...@esgyn.com> Date: 2017-03-04T12:45:36Z fix review comments. (cherry picked from commit 429f42604459874a1190d833fe9ec0e3666856d7) ---- > drop schema cascade causes a core dump. > --------------------------------------- > > Key: TRAFODION-2523 > URL: https://issues.apache.org/jira/browse/TRAFODION-2523 > Project: Apache Trafodion > Issue Type: Bug > Components: -exe > Affects Versions: 2.1-incubating > Reporter: Prashanth Vasudev > Assignee: Prashanth Vasudev > > drop schema cascade causes core as follows due to memory corruption. > (gdb) bt > #0 0x00007ff2996381d7 in raise () from /lib64/libc.so.6 > #1 0x00007ff299639a08 in abort () from /lib64/libc.so.6 > #2 0x00007ff29ae8edc9 in os::abort(bool) () > from > /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.121-0.b13.el7_3.x86_64/jre/lib/amd64/server/libjvm.so > #3 0x00007ff29b0306d6 in VMError::report_and_die() () > from > /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.121-0.b13.el7_3.x86_64/jre/lib/amd64/server/libjvm.so > #4 0x00007ff29ae98377 in JVM_handle_linux_signal () > from > /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.121-0.b13.el7_3.x86_64/jre/lib/amd64/server/libjvm.so > #5 0x00007ff29ae8c1e8 in signalHandler(int, siginfo_t*, void*) () > from > /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.121-0.b13.el7_3.x86_64/jre/lib/amd64/server/libjvm.so > #6 <signal handler called> > #7 operator= (ptr=..., this=0x7ff200000030) > at ../export/NAVersionedObject.h:542 > #8 Queue::position (this=0x7ff200000000) at ../comexe/ComQueue.cpp:201 > #9 0x00007ff297905bb7 in ExeCliInterface::initializeInfoList ( > this=this@entry=0x7ff286dafd20, infoList=@0x7ff286daf760: 0x7ff200000000, > infoListIsOutputInfo=infoListIsOutputInfo@entry=1) > at ../executor/ExExeUtilCli.cpp:1171 > #10 0x00007ff297905ceb in ExeCliInterface::fetchAllRows ( > this=this@entry=0x7ff286dafd20, infoList=@0x7ff286daf760: 0x7ff200000000, > query=query@entry=0x7ff286db07d0 "SELECT TRIM(object_name) FROM > TRAFODION.\"_MD_\".OBJECTS WHERE catalog_name = 'TRAFODION' AND schema_name = > 'DDL_TAB006' AND object_name <> '__SCHEMA__' AND object_type <> 'PK' FOR READ > COMMITTED ACCESS", inNumOutputEntries=inNumOutputEntries@entry=0, > varcharFormat=varcharFormat@entry=0, monitorThis=monitorThis@entry=0, > initInfoList=initInfoList@entry=1) at ../executor/ExExeUtilCli.cpp:1208 > #11 0x00007ff293f918e9 in CmpSeabaseDDL::dropSeabaseSchema ( > this=this@entry=0x7ff286db2c50, dropSchemaNode=0x7ff22490a9f8) > at ../sqlcomp/CmpSeabaseDDLschema.cpp:920 > #12 0x00007ff293f7709c in CmpSeabaseDDL::executeSeabaseDDL ( > this=this@entry=0x7ff286db2c50, ddlExpr=ddlExpr@entry=0x7ff22683a1e0, > ddlNode=ddlNode@entry=0x7ff22490a9f8, currCatName=..., currSchName=..., > dws=dws@entry=0x0) at ../sqlcomp/CmpSeabaseDDLcommon.cpp:9816 > #13 0x00007ff291c52009 in CmpStatement::process ( > this=this@entry=0x7ff21d70f2d0, statement=...) > at ../arkcmp/CmpStatement.cpp:925 > #14 0x00007ff291c41cc3 in CmpContext::compileDirect (this=0x7ff285434090, > data=data@entry=0x7ff214f52060 "p", data_len=data_len@entry=192, > outHeap=outHeap@entry=0x7ff29d3df128, charset=charset@entry=15, > op=op@entry=CmpMessageObj::PROCESSDDL, gen_code=@0x7ff286db3918: 0x0, > gen_code_len=@0x7ff286db3914: 0, parserFlags=parserFlags@entry=4194304, > parentQid=parentQid@entry=0x7ff214f51eb0 > "MXID11003051969212355246499642639000000004606U3333300_210988_SQL_CUR_57", > parentQidLen=parentQidLen@entry=71, > diagsArea=diagsArea@entry=0x7ff214f52128) at ../arkcmp/CmpContext.cpp:938 > #15 0x00007ff29788984c in ExDDLTcb::work (this=0x7ff29d3a3218) > at ../executor/ex_ddl.cpp:280 > #16 0x00007ff2979644cf in ExScheduler::work (this=0x7ff29d3a2d80, > prevWaitTime=prevWaitTime@entry=0) at ../executor/ExScheduler.cpp:331 > #17 0x00007ff2978cca32 in ex_root_tcb::execute (this=0x7ff29d3a4190, > cliGlobals=cliGlobals@entry=0x2c45f60, glob=0x7ff214f51a20, > input_desc=input_desc@entry=0x7ff29d375708, > diagsArea=@0x7ff286db3c58: 0x0, reExecute=reExecute@entry=0) > at ../executor/ex_root.cpp:1057 > #18 0x00007ff298f7b00a in CliStatement::execute ( > this=this@entry=0x7ff29d374d48, cliGlobals=cliGlobals@entry=0x2c45f60, > input_desc=input_desc@entry=0x7ff29d375708, diagsArea=..., > execute_state=<optimized out>, fixupOnly=fixupOnly@entry=0, > cliflags=cliflags@entry=0) at ../cli/Statement.cpp:3355 > #19 0x00007ff298f350cc 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=<optimized out>, > tasks=8063, statement_id=0x14eca6d8, input_descriptor=<optimized out>, > output_descriptor=<optimized out>, num_input_ptr_pairs=<optimized out>, > num_output_ptr_pairs=0, ap=0x7ff286db4ef8, input_ptr_pairs=0x0, > output_ptr_pairs=0x0) at ../cli/Cli.cpp:3293 > #20 0x00007ff298f82157 in SQL_EXEC_ClearExecFetchClose ( > statement_id=0x14eca6d8, input_descriptor=0x14eca708, > output_descriptor=0x0, num_input_ptr_pairs=0, num_output_ptr_pairs=0, > num_total_ptr_pairs=0) at ../cli/CliExtern.cpp:2649 > #21 0x00007ff29bdb4fce in SRVR::WSQL_EXEC_ClearExecFetchClose ( > statement_id=statement_id@entry=0x14eca6d8, > input_descriptor=input_descriptor@entry=0x14eca708, > output_descriptor=output_descriptor@entry=0x0, > num_input_ptr_pairs=num_input_ptr_pairs@entry=0, > num_output_ptr_pairs=num_output_ptr_pairs@entry=0, > num_total_ptr_pairs=num_total_ptr_pairs@entry=0) at SQLWrapper.cpp:462 > #22 0x00007ff29bdb2c08 in SRVR::EXECUTE2 > (pSrvrStmt=pSrvrStmt@entry=0x14eca0c0) > at sqlinterface.cpp:5732 > #23 0x00007ff29bdbceda in odbc_SQLSvc_Execute2_sme_ (objtag_=<optimized out>, > call_id_=<optimized out>, dialogueId=<optimized out>, > sqlAsyncEnable=<optimized out>, queryTimeout=<optimized out>, > inputRowCnt=<optimized out>, sqlStmtType=128, stmtHandle=351051968, > cursorLength=0, cursorName=0x0, cursorCharset=1, holdableCursor=0, > inValuesLength=0, inValues=0x0, returnCode=0x7ff286db5528, > sqlWarningOrErrorLength=0x7ff286db552c, > sqlWarningOrError=@0x7ff286db5548: 0x0, rowsAffected=0x7ff286db5530, > outValuesLength=0x7ff286db553c, outValues=@0x7ff286db5550: 0x0) > at srvrothers.cpp:1533 > #24 0x00000000004bff64 in odbc_SQLSrvr_ExecDirect_ame_ (objtag_=0x152686f0, > call_id_=0x15268748, dialogueId=<optimized out>, > stmtLabel=<optimized out>, cursorName=0x0, > stmtExplainLabel=<optimized out>, stmtType=0, sqlStmtType=128, > sqlString=0x14d1c264 "drop schema if exists trafodion.ddl_tab006 cascade", > sqlAsyncEnable=0, queryTimeout=0, inputRowCnt=0, txnID=0, > holdableCursor=0) > at SrvrConnect.cpp:8338 > #25 0x00000000004a5cc5 in SQLEXECUTE_IOMessage ( > objtag_=objtag_@entry=0x152686f0, call_id_=call_id_@entry=0x15268748, > operation_id=operation_id@entry=3012) at Interface/odbcs_srvr.cpp:1731 > #26 0x00000000004a602e in DISPATCH_TCPIPRequest ( > objtag_=objtag_@entry=0x152686f0, call_id_=call_id_@entry=0x15268748, > operation_id=operation_id@entry=3012) at Interface/odbcs_srvr.cpp:1796 > #27 0x00000000004912e2 in BUILD_TCPIP_REQUEST (pnode=pnode@entry=0x152686f0) > at ../Common/TCPIPSystemSrvr.cpp:606 > #28 0x000000000049199d in PROCESS_TCPIP_REQUEST (pnode=pnode@entry=0x152686f0) > at ../Common/TCPIPSystemSrvr.cpp:584 > #29 0x000000000049af6d in CNSKListenerSrvr::CheckTCPIPRequest ( > this=this@entry=0x2bba4e0, ipnode=ipnode@entry=0x152686f0) > at Interface/Listener_srvr.cpp:64 > #30 0x000000000049c0f1 in CNSKListenerSrvr::tcpip_listener (arg=0x2bba4e0) > at Interface/linux/Listener_srvr_ps.cpp:409 > #31 0x00007ff2993e7e78 in sb_thread_sthr_disp (pp_arg=0x2c3dab0) > at threadl.cpp:270 > #32 0x00007ff29c40ddc5 in start_thread () from /lib64/libpthread.so.0 > #33 0x00007ff2996fa73d in clone () from /lib64/libc.so.6 > Thanks, > Weishiun -- This message was sent by Atlassian JIRA (v6.3.15#6346)