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

Search for additional results

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