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

• 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

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

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