SAP Knowledge Base Article - Preview

2650051 - An insert working on SAP IQ 16.1-SP02 fails on PL08 with optlib/opt_Union.cxx error and stacktrace - SAP IQ

Symptom

Problem – query fails with optlib/opt_Union.cxx error

I. 04/16 12:26:59. 0000183201 Cmt 123353872
I. 04/16 12:26:59. 0000183201 PostCmt 0
I. 04/16 12:26:59. 0000182973
I. 04/16 12:26:59. 0000182973 ********************************************************
I. 04/16 12:26:59. 0000182973 **
I. 04/16 12:26:59. 0000182973 ** Non-Fatal IQ Internal Error Detected
I. 04/16 12:26:59. 0000182973 ** at optlib/opt_Union.cxx:1211 on thread 140510347978496 (TID 6)
I. 04/16 12:26:59. 0000182973 **
I. 04/16 12:26:59. 0000182973 ** Please report this to SAP IQ support
I. 04/16 12:26:59. 0000182973 ** with the following diagnostic information,
I. 04/16 12:26:59. 0000182973 ** and, if possible, with the user's command.
I. 04/16 12:26:59. 0000182973 **
I. 04/16 12:26:59. 0000182973 ** Error from IQ connection: SA connHandle: 40346 SA connID: 55 IQ connID: 0000182973 User: XXXXX
I. 04/16 12:26:59. 0000182973 ** Time of error: 2018-04-16 12:26:59
I. 04/16 12:26:59. 0000182973 ** IQ Version: SAP IQ/16.1.030/10645/P/sp03
I. 04/16 12:26:59. 0000182973 ** OS info: IQ built on: Linux/Linux64 - x86_64 - 3.10.0-327, Executed on: Linux/XXXXXXX/3.10.0-693.17.1.el7.x86_64/#1 SMP Thu Jan 25 20:13:58 UTC 2018/x86_64
I. 04/16 12:26:59. 0000182973 ** Command status when error occured: CURSOR ACTIVE
I. 04/16 12:26:59. 0000182973 ** Command text:

I. 04/16 12:26:59. 0000182973
***************** This is the STACKTRACE ***************

I. 04/16 12:26:59. 0000182973

===== Thread Number 140510347978496 (IQ connID: 0000182973) =====

I. 04/16 12:26:59. 0000183231 [20919]:
Delete of 90711 rows completed for table: debt_temp, 0 seconds.
I. 04/16 12:26:59. 0000182973 pc: 0x7fcb193f3d98 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x38
I. 04/16 12:26:59. 0000182973 pc: 0x7fcb193f45cd ucstkgentrace(int, int)+0x13d
I. 04/16 12:26:59. 0000182973 pc: 0x7fcb193f5541 StackTraceForThisThread(char const*, int, char const*, char const*, char const*)+0x341
I. 04/16 12:26:59. 0000182973 pc: 0x7fcb18bd1785 df_Exception::df_Exception(char const*, int, df_Exception::df_ErrorCode, char const*, char const*, dfo const*, df_Evaluable const*)+0x1315
I. 04/16 12:26:59. 0000182973 pc: 0x7fcb18bd271b df_Exception::ThrowException_0(char const*, int, df_Exception::df_ErrorCode)+0x3b
I. 04/16 12:26:59. 0000182973 pc: 0x7fcb191412ec opt_Union::EliminateUnneededUnionArms(df_Heap*)+0xb0c
I. 04/16 12:26:59. 0000182973 pc: 0x7fcb190e7f37 opt_QueryExp::OptimizeQueryBlockTree(df_Heap*)+0x47
I. 04/16 12:26:59. 0000182973 pc: 0x7fcb1912099b opt_Select::OptimizeQueryBlockTree(df_Heap*)+0x8b
I. 04/16 12:26:59. 0000182973 pc: 0x7fcb18fc2ff3 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*)+0xfb3
I. 04/16 12:26:59. 0000182973 pc: 0x7fcb19f68adf st_cursorIQtoSA::Parse()+0x50f
I. 04/16 12:26:59. 0000182973 pc: 0x7fcb18c26382 df_OpenCursor::Parse()+0xb2
I. 04/16 12:26:59. 0000182973 pc: 0x7fcb19f6038f st_command::DoCmdThroughResourceGate()+0x2f
I. 04/16 12:26:59. 0000182973 pc: 0x7fcb19fae852 st_iqdml::OpenCursor(a_statement*, UIConnection*, UICursor*, a_cursor_spec*, a_cursor_orientation)+0x32
I. 04/16 12:26:59. 0000182973 pc: 0x7fcb18bc4065 UIQDML_OpenCursor+0x25
I. 04/16 12:26:59. 0000182973 pc: 0x7fcb19fb4ddb st_SAIQInterfaceInfo::callFunction()+0x1b
I. 04/16 12:26:59. 0000182973 pc: 0x7fcb1a01cf77 st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x1d9
I. 04/16 12:26:59. 0000182973 pc: 0x7fcb19fb5283 st_SAIQInterface::Execute(int, void*, unsigned int (*)+0x353
I. 04/16 12:26:59. 0000182973 pc: 0x7fcb19405bcb saint_iqthresholddml::OpenCursor(a_statement*, IConnection*, ICursor*, a_cursor_spec*, a_cursor_orientation)+0x8b
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc86e7fe df_OmniRowScan::Restart(a_cursor_orientation)+0x1ce
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc850068 dfo_Scan::DoFetch(a_cursor_orientation)+0xb8
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc84fbcb dfo_Scan::DoFirstFetch(a_cursor_orientation)+0x9b
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc835387 dfo_Base::Fetch(a_cursor_orientation)+0xa7
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc83de74 dfo_Root::DoFetch(a_cursor_orientation)+0x44
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc83e080 dfo_Root::DoFirstFetch(a_cursor_orientation)+0x30
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc835387 dfo_Base::Fetch(a_cursor_orientation)+0xa7
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc83657d dfo_Root::DoFetchRelative(int, int*)+0xbd
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc839631 dfo_Root::FetchRelative(int, int*)+0x91
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc428465 DB_Search_fetch(a_db_cursor*, unsigned int, int, int*)+0x65
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc5b6db2 dbi_fetch(a_db_cursor*, int, unsigned short, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int)+0xe2
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc71a462 db__fetch(Connection*, an_sqlpres_receive*)+0x1b2
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc738946 RequestProcedure::call()+0xe46
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc4ec3c1 Worker::spawn(Procedure*)+0x31
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc73c656 EngStream::handle_ind(unsigned char, unsigned int)+0x156
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc73e14f EngStream::execute()+0x81f
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc73e2cd RQConnItem::do_request()+0xd
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc7362ae RQBaseItem::do_work(Worker*)+0x1e
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc779437 RequestQueue::worker_body()+0x77
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc7376ad request_task(void*)+0xdd
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbcbadeee run_task_body+0x1e
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbc77ae4f UnixTask::pre_body(void*)+0x5f
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbbd43e25 __do_global_dtors_aux_fini_array_entry+0x9feb9e05
I. 04/16 12:26:59. 0000182973 pc: 0x7fccbb26334d __do_global_dtors_aux_fini_array_entry+0x9f3d932d
I. 04/16 12:26:59. 0000182973 ******************* End of STACKTRACE ******************
I. 04/16 12:26:59. 0000182973 **
I. 04/16 12:26:59. 0000182973 ** End of stack trace from Non-Fatal IQ Internal Error optlib/opt_Union.cxx:1211
I. 04/16 12:26:59. 0000182973 **
I. 04/16 12:26:59. 0000182973 ********************************************************
I. 04/16 12:26:59. 0000182973
I. 04/16 12:26:59. 0000182973 Exception Thrown from optlib/opt_Union.cxx:1211, Err# 0, tid 6 origtid 6
I. 04/16 12:26:59. 0000182973 O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
I. 04/16 12:26:59. 0000182973 [20238]: IQ Internal error. Please report this to SAP IQ support.
-- (optlib/opt_Union.cxx 1211)


Read more...

Environment

SAP IQ16.1 SP02 PL08

Product

SAP IQ 16.1

Keywords

CR814789, CR#814789, 814789, opt_Union::EliminateUnneededUnionArms , 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.