SAP Knowledge Base Article - Preview

2264327 - SELECT with cursor crashes at st_server.cxx:1440 - SAP IQ

Symptom

Running a select with CURSOR on the server and getting the following stack traces: 

**  Error from IQ connection:  SA connHandle: 244959  SA connID: 68  IQ connID: 0000506194  User: user
**  Time of error:  2015-12-25 10:02:08   
**  IQ Version:  Sybase IQ/15.4.0/150610/P/ESD6   
**  OS info:  IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5,  Executed on: Linux/lx-chsybp383/2.6.32-504.16.2.el6.x86_64/#1 SMP Tue Mar 10 17:01:00 EDT 2015/x86_64   
**  Command status when error occured:  CURSOR ACTIVE   
**  Command text:
select SQL with date removed
Dump all thread stacks at st_server.cxx:1440 for PID: 19318
***************** This is the STACKTRACE **************
...
I. 04/01 12:54:23. 0000000186 pc: 0x7fffd71e385c s_fetchGroup::Fetch()+0x5fc
I. 04/01 12:54:23. 0000000186 pc: 0x7fffd6591180 dfo_VerticalLeafCursor::FetchOpus()+0x120
I. 04/01 12:54:23. 0000000186 pc: 0x7fffd6501c9a dfo_Cursor::FetchOpus()+0x10a
I. 04/01 12:54:23. 0000000186 pc: 0x7fffd656cdca dfo_Root::FetchOpus()+0x9a
I. 04/01 12:54:23. 0000000186 pc: 0x7fffd7009626 st_cursorIQtoSA::FetchRows(unsigned int)+0xd6
I. 04/01 12:54:23. 0000000186 pc: 0x7fffd700fea0 st_cursorIQtoSA::Execute()+0x100
I. 04/01 12:54:23. 0000000186 pc: 0x7fffd637811b df_OpenCursor::Execute()+0x3b
I. 04/01 12:54:23. 0000000186 pc: 0x7fffd6ffba82 st_command::DoCmdThroughResourceGate()+0x82
I. 04/01 12:54:23. 0000000186 pc: 0x7fffd7093205 st_iqdml::OpenCursor(a_statement*, UIConnection*, UICursor*, a_cursor_spec*, a_cursor_orientation)+0x25
I. 04/01 12:54:23. 0000000186 pc: 0x7fffd68afe35 UIQDML_OpenCursor+0x25
I. 04/01 12:54:23. 0000000186 pc: 0x7fffd70bdb46 st_SAIQInterfaceInfo::callFunction()+0x26
I. 04/01 12:54:23. 0000000186 pc: 0x7fffd70bd229 st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x189
I. 04/01 12:54:23. 0000000186 pc: 0x7fffd70be4ed st_SAIQInterface::Execute(int, void*, unsigned int (*)(void*, void*), void*, unsigned int)+0x20d
I. 04/01 12:54:23. 0000000186 pc: 0x7fffd69995b1 saint_iqthresholddml::OpenCursor(a_statement*, IConnection*, ICursor*, a_cursor_spec*, a_cursor_orientation)+0x91
I. 04/01 12:54:23. 0000000186 pc: 0x7ffff7349799 df_OmniRowScan::Restart(a_cursor_orientation)+0x1c9
I. 04/01 12:54:23. 0000000186 pc: 0x7ffff7328da2 dfo_Scan::DoFetch(a_cursor_orientation)+0xc2
I. 04/01 12:54:23. 0000000186 pc: 0x7ffff7328052 dfo_Scan::DoFirstFetch(a_cursor_orientation)+0xd2
I. 04/01 12:54:23. 0000000186 pc: 0x7ffff7312c22 dfo_Base::Fetch(a_cursor_orientation)+0x102
I. 04/01 12:54:23. 0000000186 pc: 0x7ffff7317eab dfo_Root::DoFetch(a_cursor_orientation)+0x4b
I. 04/01 12:54:23. 0000000186 pc: 0x7ffff731483a dfo_Root::DoFirstFetch(a_cursor_orientation)+0x1a
I. 04/01 12:54:23. 0000000186 pc: 0x7ffff7312c22 dfo_Base::Fetch(a_cursor_orientation)+0x102
I. 04/01 12:54:23. 0000000186 pc: 0x7ffff7314563 dfo_Root::DoFetchRelative(int, int*)+0xd3
I. 04/01 12:54:23. 0000000186 pc: 0x7ffff7316067 dfo_Root::FetchRelative(int, int*)+0xd7


Read more...

Environment

SAP Sybase IQ 15.4.0 #6  

Product

SAP Sybase IQ 15.4

Keywords

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.