SAP Knowledge Base Article - Preview

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

Symptom

  • 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:21. 0000000304 [20919]:
    Delete of 0 rows completed for table: _smart2_temp_p_clic_ca, 0 seconds.
    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:23. 0000000631 Txn 4161889 0 4161889
    I. 03/20 12:58:23. 0000000631 Cmt 4161890
    I. 03/20 12:58:23. 0000000631 PostCmt 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


Read more...

Environment

  • SAP SYBASE IQ 15.x

Product

SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

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

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.