mxosrvr cores during daily build runs

[Aruna Sadashiva]

mxosrvr core during daily build. Trying to execute insert stmt to repos table, although publish stats is disabled.

Core was generated by `mxosrvr -ZKHOST localhost:2181 -RZ slave-cdh51-11.trafodion.org:1:1 -ZKPNODE /j'.
Program terminated with signal 6, Aborted.
#0 0x000000347f432625 in raise () from /lib64/libc.so.6
#0 0x000000347f432625 in raise () from /lib64/libc.so.6
#1 0x000000347f433d8d in abort () from /lib64/libc.so.6
#2 0x000000347f42b74e in __assert_fail_base () from /lib64/libc.so.6
#3 0x000000347f42b810 in __assert_fail () from /lib64/libc.so.6
#4 0x00007ffff4d2e329 in MyGuaProcessHandle::MyGuaProcessHandle (this=0x7fffe5ee3bf0) at ../common/IpcGuardian.cpp:338
#5 0x00007ffff4d222b0 in IpcEnvironment::getMyOwnProcessId (this=0x7fffe33fb060, dom=IPC_DOM_GUA_PHANDLE) at ../common/Ipc.cpp:5327
#6 0x00007ffff3d5170b in ExRtFragTable::ExRtFragTable (this=0x7fffe34eb818, glob=0x7fffe34a2f08, fragDir=0x7fffe34fab80, generatedObject=0x7fffe34fa670 "\020i&\364\377\177") at ../executor/ex_frag_rt.cpp:175
#7 0x00007ffff3d9a801 in ex_root_tdb::build (this=0x7fffe34fa670, cliGlobals=0x10534c0, glob=0x7fffe34a2f08) at ../executor/ex_root.cpp:123
#8 0x00007ffff51a3168 in CliStatement::fixup (this=0x7fffe34c3568, cliGlobals=0x10534c0, input_desc=0x7fffe34c6d68, diagsArea=..., doSimCheck=@0x7fffe5ee515c, partitionUnavailable=@0x7fffe5ee517c, donePrepare=0) at ../cli/Statement.cpp:3112
#9 0x00007ffff51a5f4f in CliStatement::execute (this=0x7fffe34c3568, cliGlobals=0x10534c0, input_desc=0x7fffe34c6d68, diagsArea=..., execute_state=CliStatement::INITIAL_STATE_, fixupOnly=0, cliflags=0) at ../cli/Statement.cpp:4250
#10 0x00007ffff513035f 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=0x10534c0, tasks=4882, statement_id=0x4cb8f20, input_descriptor=0x20c85c0, output_descriptor=0x0, num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffe5ee5740, input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3284
#11 0x00007ffff5130cd0 in SQLCLI_Exec(CliGlobals *, SQLSTMT_ID *, SQLDESC_ID *, Lng32, typedef __va_list_tag __va_list_tag *, SQLCLI_PTR_PAIRS *) (cliGlobals=0x10534c0, statement_id=0x4cb8f20, input_descriptor=0x20c85c0, num_ptr_pairs=0, ap=0x7fffe5ee5740, ptr_pairs=0x0) at ../cli/Cli.cpp:3531
#12 0x00007ffff51bd788 in SQL_EXEC_Exec (statement_id=0x4cb8f20, input_descriptor=0x20c85c0, num_ptr_pairs=0) at ../cli/CliExtern.cpp:2071
#13 0x00007ffff3e15eb6 in ExeCliInterface::exec (this=0x7fffe5ee5b70, inputBuf=0x0, inputBufLen=0) at ../executor/ExExeUtilCli.cpp:599
#14 0x00007ffff3e16a70 in ExeCliInterface::executeImmediateExec (this=0x7fffe5ee5b70, stmtStr=0x7fffe5ee5990 "control query default hbase_filter_preds restore;", outputBuf=0x0, outputBufLen=0x0, nullTerminate=1, rowsAffected=0x0) at ../executor/ExExeUtilCli.cpp:898
#15 0x00007ffff3e16d6b in ExeCliInterface::executeImmediate (this=0x7fffe5ee5b70, stmtStr=0x7fffe5ee5990 "control query default hbase_filter_preds restore;", outputBuf=0x0, outputBufLen=0x0, nullTerminate=1, rowsAffected=0x0, monitorThis=0, globalDiags=0x0) at ../executor/ExExeUtilCli.cpp:993
#16 0x00007ffff3e19634 in ExeCliInterface::restoreCQD (this=0x7fffe5ee5b70, defaultName=0x7ffff0669403 "hbase_filter_preds", globalDiags=0x0) at ../executor/ExExeUtilCli.cpp:2098
#17 0x00007ffff0550785 in CmpSeabaseDDL::restoreAllControlsAndFlags (this=0x7fffe5ee5dc0) at ../sqlcomp/CmpSeabaseDDLcommon.cpp:1286
#18 0x00007ffff054c146 in CmpSeabaseDDL::switchBackCompiler (this=0x7fffe5ee5dc0) at ../sqlcomp/CmpSeabaseDDLcommon.cpp:156
#19 0x00007ffff05bd4d3 in CmpSeabaseDDL::getSeabaseTableDesc (this=0x7fffe5ee5dc0, catName=..., schName=..., objName=..., objType=COM_BASE_TABLE_OBJECT, includeInvalidDefs=0) at ../sqlcomp/CmpSeabaseDDLtable.cpp:7408
#20 0x00007fffeec06abb in NATableDB::get (this=0x7fffd94d26b8, corrName=..., bindWA=0x7fffe5ee9810, inTableDescStruct=0x0) at ../optimizer/NATable.cpp:8006
#21 0x00007fffee953318 in BindWA::getNATable (this=0x7fffe5ee9810, corrName=..., catmanCollectTableUsages=1, inTableDescStruct=0x0) at ../optimizer/BindRelExpr.cpp:1445
#22 0x00007fffee97e535 in GenericUpdate::bindNode (this=0x7fffd9287f90, bindWA=0x7fffe5ee9810) at ../optimizer/BindRelExpr.cpp:11539
#23 0x00007fffee973b33 in Insert::bindNode (this=0x7fffd9287f90, bindWA=0x7fffe5ee9810) at ../optimizer/BindRelExpr.cpp:9043
#24 0x00007fffee9567a7 in RelExpr::bindChildren (this=0x7fffd9288e40, bindWA=0x7fffe5ee9810) at ../optimizer/BindRelExpr.cpp:2180
#25 0x00007fffee963342 in RelRoot::bindNode (this=0x7fffd9288e40, bindWA=0x7fffe5ee9810) at ../optimizer/BindRelExpr.cpp:5225
#26 0x00007ffff053232b in CmpMain::compile (this=0x7fffe5eec400, input_str=0x7fffd9522ff8 "insert into Trafodion.\"_REPOS_\".metric_session_table values(0,0,0,16974,16974,0,0,0,'172.16.0.23',0,'$Z000DUZ','MXID11000016974212287553773118531000000000306U3333307phoenix','END',CONVERTTIMESTAMP(212"..., charset=15, queryExpr=@0x7fffe5eec2e8, gen_code=0x7fffd9274838, gen_code_len=0x7fffd9274830, heap=0x7fffe348fc08, phase=CmpMain::END, fragmentDir=0x7fffe5eec558, op=3004, useQueryCache=1, cacheable=0x7fffe5eec2d4, begTime=0x7fffe5eec2f0, shouldLog=0) at ../sqlcomp/CmpMain.cpp:2119
#27 0x00007ffff0530f41 in CmpMain::sqlcomp (this=0x7fffe5eec400, input_str=0x7fffd9522ff8 "insert into Trafodion.\"_REPOS_\".metric_session_table values(0,0,0,16974,16974,0,0,0,'172.16.0.23',0,'$Z000DUZ','MXID11000016974212287553773118531000000000306U3333307phoenix','END',CONVERTTIMESTAMP(212"..., charset=15, queryExpr=@0x7fffe5eec2e8, gen_code=0x7fffd9274838, gen_code_len=0x7fffd9274830, heap=0x7fffe348fc08, phase=CmpMain::END, fragmentDir=0x7fffe5eec558, op=3004, useQueryCache=1, cacheable=0x7fffe5eec2d4, begTime=0x7fffe5eec2f0, shouldLog=0) at ../sqlcomp/CmpMain.cpp:1732
#28 0x00007ffff052e64c in CmpMain::sqlcomp (this=0x7fffe5eec400, input=..., gen_code=0x7fffd9274838, gen_code_len=0x7fffd9274830, heap=0x7fffe348fc08, phase=CmpMain::END, fragmentDir=0x7fffe5eec558, op=3004) at ../sqlcomp/CmpMain.cpp:817
#29 0x00007fffedc96e0d in CmpStatement::process (this=0x7fffd94fb898, sqltext=...) at ../arkcmp/CmpStatement.cpp:508
#30 0x00007fffedc86e3d in CmpContext::compileDirect (this=0x7fffd94cd090, data=0x7fffd8db1f88 "\200", data_len=520, outHeap=0x7fffe5488c88, charset=15, op=CmpMessageObj::SQLTEXT_COMPILE, gen_code=@0x7fffe5eeca90, gen_code_len=@0x7fffe5eeca9c, parserFlags=131072, diagsArea=0x7fffd8db2198) at ../arkcmp/CmpContext.cpp:697
#31 0x00007ffff519fb21 in CliStatement::prepare2 (this=0x7fffe3483bd0, source=0x7fffe349b290 "insert into Trafodion.\"_REPOS_\".metric_session_table values(0,0,0,16974,16974,0,0,0,'172.16.0.23',0,'$Z000DUZ','MXID11000016974212287553773118531000000000306U3333307phoenix','END',CONVERTTIMESTAMP(212"..., diagsArea=..., passed_gen_code=0x0, passed_gen_code_len=0, charset=15, unpackTdbs=1, cliFlags=144) at ../cli/Statement.cpp:1827
#32 0x00007ffff519e8b4 in CliStatement::prepare (this=0x7fffe3483bd0, source=0x7fffe349b290 "insert into Trafodion.\"_REPOS_\".metric_session_table values(0,0,0,16974,16974,0,0,0,'172.16.0.23',0,'$Z000DUZ','MXID11000016974212287553773118531000000000306U3333307phoenix','END',CONVERTTIMESTAMP(212"..., diagsArea=..., passed_gen_code=0x0, passed_gen_code_len=0, charset=15, unpackTdbs=1, cliFlags=144) at ../cli/Statement.cpp:1420
#33 0x00007ffff51313ae in SQLCLI_ExecDirect2(CliGlobals *, SQLSTMT_ID *, SQLDESC_ID *, Int32, SQLDESC_ID *, Lng32, typedef __va_list_tag __va_list_tag *, SQLCLI_PTR_PAIRS *) (cliGlobals=0x10534c0, statement_id=0x2271428, sql_source=0x7fffe5eecfa0, prepFlags=0, input_descriptor=0x0, num_ptr_pairs=0, ap=0x7fffe5eecd50, ptr_pairs=0x0) at ../cli/Cli.cpp:3705
#34 0x00007ffff51bdeb3 in SQL_EXEC_ExecDirect2 (statement_id=0x2271428, sql_source=0x7fffe5eecfa0, prep_flags=0, input_descriptor=0x0, num_ptr_pairs=0) at ../cli/CliExtern.cpp:2326
#35 0x00007ffff6bf6239 in SRVR::WSQL_EXEC_ExecDirect (statement_id=0x2271428, sql_source=0x7fffe5eecfa0, input_descriptor=0x0, num_ptr_pairs=0) at SQLWrapper.cpp:360
#36 0x00007ffff6bdd1a4 in SRVR::EXECDIRECT (pSrvrStmt=0x2270e10) at sqlinterface.cpp:4479
#37 0x00007ffff6b6ab89 in SRVR::ControlProc (pParam=0x2270e10) at csrvrstmt.cpp:757
#38 0x00007ffff6b6a1c7 in SRVR_STMT_HDL::ExecDirect (this=0x2270e10, inCursorName=0x0, inSqlString=0x4a35208 "insert into Trafodion.\"_REPOS_\".metric_session_table values(0,0,0,16974,16974,0,0,0,'172.16.0.23',0,'$Z000DUZ','MXID11000016974212287553773118531000000000306U3333307phoenix','END',CONVERTTIMESTAMP(212"..., inStmtType=1, inSqlStmtType=0, inSqlAsyncEnable=0, inQueryTimeout=0) at csrvrstmt.cpp:439
#39 0x0000000000576710 in SessionWatchDog (arg=0x0) at SrvrConnect.cpp:795
#40 0x000000347f8079d1 in start_thread () from /lib64/libpthread.so.0
#41 0x000000347f4e88fd in clone () from /lib64/libc.so.6

[Trafodion-Gerrit (neo-devtools)]

Fix proposed to branch: master
Review: https://review.trafodion.org/930

[Trafodion-Gerrit (neo-devtools)]

Reviewed: https://review.trafodion.org/930
Committed: https://github.com/trafodion/dcs/commit/ec5db9e2635f2ee8ca5936c4e3d742a8f9b9b9b0
Submitter: Trafodion Jenkins
Branch: master

commit ec5db9e2635f2ee8ca5936c4e3d742a8f9b9b9b0
Author: matbrown <email address hidden>
Date: Fri Jan 9 22:02:08 2015 +0000

    Disable workload statistics publishing
    Closes-Bug: #1409091

    Disable the publishing of workload statistics in mxosrvr.
    This is set in the following property:
    dcs.server.user.program.statistics.enabled

    Change-Id: I7d6227dbe04f50aa670ceb0a21aaf95dcd4454be

[Trafodion-Gerrit (neo-devtools)]

Fix proposed to branch: master
Review: https://review.trafodion.org/933

[Trafodion-Gerrit (neo-devtools)]

Reviewed: https://review.trafodion.org/933
Committed: https://github.com/trafodion/dcs/commit/c267963fbd9442ae051041f006b7261a75fc5e2c
Submitter: Trafodion Jenkins
Branch: master

commit c267963fbd9442ae051041f006b7261a75fc5e2c
Author: matbrown <email address hidden>
Date: Sun Jan 11 21:22:28 2015 +0000

    Second part of change to disable mxosrvr repos stats

    After first checkin it was discovered that change was not affected in
    dcs-default.xml resource file.
    Closes bug: #1409091

    Change-Id: Ib52049087db243939e405d74c30ea3a72cac6b9d

[Aruna Sadashiva (aruna-sadashiva)]

No cores during daily builds.