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.