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

Search for additional results

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