Use of Log4cpp for the lob server process needs rework

Bug #1420378 reported by Sandhya Sundaresan
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
Fix Committed
High
Sandhya Sundaresan

Bug Description

The lobserver process is aseparate sql process that should log it's events to a seaprate log file. Need to add support for this as well as intitializing log4cpp when the lob server process receives it's first request from the master.
Some current symptoms include a core when the lob server gets it's first request. This occurs rarely .

gdb) bt
#0 0x000000000004cf66 in ?? ()
#1 0x00007ffff2b4c237 in log4cpp::Category::getInstance (name="SQL.HBase")
    at Category.cpp:36
#2 0x00007ffff2651330 in QRLogger::log (cat=0x7ffff2678757 "SQL.HBase",
    level=LL_DEBUG,
    logMsgTemplate=0x7ffff6578748 "ExpHbaseInterface_JNI::init() creating new client.") at ../qmscommon/QRLogger.cpp:455
#3 0x00007ffff71fd27a in HBaseClient_JNI::revoke (this=0x7ffff5c279b9, user=
    Traceback (most recent call last):
  File "/usr/lib64/../share/gdb/python/libstdcxx/v6/printers.py", line 558, in to_string
    return self.val['_M_dataplus']['_M_p'].lazy_string (length = len)
OverflowError: signed integer is greater than maximum
, tblName="",
    actions=std::vector of length 30808638014, capacity 17591599055466 = {...})
    at ../executor/HBaseClient_JNI.cpp:1691
#4 0x00007ffff5c2892c in ExpHbaseInterface_JNI::init (this=0x7fffe81a2350,
    hbs=0x0) at ../exp/ExpHbaseInterface.cpp:382
#5 0x00007ffff08f8edf in CmpSeabaseDDL::allocEHI (this=0x7fffffff3200,
    server=0x7fffe8193e80 "", port=0x7fffe8193ee0 "9090",
    interface=0x7fffe8193c60 "JNI_TRX", zkPort=0x7fffe8193f60 "", raiseError=1)
    at ../sqlcomp/CmpSeabaseDDLcommon.cpp:836
#6 0x00007ffff08f9e9f in CmpSeabaseDDL::validateVersions (
---Type <return> to continue, or q <return> to quit---
    this=0x7fffffff3200, defs=0x7fffe8179970, inEHI=0x0, mdMajorVersion=0x0,
    mdMinorVersion=0x0, sysSWMajorVersion=0x0, sysSWMinorVersion=0x0,
    sysSWUpdVersion=0x0, mdSWMajorVersion=0x0, mdSWMinorVersion=0x0,
    hbaseErrNum=0x7fffffff338c, hbaseErrStr=0x7fffffff3320)
    at ../sqlcomp/CmpSeabaseDDLcommon.cpp:1055
#7 0x00007ffff09bfd07 in NADefaults::readFromSQLTables (this=0x7fffe8179970,
    overwriteIfNotYet=NADefaults::SET_BY_CQD, errOrWarn=1)
    at ../sqlcomp/nadefaults.cpp:4573
#8 0x00007ffff09c0047 in NADefaults::getValueWhileInitializing (
    this=0x7fffe8179970, attrEnum=636) at ../sqlcomp/nadefaults.cpp:4651
#9 0x00007ffff09c007f in NADefaults::getCatalogAndSchema (
    this=0x7fffe8179970, cat=..., sch=...) at ../sqlcomp/nadefaults.cpp:4660
#10 0x00007fffef1e61ba in SchemaDB::initPerStatement (this=0x7fffe81796a8,
    lightweight=0) at ../optimizer/SchemaDB.cpp:124
#11 0x00007fffef1e6028 in SchemaDB::SchemaDB (this=0x7fffe81796a8, rtd=
    0x7fffe8179420) at ../optimizer/SchemaDB.cpp:94
#12 0x00007fffee02e5b5 in CmpContext::CmpContext (this=0x7fffe8174090, f=1, h=
    0x7fffe830af48) at ../arkcmp/CmpContext.cpp:196
#13 0x00007ffff45a3c0a in arkcmp_main_entry () at ../common/arkcmp_proc.cpp:169
#14 0x00007ffff793deb7 in ContextCli::switchToCmpContext (this=0x7fffe8d7c128,
    cmpCntxtType=0) at ../cli/Context.cpp:5578
#15 0x00007ffff7974e96 in CliStatement::prepare2 (this=0x7fffe82fee58,
    source=0x7fffe8300588 "set transaction autocommit on;", diagsArea=...,
---Type <return> to continue, or q <return> to quit---
    passed_gen_code=0x0, passed_gen_code_len=0, charset=15, unpackTdbs=1,
    cliFlags=144) at ../cli/Statement.cpp:1563
#16 0x00007ffff797499c in CliStatement::prepare (this=0x7fffe82fee58,
    source=0x7fffe8300588 "set transaction autocommit on;", diagsArea=...,
    passed_gen_code=0x0, passed_gen_code_len=0, charset=15, unpackTdbs=1,
    cliFlags=144) at ../cli/Statement.cpp:1420
#17 0x00007ffff790beab in SQLCLI_Prepare2 (cliGlobals=0xb9a9b0,
    statement_id=0x7fffe82fe9f0, sql_source=0x7fffe82ff620, gencode_ptr=0x0,
    gencode_len=0, ret_gencode_len=0x0, query_cost_info=0x7fffffff4fd0,
    query_comp_stats_info=0x7fffffff3ed0, uniqueStmtId=0x0,
    uniqueStmtIdLen=0x0, flags=128) at ../cli/Cli.cpp:5914
#18 0x00007ffff7997e41 in SQL_EXEC_Prepare2 (statement_id=0x7fffe82fe9f0,
    sql_source=0x7fffe82ff620, gencode_ptr=0x0, gencode_len=0,
    ret_gencode_len=0x0, query_cost_info=0x7fffffff4fd0,
    comp_stats_info=0x7fffffff3ed0, uniqueStmtId=0x0, uniqueStmtIdLen=0x0,
    flags=128) at ../cli/CliExtern.cpp:4985
#19 0x00007ffff70bbfce in ExeCliInterface::prepare (this=0x7fffe82fd000,
    stmtStr=0x7fffe82fd100 "set transaction autocommit on;",
    module=0x7fffe82fee28, stmt=0x7fffe82fe9f0, sql_src=0x7fffe82ff620,
    input_desc=0x7fffe83003e0, output_desc=0x7fffe8300528,
    outputBuf=0x7fffffff50e8, outputVarPtrList=0x0, inputBuf=0x7fffe82fd070,
    inputVarPtrList=0x0, uniqueStmtId=0x0, uniqueStmtIdLen=0x0,
    query_cost_info=0x0, comp_stats_info=0x0, monitorThis=0)
---Type <return> to continue, or q <return> to quit---
    at ../executor/ExExeUtilCli.cpp:414
#20 0x00007ffff70bd711 in ExeCliInterface::executeImmediate (
    this=0x7fffe82fd000,
    stmtStr=0x7fffe82fd100 "set transaction autocommit on;", outputBuf=0x0,
    outputBufLen=0x0, nullTerminate=0, rowsAffected=0xe8d7c138, monitorThis=0,
    globalDiags=0x7ffff2d9a681) at ../executor/ExExeUtilCli.cpp:986
#21 0x00007ffff70bdbee in ExeCliInterface::fetchAllRows (this=0x7ffff2d9a681,
    infoList=@0x0, query=0x7ffff70bdbee "", inNumOutputEntries=32767,
    varcharFormat=-44656, monitorThis=32767, initInfoList=0)
    at ../executor/ExExeUtilCli.cpp:1114
#22 0x00007ffff7912cf9 in SQLCLI_LOBcliInterface (cliGlobals=0xb9a9b0,
    inLobHandle=0x0, inLobHandleLen=0, blackBox=0x0, blackBoxLen=0x0,
    outLobHandle=0x0, outLobHandleLen=0x0, qType=LOB_CLI_INIT,
    qPhase=LOB_CLI_ExecImmed, dataOffset=0x0, dataLen=0x0,
    outDescPartnKey=0x0, outDescSyskey=0x0, inCliInterface=0x0, xnId=0)
    at ../cli/Cli.cpp:9391
#23 0x00007ffff799ab7d in SQL_EXEC_LOBcliInterface (inLobHandle=0x0,
    inLobHandleLen=0, blackBox=0x0, blackBoxLen=0x0, outLobHandle=0x0,
    outLobHandleLen=0x0, qType=LOB_CLI_INIT, qPhase=LOB_CLI_ExecImmed,
    dataOffset=0x0, dataLen=0x0, outDescPartnKey=0x0, outDescSyskey=0x0,
    inCliInterface=0x0, xnId=0) at ../cli/CliExtern.cpp:7262
#24 0x00000000004092ab in processRequest (request=0x7fffffff6430)
    at ../exp/ExpLOBprocess.cpp:718
---Type <return> to continue, or q <return> to quit---
#25 0x0000000000409757 in receive_message (request=0x7fffffff6430)
    at ../exp/ExpLOBprocess.cpp:824
#26 0x000000000040a1a4 in main (argc=1, argv=0x7fffffff85c8)
    at ../exp/ExpLOBprocess.cpp:1101
(gdb)

Tags: sql-exe
Changed in trafodion:
status: New → In Progress
Revision history for this message
Sandhya Sundaresan (sandhya-sundaresan) wrote :

Fixed and merged into mainline :I8d06716a1cac464454e01e5267460efa1859747f

lobserver process now has it's own config file and log file for logging events.

Changed in trafodion:
status: In Progress → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.