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
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.
SAP Knowledge Base Article - Preview