SAP Knowledge Base Article - Preview

3111279 - IQ crashed with simple select MAX query - IQ

Symptom

Server crashed on a simple select

select "max"("FILENAME") --top 10 *   from "dbo"."my_table_test"   where 1 = 1

with stack trace:

    **  Error from IQ connection:  SA connHandle: 371189  SA connID: 29  IQ connID: 0009585011  User: XXXXXX
    **  Time of error:  2021-10-01 09:16:31
    **  IQ Version:  SAP IQ/16.1.040/14465/P/SP04.07
    **  OS info:  IQ built on: Sun_Sparc/OS 5.11,  Executed on: SunOS/XXXXXXX/5.11/11.4.26.75.4/sun4v
    **  Command status when error occurred:  CURSOR ACTIVE
    **  Command text:  
select "max"("FILENAME") --top 10 *    from "dbo"."my_table_test"   where 1 = 1
    **  Dump all thread stacks at stcxtlib/st_server.cxx:2452 for PID: 8694

***************** This is the STACKTRACE ***************

===== Thread Number 291 (IQ connID: 0009585011) =====
pc: 0 <unknown>(fffffffedca87c98, 0, 0, fffffffedca87c98, 1)
pc: fffffffed701830c void DumpAllThreads(const char*,unsigned,int)+0x6b4(0, fffffffed991c4f8, fffffffed991d3a0, fffffffedca86a4b, 1ffff0602180f0)
pc: fffffffed6b7b7a0 void hos_ABORT(const char*,unsigned,const char*,char*,char*,sigcontext*)+0x6f0(fffffffed605a471, 994, fffffffedca8ae50, 1, fffffffedca895f4)
pc: fffffffed7ee88d8 SigHndlr+0x48(b, fffffffffc8d42e1, 372bc00, fffffffed9786170, 0)
pc: ffffffff7e0dc7a0 <unknown>(b, fffffffedca8b580, fffffffedca8b270, fffffffed7ee8890, 0)
pc: ffffffff7e0cf1dc <unknown>(0, fffffffedca8b580, 0, ffffffff7ea40a40, b)
pc: ffffffff7e0cf534 <unknown>(b, fffffffedca8b580, fffffffedca8b270, ffffffec02120030, ffffffec0213fff8)
pc: 1ffff10a740f64 <unknown>(fffffffedca8bbf0, fffffffed9853228, 1, cd000, 0)
pc: fffffffed79f7d8c int hs_subohc::Max(const s_bm*,void*,int*,int,int,s_bm&,s_indexFindContext*)+0x664(fffffffedca8bda8, fc00, 1ffff10e87bca0, fffffffedca8c66c, 1)
pc: fffffffed79f8234 int hs_ohc::Max(const s_bm&,void*,int*,int,s_bm&,s_indexFindContext*)+0xec(1ffff10187e4f8, 1ffff06d47b390, 1ffff06d803e30, fffffffedca8c66c, 0)
pc: fffffffed8216754 int s_fetchGroup::Fetch()+0x2a7c(1ffff072d0e978, 1ffff11a7dba20, fffffffed614922e, 1ffff10187e4f8, 1ffff063f49df8)
pc: fffffffed820ca98 int vp_Cursor::Fetch()+0xb0(1ffff074b21608, fffffffed820c9a8, 14b42c, ffffffffffffff9c, 18)
pc: fffffffed67f0d6c int dfo_Root::FetchOpus()+0x30c(1ffff06c9ab280, 0, 18028, 1ffff14d72d6a8, 1ffff07724ec48)
pc: fffffffed7e737c4 void st_cursorIQtoSA::FetchRows(unsigned)+0x9c(1ffff10a740ed0, 1ffff06c9ab280, 0, 1ffff14d72d6a8, 18028)
pc: fffffffed7e73408 void st_cursorIQtoSA::Execute()+0x470(1ffff10a740ed0, 1ffff10a740ed0, 1, 0, 1ffff07721aec0)
pc: fffffffed6508aac void df_OpenCursor::Execute()+0x74(fffffffedca8f4c8, fffffffed99519e8, 1fffef00286bf0, 4, fffffffed6508a38)
pc: fffffffed7e64ed0 void st_command::DoCmdThroughResourceGate()+0x340(fffffffedca8f4c8, 14b400, 14b42c, fffffffed98d159c, 1ffff0726aeff0)
pc: fffffffed7eddbd4 unsigned st_iqdml::OpenCursor(a_statement*,UIConnection*,UICursor*,a_cursor_spec*,a_cursor_orientation)+0x54(1fffef00287af8, fffffffedca8f4c8, fffffffef13e3808, fffffffef0fe8408, ffffffff3855a338)
pc: fffffffed647230c UIQDML_OpenCursor+0x20(1fffef00287af8, fffffffedca92560, fffffffed7eddb80, fffffffed9954c28, 0)
pc: fffffffed7ee9ca8 void st_SAIQInterfaceInfo::callFunction()+0x20(fffffffedca92480, fffffffed6472b38, fffffffed64722ec, fffffffed9786170, fffffffedca92480)
pc: fffffffed7f6fee0 void st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x200(1ffff12a74be80, 1ffff12a74be80, fffffffed9786170, fffffffedca92480, fffffffed6081d7c)
pc: fffffffed7eea644 void st_SAIQInterface::Execute(int,void*,unsigned(*)(void*,void*),void*,unsigned)+0x424(1ffff12a74bf98, fffffffed64718b0, 1ffff07721aec0, 1ffff12a74bf58, 1ffff12a74bf98)
pc: fffffffed70370e0 unsigned saint_iqthresholddml::OpenCursor(a_statement*,IConnection*,ICursor*,a_cursor_spec*,a_cursor_orientation)+0x88(1fffef00287af8, ffffffff15555ca0, fffffffef13e3808, fffffffef0fe8408, ffffffff3855a338)
pc: ffffffff71a918dc dfo::Status df_OmniRowScan::Restart(a_cursor_orientation)+0x2ac(ffffffff3855a310, 1, 1a800, ffffffff15555ca0, fffffffef1313048)
pc: ffffffff71a4e8d0 dfo::Status dfo_Scan::DoFetch(a_cursor_orientation)+0x70(ffffffff71a91630, 1, ffffffff153b7a00, ffffffff728da588, fffffffef13e3808)
pc: ffffffff71a4e830 dfo::Status dfo_Scan::DoFirstFetch(a_cursor_orientation)+0x43c(0, 1, ffffffff71a4e860, fffffffef1072c08, ffffffff71a4e0e8)
pc: ffffffff71a1ab9c dfo::Status dfo_Base::Fetch(a_cursor_orientation)+0xcc(ffffffff153b7a00, ffffffff7295f450, 1, fffffffedca92a20, 1)
pc: ffffffff71a208ec dfo::Status dfo_Root::DoFetch(a_cursor_orientation)+0x264(ffffffff153b7580, 1, 1019e8820, 5cd462bf2c3c0, fffffffef15f1008)
pc: ffffffff71a1fc50 dfo::Status dfo_Root::DoFirstFetch(a_cursor_orientation)+0x50(ffffffff153b7580, ffffffff71a20688, ffffffff72955cc0, 104908, 1)
pc: ffffffff71a1ab9c dfo::Status dfo_Base::Fetch(a_cursor_orientation)+0xcc(ffffffff153b7580, ffffffff72955cc0, 1, 20, 1)
pc: ffffffff71a28380 a_search_status dfo_Root::DoFetchRelative(int,int*)+0xd8(ffffffff153b7580, 1, fffffffedca92e0c, 1, 1)
pc: ffffffff71a281b8 a_search_status dfo_Root::FetchRelative(int,int*)+0x40(ffffffff153b7580, 1, fffffffedca92e0c, 4, ffffffff71a282a8)
pc: ffffffff7155f09c unsigned dbi_fetch(a_db_cursor*,int,unsigned short,unsigned,unsigned,unsigned,unsigned,unsigned,unsigned)+0x3bc(800000, fffe, ffffffff72956170, fffffffef13e3808, 0)
pc: ffffffff717e0060 void do_cursor_execute(Connection*,a_stmt*)+0x5f0(fffffffef13e3808, fffffffef1406cc8, fffffffef1406cc8, ffffffff49ffc330, 1)
pc: ffffffff717e0ef0 void db__execute_any_imm(Connection*,an_sqlpres_receive*)+0x248(fffffffef13e3808, fffffffedca93220, fffffffef1494408, 102b1e7e3, ffffffff415682d0)
pc: ffffffff718106a0 void do_request(Worker*,an_sqlpres_receive*)+0x168(70, fffffffedca93220, ffffffff718102e8, c, fffffffef13e3808)
pc: ffffffff71804f80 void RequestProcedure::call()+0x820(fffffffedca93798, 1f, ffffffff728f3b74, fffffffedca93220, ffffffff728da588)
pc: ffffffff713ed714 int Worker::spawn(Procedure*)+0x74(10021fb80, fffffffedca93798, fffffffef104d108, 0, ffffffff728da588)
pc: ffffffff71808358 void EngStream::execute()+0xa30(1019e8820, fffffffedca93a07, 100ae1ea0, ffffffff728f3ba0, ffffffff728f3ba8)
pc: ffffffff71808e54 void RQConnItem::do_request()+0x4(1019e8928, ff000000, ffffffff7e22a940, ffffffff7ea40a40, ffffffff7ea40a40)
pc: ffffffff71809854 unsigned RQBaseItem::do_work(Worker*)+0x24(1019e8928, 10021fb80, 0, ff000000, 0)
pc: ffffffff718bb8e4 void RequestQueue::worker_body()+0x284(ffffffff72910a90, ffffffff72945bd0, 10021fb80, ffffffff728da588, ffffffff71809830)
pc: ffffffff718097f0 void request_task(void*)+0x138(918, 166958, 166800, ffffffff728da588, ffffffff72a40ee0)
pc: ffffffff718bfb04 void*UnixTask::pre_body(void*)+0x294(10021fa70, fffffffedca93f06, 1, 0, 2000)


Read more...

Environment

SAP IQ 16.1 SP04 PL07

Product

SAP IQ 16.1

Keywords

int hs_subohc; MAX; stcxtlib/st_server.cxx; 2452 , 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.