2650292 - Server raises a fatal error with a query that includes union all & order by a constant (null) - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2650292 - Server raises a fatal error with a query that includes union all & order by a constant (null) - SAP IQ

Symptom

Server raises a fatal error with a query that includes union all & order by a constant (null).

 **************************************************
 *** Sybase IQ Abort:
 *** From: st_server.cxx:1440
 *** PID: 15435
 *** Message: caught signal 11, program abort
 *** Thread: 3728131840 (TID: 4)
 **************************************************

 ** Error from IQ connection: SA connHandle: 1 SA connID: 15 IQ connID: 0000000015 User: XXXXX
 ** Time of error: 2018-05-23 14:58:59
 ** IQ Version: Sybase IQ/15.4.0/151121/P/ESD 7
 ** OS info: IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5, Executed on: Linux/XXXXXXXXX/3.0.101-108.21-default/#1 SMP Fri Dec 29 10:25:37 UTC 2017 (5f5299b)/x86_64
 ** Command status when error occured: CURSOR ACTIVE
 ** Command text:

 Dump all thread stacks at st_server.cxx:1440 for PID: 15435


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

===== Thread Number 3728131840 (IQ connID: 0000000015) =====
 pc: 0x7fffdbf9ec86 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x36
 pc: 0x7fffdbf9eec1 ucstkgentrace(int, int)+0x111
 pc: 0x7fffdbf9ff41 DumpAllThreads(char const*, unsigned int, int)+0x111
 pc: 0x7fffdbd683ef hos_ABORT(char const*, unsigned int, char const*, char*, char*)+0x18f
 pc: 0x7fffdc8217bf SigHndlr+0x4f
 pc: 0x7ffff6821850 typeinfo+0x1b3dd841
 pc: 0x7fffdc048a97 opt_Driver::TransferNodeInfoToChild(dfo*, dfo*)+0x157
 pc: 0x7fffdc04c70d opt_Driver::ExciseAndDestroyAnOrderBy(dfo*, dfo_OrderBy*, unsigned int)+0x2cd
 pc: 0x7fffdc04c892 opt_Driver::EliminateNullOrderBy(dfo*)+0x132
 pc: 0x7fffdc04c847 opt_Driver::EliminateNullOrderBy(dfo*)+0xe7
 pc: 0x7fffdc0618d8 opt_Driver::ApplyDFOTreeTransforms(dfo_Root*, df_Heap*, int)+0x6d8
 pc: 0x7fffdc062d96 opt_Driver::GenerateTree(QueryNode*, st_cursor*)+0x866
 pc: 0x7fffdc772012 st_cursorIQtoSA::Parse()+0xd2
 pc: 0x7fffdbad0413 df_OpenCursor::Parse()+0x83
 pc: 0x7fffdc75cf43 st_command::DoCmdThroughResourceGate()+0x43
 pc: 0x7fffdc7f4955 st_iqdml::OpenCursor(a_statement*, UIConnection*, UICursor*, a_cursor_spec*, a_cursor_orientation)+0x25
 pc: 0x7fffdc006f05 UIQDML_OpenCursor+0x25
 pc: 0x7fffdc81fe26 st_SAIQInterfaceInfo::callFunction()+0x26
 pc: 0x7fffdc81f509 st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x189
 pc: 0x7fffdc8207cd st_SAIQInterface::Execute(int, void*, unsigned int (*)(void*, void*), void*, unsigned int)+0x20d
 pc: 0x7fffdc0f0cc1 saint_iqthresholddml::OpenCursor(a_statement*, IConnection*, ICursor*, a_cursor_spec*, a_cursor_orientation)+0x91
 pc: 0x7ffff711fe29 df_OmniRowScan::Restart(a_cursor_orientation)+0x1c9
 pc: 0x7ffff70ff222 dfo_Scan::DoFetch(a_cursor_orientation)+0xc2
 pc: 0x7ffff70fe4d2 dfo_Scan::DoFirstFetch(a_cursor_orientation)+0xd2
 pc: 0x7ffff70e9002 dfo_Base::Fetch(a_cursor_orientation)+0x102
 pc: 0x7ffff70ec39b dfo_Root::DoFetch(a_cursor_orientation)+0x4b
 pc: 0x7ffff70eab2a dfo_Root::DoFirstFetch(a_cursor_orientation)+0x1a
 pc: 0x7ffff70e9002 dfo_Base::Fetch(a_cursor_orientation)+0x102
 pc: 0x7ffff70eb6b5 dfo_Root::DoFetchRelative(int, int*)+0xc5
 pc: 0x7ffff70eceb7 dfo_Root::FetchRelative(int, int*)+0xd7
 pc: 0x7ffff6e2264d DB_Search_fetch(a_db_cursor*, unsigned int, int, int*)+0x7d
 pc: 0x7ffff6f27d82 do_move_cursor(a_db_cursor*, int, unsigned int, unsigned int, unsigned int)+0x92
 pc: 0x7ffff6f2abe8 dbi_fetch(a_db_cursor*, int, unsigned short, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int)+0x2d8
 pc: 0x7ffff6fff26d db__fetch(Connection*, an_sqlpres_receive*)+0x1bd
 pc: 0x7ffff70164fe RequestProcedure::call()+0xcfe
 pc: 0x7ffff6eb2c3e Context::call(Procedure*, Context**)+0x4e
 pc: 0x7ffff6eb2d26 Worker::call_on_stack(Procedure*)+0x56
 pc: 0x7ffff701213d TopProcedure::call()+0x3d
 pc: 0x7ffff6eb4669 Worker::spawn(Procedure*)+0x49
 pc: 0x7ffff701263e EngStream::handle_ind(unsigned char, unsigned int)+0x13e
 pc: 0x7ffff7014e04 EngStream::execute()+0xca4
 pc: 0x7ffff7011485 RQBaseItem::do_work(Worker*)+0x25
 pc: 0x7ffff703e4a6 RequestQueue::worker_body()+0x66
 pc: 0x7ffff7011dc5 request_task(void*)+0x65
 pc: 0x7ffff74599dd run_task_body+0x2d
 pc: 0x7ffff703efe7 UnixTask::pre_body(void*)+0x77
 pc: 0x7ffff6819806 typeinfo+0x1b3d57f7
 pc: 0x7ffff5d7469d typeinfo+0x1a93068e
I. 05/23 14:58:59. 0000000000
===== Thread Number 3726554880 =====
I. 05/23 14:58:59. 0000000000 pc: 0x7fffdbf9ec86 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x36
I. 05/23 14:58:59. 0000000000 pc: 0x7fffdbf9eec1 ucstkgentrace(int, int)+0x111
I. 05/23 14:58:59. 0000000000 pc: 0x7ffff6821850 typeinfo+0x1b3dd841
I. 05/23 14:58:59. 0000000000 pc: 0x7ffff681d66c typeinfo+0x1b3d965d
I. 05/23 14:58:59. 0000000000 pc: 0x7ffff703ed85 UnixTask::wait(unsigned short)+0x9


Read more...

Product

SAP Sybase IQ 15.4

Keywords

EliminateNullOrderBy, TransferNodeInfoToChild , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.