SAP Knowledge Base Article - Preview

2704853 - Query fails with non-fatal stack trace at optlib/opt_BaseTableLeaf.cxx:1963 - SAP IQ

Symptom

  • IQ 16.1/sp01.04, query fails with stacktrace on:
       
        optlib/opt_BaseTableLeaf.cxx:1963
        opt_BaseTableLeaf::EstimateTableCardinality
       
  • The complete set of stack traces includes:
      
    ********************************************************
    **       Non-Fatal IQ Internal Error Detected
    **       at optlib/opt_BaseTableLeaf.cxx:1963  on thread 139894467655424 (TID 27)
    **  IQ Version:  SAP IQ/16.1.010/10689/P/sp01.04
    **  OS info:  IQ built on: Linux/Linux64 - x86_64 - 2.6.18-194,  Executed on: ..
    **  Command status when error occured:  CURSOR ACTIVE
    **  Command text:
         
     pc: 0x7f3bb1789012 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x32
     pc: 0x7f3bb1789681 ucstkgentrace(int, int)+0x121
     pc: 0x7f3bb178acc4 StackTraceForThisThread(char const*, int, char const*, char const*, char const*)+0x314
     pc: 0x7f3bb1005876 df_Exception::df_Exception(char const*, int, df_Exception::df_ErrorCode, char const*, char const*, dfo const*, df_Evaluable const*)+0x546
     pc: 0x7f3bb1007179 df_Exception::ThrowException_0(char const*, int, df_Exception::df_ErrorCode)+0x39
     pc: 0x7f3bb140b0c5 opt_BaseTableLeaf::EstimateTableCardinality(opt_UpdateFlag)+0x4e5
     pc: 0x7f3bb14b5586 opt_TableNode::GatherPostPushCardinalityMetaData()+0x26
     pc: 0x7f3bb14916e1 opt_QueryTree::ReEstimateWithinPushDownSubTrees(opt_QueryNode*)+0x161
     pc: 0x7f3bb1496be5 opt_QueryTree::InferJoinKeyRangePredicates(opt_QueryNode*)+0xb5
     pc: 0x7f3bb1496be5 opt_QueryTree::InferJoinKeyRangePredicates(opt_QueryNode*)+0xb5
     pc: 0x7f3bb1496be5 opt_QueryTree::InferJoinKeyRangePredicates(opt_QueryNode*)+0xb5
     pc: 0x7f3bb1496be5 opt_QueryTree::InferJoinKeyRangePredicates(opt_QueryNode*)+0xb5
     pc: 0x7f3bb1496be5 opt_QueryTree::InferJoinKeyRangePredicates(opt_QueryNode*)+0xb5
     pc: 0x7f3bb149acf3 opt_QueryTree::ProcessQueryTree()+0x113
     pc: 0x7f3bb14ac16c opt_Select::GenerateDFOs(df_Heap*, opt_QueryExp*)+0x1bc
     pc: 0x7f3bb141634c opt_Driver::GenerateTree(QueryNode*, st_cursor*, a_statement const*, UITable*, UIIndex*, s_bm*, unsigned int*, db_RebuildIndexInfo**, int, a_table*, hos_vector_noerror*, hs_store*, int, db_IQParallelIndexInfo*, rv_MergeCmdState*)+0xdec
     pc: 0x7f3bb227bddd st_cursorIQtoSA::Parse()+0x12d
     pc: 0x7f3bb105fe88 df_OpenCursor::Parse()+0xe8
     pc: 0x7f3bb226eaf3 st_command::DoCmdThroughResourceGate()+0x43
     pc: 0x7f3bb22c3e18 st_iqdml::OpenCursor(a_statement*, UIConnection*, UICursor*, a_cursor_spec*, a_cursor_orientation)+0x78
     pc: 0x7f3bb0ff7d35 UIQDML_OpenCursor+0x25
     pc: 0x7f3bb22cba76 st_SAIQInterfaceInfo::callFunction()+0x26
     pc: 0x7f3bb2336e04 st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x1ac
     pc: 0x7f3bb22cc54d st_SAIQInterface::Execute(int, void*, unsigned int (*)+0x20d
     pc: 0x7f3bb179d551 saint_iqthresholddml::OpenCursor(a_statement*, IConnection*, ICursor*, a_cursor_spec*, a_cursor_orientation)+0x91
     pc: 0x7f4149cb198b df_OmniRowScan::Restart(a_cursor_orientation)+0x2cb
     pc: 0x7f4149c8a71f dfo_Scan::DoFetch(a_cursor_orientation)+0xcf
     pc: 0x7f4149c88f82 dfo_Scan::DoFirstFetch(a_cursor_orientation)+0xd2
     pc: 0x7f4149c6e2c7 dfo_Base::Fetch(a_cursor_orientation)+0x107
     pc: 0x7f4149c77d03 dfo_Root::DoFetch(a_cursor_orientation)+0x53
     pc: 0x7f4149c739e2 dfo_Root::DoFirstFetch(a_cursor_orientation)+0x42
     pc: 0x7f4149c6e2c7 dfo_Base::Fetch(a_cursor_orientation)+0x107
     pc: 0x7f4149c6fe42 dfo_Root::DoFetchRelative(int, int*)+0xc2
     pc: 0x7f4149c70eb2 dfo_Root::FetchRelative(int, int*)+0xf2
     pc: 0x7f41497f6a0d DB_Search_fetch(a_db_cursor*, unsigned int, int, int*)+0x7d
     pc: 0x7f41499ac0e2 do_move_cursor(a_db_cursor*, int, unsigned int, unsigned int, unsigned int)+0x92
     pc: 0x7f41499ae4a3 dbi_fetch(a_db_cursor*, int, unsigned short, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int)+0x2f3
     pc: 0x7f4149b17336 db__fetch(Connection*, an_sqlpres_receive*)+0x1c6
     pc: 0x7f4149b40d00 do_request(Worker*, an_sqlpres_receive*)+0x230
     pc: 0x7f4149b3f8de RequestProcedure::call()+0xb9e
     pc: 0x7f41498d48c5 Worker::spawn(Procedure*)+0x35
     pc: 0x7f4149b39ebb EngStream::handle_ind(unsigned char, unsigned int)+0xeb
     pc: 0x7f4149b3d539 EngStream::execute()+0xe69
     pc: 0x7f4149b3e16d RQConnItem::do_request()+0xd
     pc: 0x7f4149b3842d RQBaseItem::do_work(Worker*)+0x1d
     pc: 0x7f4149b94857 RequestQueue::worker_body()+0x67
     pc: 0x7f4149b39175 request_task(void*)+0x65
     pc: 0x7f414a0bc9fd run_task_body+0x2d
     pc: 0x7f4149b958b6 UnixTask::pre_body(void*)+0x66

Read more...

Environment

SAP IQ/16.1.010/10689/P/sp01.04

Product

SAP IQ 16.1

Keywords

opt_BaseTableLeaf::EstimateTableCardinality, optlib/opt_BaseTableLeaf, Non-Fatal IQ Internal Error Detected, IQ Internal Error, , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.