1947381 - Non-Fatal SAP IQ stacktrace : Internal Error Detected at dfo.cxx for the Parallel Combiner on call dfo::HasMixedSMJSourceTypes() -- SAP IQ

• A query with the rowid() function aborts with a Non-Fatal IQ Internal Error Detected at dfo.cxx (seen at line 1419 and 1441) at function call dfo::HasMixedSMJSourceTypes()
• error message seen in iqmsg file and stack produced

  I. 03/20 12:58:21. 0000000304 [20917]: Delete of 0 rows started for table: 
  I. 03/20 12:58:22. 0000000304 [20819]: In table '_smart2_temp_p_clic_ca', the full width insert of 2 columns will begin at record 1.
  I. 03/20 12:58:22. 0000000304 Insert Started.
  I. 03/20 12:58:22. 0000000304 _smart2_temp_p_clic_ca
  I. 03/20 12:58:22. 0000000304 
  I. 03/20 12:58:22. 0000000304 ********************************************************
  I. 03/20 12:58:22. 0000000304 **
  I. 03/20 12:58:22. 0000000304 ** Non-Fatal IQ Internal Error Detected
  I. 03/20 12:58:22. 0000000304 ** at dfo.cxx:1419 on thread 32 (TID 5)
  I. 03/20 12:58:22. 0000000304 ** Error detected at DFO #55 Parallel Combiner 
  I. 03/20 12:58:22. 0000000304 **
  I. 03/20 12:58:22. 0000000304 ** Please report this to Sybase IQ support
  I. 03/20 12:58:22. 0000000304 ** with the following diagnostic information,
  I. 03/20 12:58:22. 0000000304 ** and, if possible, with the user's command.
  I. 03/20 12:58:22. 0000000304 **
  I. 03/20 12:58:22. 0000000304 ** Error from IQ connection: SA connHandle: 3 SA connID: 24 IQ connID: 0000000304 User: DBA
  I. 03/20 12:58:22. 0000000304 ** Time of error: 2012-03-20 12:58:22
  I. 03/20 12:58:22. 0000000304 ** IQ Version: Sybase IQ/15.3.0/111108/P/ESD 0.4
  I. 03/20 12:58:22. 0000000304 ** OS info: IQ built on: Sun_Sparc/OS 5.10, Executed on: SunOS/squint/5.10/Generic_141444-09/sun4v
  I. 03/20 12:58:22. 0000000304 ** Command status when error occured: COMMAND ACTIVE
  I. 03/20 12:58:22. 0000000304 ** Command text:  smart2_temp_p_clic_ca_load 1,0
  I. 03/20 12:58:24. 0000000304 

  ***************** This is the STACKTRACE ***************

  I. 03/20 12:58:24. 0000000304

  ===== Thread Number 32 (IQ connID: 0000000304) =====

  I. 03/20 12:58:24. 0000000304 pc: 0x0 (0xffffffff766759b0, 0x58b, 0xffffffff73b7d530, 0x11176b650, 0x0)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7299badc int pcstkwalk(stk_trace*,int,db_log*,hos_fd*)+0x3c(0x29, 0xffffffff739d4fe5, 0xffffffff76674678, 0xffffffff766748dc, 0xffffffff766759b0)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7299c300 void StackTraceForThisThread(const char*,int,const char*,const char*,const char*)+0x5a0(0xffffffff7383f8ba, 0x58b, 0xffffffff73b7d530, 0x11176b650, 0x0)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff72382680 df_Exception::df_Exception(const char*,int,df_Exception::df_ErrorCode,const char*,const char*,const dfo*,const df_Evaluable*)+0x1db0(0xffffffff76676bb0, 0xffffffff7383f8ba, 0x58b, 0x0, 0x0)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7238345c void df_Exception::ThrowException(const char*,int,df_Exception::df_ErrorCode,const char*,const char*,const dfo*,const df_Evaluable*)+0x4c(0xffffffff7383f8ba, 0x58b, 0x0, 0x0, 0x0)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff725142f0 int dfo::HasMixedSMJSourceTypes() const+0x110(0x1113ed1d8, 0xffffffff725a44e0, 0x0, 0x1, 0x0)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff725cd3c8 void dfo_cOrderBy::PrefetchAndSort()+0x148(0x10df13ca8, 0x0, 0x118faf0, 0x1124e3a08, 0xffffffff7375cd78)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff725cd1a0 void dfo_cOrderBy::SourcePreFetch()+0x40(0x10df13ca8, 0xc, 0x2, 0x1, 0xe6154f5a)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff725a0824 void dfo_SubQueryFilter::SourcePreFetch()+0x64(0x1113ec7a8, 0x10, 0x0, 0x1, 0xe6154f5a)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7253df80 void dfo_Combiner::SourcePreFetch()+0x140(0x1cc2a9eb4000, 0x10deaa128, 0xe8000, 0x0, 0x1113ed1d8)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7253e67c int dfo_Combiner::FetchOpus()+0x3c(0x1113ed1d8, 0xffffffff7253e640, 0x121e730, 0xffffffff738454b8, 0x3)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff72582af8 int dfo_Root::FetchOpus()+0x158(0x111403298, 0xf8400, 0x224400, 0x10758dbc8, 0x1113ed1d8)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff721d1328 int db_cursorIQtoIQ::Fetch()+0x68(0x10debac38, 0x4a400, 0x11174da28, 0x0, 0x111403298)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff723183fc int db_sqlinsert::SExecuteProduceData(int,unsigned,int&)+0x3bc(0xffffffff7667e4d8, 0x0, 0x11174ddd0, 0x0, 0x0)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff722080b8 int hdb_insertIter::LocalExecWork(int&,unsigned)+0x2d8(0x11174e008, 0x30c00, 0x0, 0xffffffff7378dccd, 0xffffffff72317260)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7220b5f8 int hdb_insertIter::ExecWork(int&,unsigned)+0x58(0x11174e008, 0xffffffff7667c29c, 0x0, 0x9e0, 0xdfddd4)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff729ac378 void workAllocator::DoWork(unsigned)+0x118(0x11174e2c8, 0x0, 0xffffffff7d748100, 0x0, 0xffffffff7667c2a0)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff729b2378 void hos_team::StartWork(void(*)(void*,void*),void*)+0x1f8(0xffffffff729ae5c0, 0xffffffff739d7b68, 0x1, 0x1, 0x1)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff729aeab4 void hos_team::Exec(hos_workIter&)+0x54(0x1116ccbb8, 0x11174e020, 0xffffffffff254588, 0xdae314, 0xffffffff7375cd78)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff72317594 void db_sqlinsert::SExecute()+0x2f4(0xffffffff7667e4d8, 0x2, 0x1, 0x1, 0xffffffff7375cd78)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7231a278 void db_sqlinsert::Execute()+0x1f8(0xffffffff7667e4d8, 0x0, 0x0, 0x1, 0x0)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff732cb8ac void st_command::DoCmdThroughResourceGate()+0x32c(0xffffffff7667e4d8, 0x1006dc890, 0xffffffff737bdfe0, 0x10db427b8, 0xffffffff7231a080)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff73340df0 unsigned st_iqdml::Insert(a_statement*,UIConnection*,UICursor*)+0xd0(0xffffffff7e7e4a20, 0xffffffff60b83620, 0xffffffff60a2b4f0, 0x0, 0x100476878)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff72a01418 UIQDML_Insert+0x18(0x1004af2d8, 0xffffffff76681e28, 0xffffffff7d748100, 0xffffffff73340d20, 0x10756c638)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff732c7484 void st_SAIQInterfaceInfo::callFunction()+0x24(0xffffffff76681c30, 0x0, 0x495914, 0xffffffff7375cd78, 0xffffffff76681c30)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff732c943c void st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x15c(0x0, 0xffffffffff2a54a8, 0xffffffff7d748100, 0xffffffff76681c30, 0x10756c638)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff732c7ce4 void st_SAIQInterface::Execute(int,void*,unsigned(*)(void*,void*),void*,unsigned)+0x3e4(0x10756c638, 0xffffffff72a00060, 0x10756c748, 0x10db427b8, 0xffffffff73aad20b)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff732c1a6c void saint_iqthresholddml::Insert(a_statement*,IConnection*,ICursor*)+0x18c(0x1004aef08, 0xffffffffff2a4688, 0x49b488, 0x1004af2d8, 0xffffffff60b83620)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e741548 int InsertFromSelect(a_db_cursor*,a_statement*,unsigned)+0xe0(0xffffffff60add310, 0xffffffff60ad6290, 0x1, 0xffffffff60add310, 0x4000000)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e741618 void dbi_insert(Connection*,a_statement*,a_stmt*,a_stmt_identifier*,unsigned,unsigned,TableDef*)+0x60(0xffffffff60a2b4f0, 0xffffffff60ad6290, 0xffffffff60ac2620, 0xffffffff76682508, 0x0)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e810154 a_cursor*DoExecuteBodyLocal(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,bool,unsigned,unsigned short)+0x1bc(0xffffffff60a2b4f0, 0xffffffff60ac2620, 0xffffffff60ad6290, 0xffffffff76682508, 0xffffffff7e80fc68)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e8113f0 a_cursor*DoExecuteBody(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,bool,unsigned,unsigned short)+0x160(0xffffffff60a2b4f0, 0xffffffff60ac2620, 0xffffffff60ad6290, 0xffffffff76682508, 0x100148ba0)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e8127a4 void DoExecuteStmt(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,unsigned short,unsigned)+0xad4(0xffffffff60a2b4f0, 0xffffffff60ac2620, 0xffffffff60ad6290, 0x1, 0x100168b20)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e7a1ce4 void ExecuteStmt(Connection*,a_context_ref*,a_statement*,a_stmt*)+0x7c(0xffffffff60a2b4f0, 0xffffffff609b31d0, 0xffffffff60ad6290, 0xffffffff60ac2620, 0xffffffff60b7e060)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e7a4128 unsigned exec_procedure_stmt(Connection*,a_context_ref*,a_statement*,unsigned,unsigned)+0x9b0(0xffffffff60ac2620, 0xffffffff76682e00, 0xffffffff60ad6290, 0x0, 0x0)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e7a54f4 unsigned run_procedure(a_context_ref*,dfm_CallInfo*,unsigned,Connection*,unsigned)+0x9f4(0xffffffff00000000, 0xffffffff76682a20, 0xffffffff60a2bdf0, 0xffffffff60a2b4f0, 0xffffffff60ad6290)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e7a5e0c void call_procedure(Connection*,a_proc_def*,a_trigger_def*,an_expr_node*,a_procedure_arg*,unsigned,a_db_cursor*,bool)+0x74(0xffffffff60a2b4f0, 0xffffffff609b31d0, 0x0, 0x0, 0xffffffff60b76820)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e7a8270 void dbi_callprocedure(Connection*,a_call*,bool,unsigned)+0x100(0xffffffff60a2b4f0, 0xffffffff60b76890, 0x1, 0x1, 0xffffffff60b72ad0)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e810608 a_cursor*DoExecuteBodyLocal(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,bool,unsigned,unsigned short)+0x670(0xffffffff60a2b4f0, 0xffffffff60a1ef40, 0xffffffff60b762b0, 0x0, 0xffffffff7e80fc68)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e8113f0 a_cursor*DoExecuteBody(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,bool,unsigned,unsigned short)+0x160(0xffffffff60a2b4f0, 0xffffffff60a1ef40, 0xffffffff60b762b0, 0x0, 0x100148ba0)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e8127a4 void DoExecuteStmt(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,unsigned short,unsigned)+0xad4(0xffffffff60a2b4f0, 0xffffffff60a1ef40, 0xffffffff60b762b0, 0x0, 0x100168b20)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e8137d8 void db__execute(Connection*,an_sqlpres_receive*)+0x1d0(0xffffffff60a2b4f0, 0x0, 0x0, 0xffffffff76683510, 0xffffffff7f0ca2e8)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e823914 void RequestProcedure::call()+0x57c(0x3f1ac, 0xffffffff7f0f46b8, 0xffffffff7f20aae8, 0xffffffff7f0d944c, 0xffffffff7f0d9590)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e69416c void Context::call(Procedure*,Context**)+0x54(0xffffffff76683770, 0xffffffff766838b8, 0x100168ee0, 0x3f400, 0x12800)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e694ec0 void Worker::call_on_stack(Procedure*)+0x48(0x12800, 0xffffffff766838b8, 0x0, 0xa3545c, 0xffffffff7f0ca2e8)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e823fe8 void TopProcedure::call()+0x58(0xffffffff76683bb8, 0xffffffff76683bd7, 0x8a6354, 0x3f400, 0xffffffff7f0ca2e8)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e694d4c int Worker::spawn(Procedure*)+0x410(0x100168b20, 0xffffffff76683bb8, 0x0, 0xffffffff60765920, 0x142400)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e825908 void EngStream::execute()+0x620(0x1008af998, 0x391, 0x1, 0x0, 0x1)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e826ef4 unsigned RQBaseItem::do_work(Worker*)+0xc(0x1008afa70, 0x100168b20, 0xffffffff7e826ee8, 0xffffffff7e826120, 0x0)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e84899c void DeferredCall::worker_body()+0xf4(0xffffffff7f10b910, 0x41400, 0x41400, 0xffffffff76683d40, 0x100168b20)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e826ea0 void request_task(void*)+0xc8(0xffffffff7f20c810, 0x100, 0xffffffff7f0ca2e8, 0x142528, 0x8a350c)
  I. 03/20 12:58:24. 0000000304 pc: 0xffffffff7e84a638 void*UnixTask::pre_body(void*)+0x178(0x0, 0x4000, 0x2000, 0x2000, 0x1)

  I. 03/20 12:58:24. 0000000304 ******************* End of STACKTRACE ******************
  I. 03/20 12:58:24. 0000000304 **
  I. 03/20 12:58:24. 0000000304 ** End of stack trace from Non-Fatal IQ Internal Error dfo.cxx:1419
  I. 03/20 12:58:24. 0000000304 **
  I. 03/20 12:58:24. 0000000304 ********************************************************
  I. 03/20 12:58:24. 0000000304 
  I. 03/20 12:58:24. 0000000304 Exception Thrown from dfo.cxx:1419, Err# 0, tid 5 origtid 5
  I. 03/20 12:58:24. 0000000304 O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006001, SQLState: 'QBA01', Severity: 23
  I. 03/20 12:58:24. 0000000304 [20239]: IQ Internal error. Please report this to Sybase IQ support. 
  -- (dfo.cxx 1419) 
  -- (dfo.cxx 1419) 
  I. 03/20 12:58:24. 0000000304 Exception Thrown from dfo.cxx:1419, Err# 0, tid 5 origtid 5
  I. 03/20 12:58:24. 0000000304 O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006001, SQLState: 'QBA01', Severity: 23
  I. 03/20 12:58:24. 0000000304 [20239]: IQ Internal error. Please report this to Sybase IQ support

• SAP SYBASE IQ 15.x

crash, abort, SQL error, DFO,  dfo.cxx:1441, dfo.cxx:1419 , , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed