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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.