You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:16:02 UTC
[jira] [Created] (TRAFODION-438) LP Bug: 1340465 - SPJ with SQL
query statements failed with tdm_udrserv core
Alice Chen created TRAFODION-438:
------------------------------------
Summary: LP Bug: 1340465 - SPJ with SQL query statements failed with tdm_udrserv core
Key: TRAFODION-438
URL: https://issues.apache.org/jira/browse/TRAFODION-438
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Reporter: Chong Hsu
Assignee: Pavani Puppala
Priority: Critical
Testing Trafodion build, 20140709-0830.
This error occurred intermittently in SPJs that running simple SQL query statement, like "insert", "delete" "update", and DDL statements as well. It also generated a tdm_udrserv core file. Note: this error is also seen in developer's UDR regression test according to Arvind.
*** ERROR[2034] $Z000I3F: Operating system error 201 while communicating with server process $Z010QWU. [2014-07-07 23:00:49]
*** ERROR[8904] SQL did not receive a reply from MXUDR, possibly caused by internal errors when executing user-defined routines. [2014-07-07 23:00:49]
The debug trace from core file:
#0 0x0000003eb7a328a5 in raise () from /lib64/libc.so.6
#1 0x0000003eb7a34085 in abort () from /lib64/libc.so.6
#2 0x0000000000423569 in comTFDS (msg1=0x43abb0 "Trafodion UDR Server Internal Error", msg2=<value optimized out>,
msg3=0x7ffffffeb8a0 "Source file information unavailable",
msg4=0x7ffffffeb0a0 "User routine being processed : TRAFODION.HSU.TESTUPDATE, Routine Type : Stored Procedure, Language Type : JAVA, Error occurred inside the user routine code", msg5=0x43c7d7 "", dialOut=<value optimized out>, writeToSeaLog=1)
at ../udrserv/UdrFFDC.cpp:188
#3 0x00000000004237d7 in makeTFDSCall (msg=0x7ffff7bee300 "The Java virtual machine aborted", file=<value optimized out>,
line=<value optimized out>, dialOut=1, writeToSeaLog=1) at ../udrserv/UdrFFDC.cpp:216
#4 0x00007ffff7bd8578 in LmJavaHooks::abortHookJVM () at ../langman/LmJavaHooks.cpp:51
#5 0x00007ffff73f3edb in ?? () from /usr/lib/jvm/java-1.7.0-openjdk.x86_64/jre/lib/amd64/server/libjvm.so
#6 0x00007ffff75475ff in ?? () from /usr/lib/jvm/java-1.7.0-openjdk.x86_64/jre/lib/amd64/server/libjvm.so
#7 0x00007ffff73f8147 in JVM_handle_linux_signal ()
from /usr/lib/jvm/java-1.7.0-openjdk.x86_64/jre/lib/amd64/server/libjvm.so
#8 <signal handler called>
#9 Generator::createColDescs (tableName=0x7fff9ff226e0 "TRAFODION.\"_MD_\".OBJECTS", columnInfo=<value optimized out>,
numCols=27591, offset=@0x7ffffffec48c) at ../generator/Generator.cpp:765
#10 0x00007fffefa18292 in createDescStructs (inTableName=<value optimized out>, numCols=111111111,
columnInfo=0x69f6bc7069f6bc7, numKeys=111111111, keyInfo=0x69f6bc7069f6bc7, numConstrs=0, constrInfo=0x0,
numIndexes=107, indexInfo=0x7ffff09c8750, numViews=0, viewInfo=0x0, tableInfo=0x0) at ../generator/Generator.cpp:1012
#11 Generator::createVirtualTableDesc (inTableName=<value optimized out>, numCols=111111111, columnInfo=0x69f6bc7069f6bc7,
numKeys=111111111, keyInfo=0x69f6bc7069f6bc7, numConstrs=0, constrInfo=0x0, numIndexes=107, indexInfo=0x7ffff09c8750,
numViews=0, viewInfo=0x0, tableInfo=0x0) at ../generator/Generator.cpp:1083
#12 0x00007ffff19babf4 in CmpSeabaseDDL::getSeabaseMDTableDesc (this=<value optimized out>, catName=...,
schName=<value optimized out>, objName=..., objType=0x7ffff06a8600 "BT") at ../sqlcomp/CmpSeabaseDDLtable.cpp:4983
#13 0x00007ffff19ceef8 in CmpSeabaseDDL::getSeabaseTableDesc (this=0x7ffffffec8a0, catName=..., schName=..., objName=...,
objType=0x7ffff06a8600 "BT", includeInvalidDefs=0) at ../sqlcomp/CmpSeabaseDDLtable.cpp:5919
#14 0x00007ffff03796e0 in NATableDB::get (this=0x7fff9ff79670, corrName=..., bindWA=0x7ffffffeeff0, inTableDescStruct=0x0)
at ../optimizer/NATable.cpp:6957
#15 0x00007ffff00f25da in BindWA::getNATable (this=0x7ffffffeeff0, corrName=..., catmanCollectTableUsages=1,
inTableDescStruct=0x0) at ../optimizer/BindRelExpr.cpp:1443
#16 0x00007ffff0120c6e in Scan::bindNode (this=0x7fff9ff155b8, bindWA=0x7ffffffeeff0) at ../optimizer/BindRelExpr.cpp:6581
#17 0x00007ffff00e27d7 in RelExpr::bindChildren (this=0x7fff9ff1a3f0, bindWA=0x7ffffffeeff0)
at ../optimizer/BindRelExpr.cpp:2178
#18 0x00007ffff011903e in RelRoot::bindNode (this=0x7fff9ff1a3f0, bindWA=0x7ffffffeeff0)
at ../optimizer/BindRelExpr.cpp:5015
#19 0x00007ffff1985434 in CmpMain::compile (this=0x7fffffff1260,
input_str=0x7fff9ff356a0 "select object_uid, object_type, object_owner from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'HSU' and object_name = 'T1' and object_type = 'BT'", charset=15,
queryExpr=@0x7fffffff1198, gen_code=0x7fff9ff11750, gen_code_len=0x7fff9ff11748, heap=0x7fffa0caab28,
phase=CmpMain::END, fragmentDir=0x7fffffff13b8, op=3004, useQueryCache=<value optimized out>, cacheable=0x7fffffff11a8,
begTime=0x7fffffff1180, shouldLog=0) at ../sqlcomp/CmpMain.cpp:1795
#20 0x00007ffff198792e in CmpMain::sqlcomp (this=0x7fffffff1260,
input_str=0x7fff9ff356a0 "select object_uid, object_type, object_owner from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'HSU' and object_name = 'T1' and object_type = 'BT'", charset=15,
queryExpr=@0x7fffffff1198, gen_code=0x7fff9ff11750, gen_code_len=0x7fff9ff11748, heap=0x7fffa0caab28,
phase=CmpMain::END, fragmentDir=0x7fffffff13b8, op=3004, useQueryCache=1, cacheable=0x7fffffff11a8,
begTime=0x7fffffff1180, shouldLog=0) at ../sqlcomp/CmpMain.cpp:1462
#21 0x00007ffff1988b44 in CmpMain::sqlcomp (this=0x7fffffff1260, input=..., gen_code=0x7fff9ff11750,
gen_code_len=0x7fff9ff11748, heap=0x7fffa0caab28, phase=CmpMain::END, fragmentDir=0x7fffffff13b8, op=3004)
at ../sqlcomp/CmpMain.cpp:797
#22 0x00007ffff39cf2ff in CmpStatement::process (this=0x7fff9ff11518, sqltext=<value optimized out>)
at ../arkcmp/CmpStatement.cpp:486
#23 0x00007ffff39c3f8e in CmpContext::compileDirect (this=0x7fff9ff74090, data=0x7fffa0cad150 "\200", data_len=312,
outHeap=0x7fffea7761b0, charset=15, op=CmpMessageObj::SQLTEXT_COMPILE, gen_code=@0x7fffffff1940,
gen_code_len=@0x7fffffff1948, parserFlags=163840, diagsArea=0x7fffa0cad290) at ../arkcmp/CmpContext.cpp:689
#24 0x00007ffff65ddd77 in CliStatement::prepare2 (this=0x7fffa0cb6e80,
source=0x7fffa0cb9778 "select object_uid, object_type, object_owner from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'HSU' and object_name = 'T1' and object_type = 'BT' ", diagsArea=...,
passed_gen_code=<value optimized out>, passed_gen_code_len=3933692336, charset=15, unpackTdbs=1, cliFlags=144)
at ../cli/Statement.cpp:1797
#25 0x00007ffff65de1c6 in CliStatement::prepare (this=0x7fffa0cb6e80,
source=0x7fffa0cb9778 "select object_uid, object_type, object_owner from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'HSU' and object_name = 'T1' and object_type = 'BT' ", diagsArea=...,
passed_gen_code=<value optimized out>, passed_gen_code_len=<value optimized out>, charset=<value optimized out>,
unpackTdbs=1, cliFlags=144) at ../cli/Statement.cpp:1388
#26 0x00007ffff65a910c in SQLCLI_Prepare2 (cliGlobals=0xbda930, statement_id=0x1cd8e30, sql_source=0x1cccd00,
gencode_ptr=0x0, gencode_len=0, ret_gencode_len=0x0, query_cost_info=0x7fffffff2d10,
query_comp_stats_info=0x7fffffff1c10, uniqueStmtId=<value optimized out>, uniqueStmtIdLen=0x0, flags=0)
at ../cli/Cli.cpp:5904
#27 0x00007ffff65e8eea in SQL_EXEC_Prepare2 (statement_id=0x1cd8e30, sql_source=0x1cccd00, gencode_ptr=0x0, gencode_len=0,
ret_gencode_len=0x0, query_cost_info=0x7fffffff2d10, comp_stats_info=0x7fffffff1c10, uniqueStmtId=0x0,
uniqueStmtIdLen=0x0, flags=0) at ../cli/CliExtern.cpp:4913
#28 0x00007ffff622968b in ExeCliInterface::prepare (this=0x7fffffff5750, stmtStr=<value optimized out>,
module=<value optimized out>, stmt=0x1cd8e30, sql_src=0x1cccd00, input_desc=0x2e156b0, output_desc=0x21ffaf0,
outputBuf=0x7fffffff5788, outputVarPtrList=0x0, inputBuf=0x7fffffff57c0, inputVarPtrList=0x0, uniqueStmtId=0x0,
uniqueStmtIdLen=0x0, query_cost_info=0x0, comp_stats_info=0x0, monitorThis=0) at ../executor/ExExeUtilCli.cpp:324
#29 0x00007ffff622b20a in ExeCliInterface::fetchRowsPrologue (this=0x7fffffff5750,
sqlStrBuf=0x7fffffff2eb0 "select object_uid, object_type, object_owner from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'HSU' and object_name = 'T1' and object_type = 'BT' ", noExec=1, monitorThis=0,
stmtName=0x0) at ../executor/ExExeUtilCli.cpp:1003
#30 0x00007ffff198cd72 in CmpSeabaseDDL::getObjectUIDandOwner (this=0x7fffffff5d00, cliInterface=0x7fffffff5750,
catName=0x7fffa01430d0 "TRAFODION", schName=<value optimized out>, objName=0x7fffa0143140 "T1",
inObjType=<value optimized out>, outObjType=0x0, objectOwner=0x7fffffff5bbc, reportErrorNow=0)
at ../sqlcomp/CmpSeabaseDDLcommon.cpp:2205
#31 0x00007ffff19ca78d in CmpSeabaseDDL::getSeabaseUserTableDesc (this=0x7fffffff5d00, catName=..., schName=...,
objName=..., objType=0x7ffff06a8600 "BT", includeInvalidDefs=0) at ../sqlcomp/CmpSeabaseDDLtable.cpp:5254
#32 0x00007ffff19cf48b in CmpSeabaseDDL::getSeabaseTableDesc (this=0x7fffffff5d00, catName=..., schName=..., objName=...,
objType=0x7ffff06a8600 "BT", includeInvalidDefs=0) at ../sqlcomp/CmpSeabaseDDLtable.cpp:5964
#33 0x00007ffff0379a9d in NATableDB::get (this=0x7fffa0b90670, corrName=..., bindWA=0x7fffffff87f0, inTableDescStruct=0x0)
at ../optimizer/NATable.cpp:6988
#34 0x00007ffff00f25da in BindWA::getNATable (this=0x7fffffff87f0, corrName=..., catmanCollectTableUsages=1,
inTableDescStruct=0x0) at ../optimizer/BindRelExpr.cpp:1443
#35 0x00007ffff0100163 in GenericUpdate::bindNode (this=0x7fffa0142db0, bindWA=0x7fffffff87f0)
at ../optimizer/BindRelExpr.cpp:11072
#36 0x00007ffff0104ecb in Update::bindNode (this=0x7fffa0142db0, bindWA=0x7fffffff87f0) at ../optimizer/BindRelExpr.cpp:9801
#37 0x00007ffff00e27d7 in RelExpr::bindChildren (this=0x7fffa0146060, bindWA=0x7fffffff87f0)
at ../optimizer/BindRelExpr.cpp:2178
#38 0x00007ffff011903e in RelRoot::bindNode (this=0x7fffa0146060, bindWA=0x7fffffff87f0)
at ../optimizer/BindRelExpr.cpp:5015
#39 0x00007ffff1985434 in CmpMain::compile (this=0x7fffffffaa60,
input_str=0x7fffa01155c0 "update t1 set c3 = 111 where c1 = 1", charset=15, queryExpr=@0x7fffffffa998,
gen_code=0x7fffa0115670, gen_code_len=0x7fffa0115668, heap=0x7fffa0c9eac0, phase=CmpMain::END,
fragmentDir=0x7fffffffabb8, op=3004, useQueryCache=<value optimized out>, cacheable=0x7fffffffa9a8,
begTime=0x7fffffffa980, shouldLog=0) at ../sqlcomp/CmpMain.cpp:1795
#40 0x00007ffff198792e in CmpMain::sqlcomp (this=0x7fffffffaa60,
input_str=0x7fffa01155c0 "update t1 set c3 = 111 where c1 = 1", charset=15, queryExpr=@0x7fffffffa998,
gen_code=0x7fffa0115670, gen_code_len=0x7fffa0115668, heap=0x7fffa0c9eac0, phase=CmpMain::END,
fragmentDir=0x7fffffffabb8, op=3004, useQueryCache=1, cacheable=0x7fffffffa9a8, begTime=0x7fffffffa980, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:1462
#41 0x00007ffff1988b44 in CmpMain::sqlcomp (this=0x7fffffffaa60, input=..., gen_code=0x7fffa0115670,
gen_code_len=0x7fffa0115668, heap=0x7fffa0c9eac0, phase=CmpMain::END, fragmentDir=0x7fffffffabb8, op=3004)
at ../sqlcomp/CmpMain.cpp:797
#42 0x00007ffff39cf2ff in CmpStatement::process (this=0x7fffa0115440, sqltext=<value optimized out>)
at ../arkcmp/CmpStatement.cpp:486
#43 0x00007ffff39c3f8e in CmpContext::compileDirect (this=0x7fffa0b8b090, data=0x7fffa0ca19d8 "\200", data_len=168,
outHeap=0x7fffea7761b0, charset=15, op=CmpMessageObj::SQLTEXT_COMPILE, gen_code=@0x7fffffffb140,
gen_code_len=@0x7fffffffb148, parserFlags=0, diagsArea=0x7fffa0ca1a88) at ../arkcmp/CmpContext.cpp:689
#44 0x00007ffff65ddd77 in CliStatement::prepare2 (this=0x7fffa0c9f030,
source=0x7fffa0cac198 "update t1 set c3 = 111 where c1 = 1", diagsArea=..., passed_gen_code=<value optimized out>,
passed_gen_code_len=3933692336, charset=15, unpackTdbs=1, cliFlags=144) at ../cli/Statement.cpp:1797
#45 0x00007ffff65de1c6 in CliStatement::prepare (this=0x7fffa0c9f030,
source=0x7fffa0cac198 "update t1 set c3 = 111 where c1 = 1", diagsArea=..., passed_gen_code=<value optimized out>,
passed_gen_code_len=<value optimized out>, charset=<value optimized out>, unpackTdbs=1, cliFlags=144)
at ../cli/Statement.cpp:1388
#46 0x00007ffff65a5e61 in SQLCLI_Prepare (cliGlobals=0xbda930, statement_id=0x1cc9a30, sql_source=0x7fffffffb2c0)
at ../cli/Cli.cpp:5782
#47 0x00007ffff65e8ff9 in SQL_EXEC_Prepare (statement_id=0x1cc9a30, sql_source=0x7fffffffb2c0) at ../cli/CliExtern.cpp:4858
#48 0x00007fffa112cef0 in PREPARE (pSrvrStmt=0x1cc9420) at native/SqlInterface.cpp:1464
#49 0x00007fffa1128f2c in SRVR_STMT_HDL::ExecDirect (this=0x1cc9420, inCursorName=0x0, inSqlString=<value optimized out>,
inStmtType=<value optimized out>, inSqlStmtType=0, inHoldability=<value optimized out>, inQueryTimeout=0)
at native/CSrvrStmt.cpp:386
#50 0x00007fffa113c99f in odbc_SQLSvc_ExecDirect_sme_ (objtag_=<value optimized out>, call_id_=<value optimized out>,
exception_=0x7fffffffb520, dialogueId=<value optimized out>, stmtLabel=<value optimized out>, cursorName=0x0,
stmtExplainLabel=0x7fffa113e05d "", stmtType=0, sqlStmtType=0, sqlString=0x7fffffffb4f0, holdability=2, queryTimeout=0,
resultSet=140737488336576, estimatedCost=0x7fffffffb578, outputDesc=0x7fffffffb540, rowsAffected=0x7fffffffb570,
sqlWarning=0x7fffffffb550, stmtId=0x7fffffffb568, currentStmtId=0) at native/SrvrOthers.cpp:671
#51 0x00007fffa1139075 in Java_org_trafodion_jdbc_t2_SQLMXStatement_executeDirect (jenv=0xbe91d8, jobj=0x7fffffffb728,
server=<value optimized out>, dialogueId=35636192, txid=0, autoCommit=1 '\001', txnMode=2, stmtLabel=0x7fffffffb6f0,
cursorName=0x0, sql=0x7fffffffb6e0, isSelect=0 '\000', queryTimeout=0, holdability=2, resultSet=0x7fffffffb6c0,
currentStmtId=0) at native/SQLMXStatement.cpp:140
#52 0x00007fffe5bbcf90 in ?? ()
#53 0x0000000000000002 in ?? () at ../common/Collections.cpp:106
#54 0x00007fffffffb6f0 in ?? ()
#55 0x0000000000000000 in ?? ()
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)