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

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)

SAP IQ16.1 SP02 PL08

CR814789, CR#814789, 814789, opt_Union::EliminateUnneededUnionArms , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed