3751443 - Alter database upgrade crashes with stack trace cache functions - SAP IQ

• During an upgrade running "ALTER DATABASE UPGRADE" leads to a crash with a stack trace and termination at severity level 5.

• 1>  ALTER DATABASE UPGRADE

  2> go

  Database upgrade started

  Upgrading existing procedures

  Open Client Message

  Layer 5, Origin 3, Severity 5, Number 6

  ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect

  UATIQ3W98M7: Aborting on severity 5

  I. 05/08 10:41:22. 0000000016 **************************************************

  I. 05/08 10:41:22. 0000000016 ***   SAP IQ Abort:

  I. 05/08 10:41:22. 0000000016 ***      From:  stcxtlib/st_server.cxx:2643

  I. 05/08 10:41:22. 0000000016 ***      PID: 10179

  I. 05/08 10:41:22. 0000000016 ***      Message: caught signal 8, program abort (pc=0x00007f68239b6579, sp=0x00007f67f0c49198, fp=0x00007f67f0c49610, addr=0x00007f68239b6579)

  I. 05/08 10:41:22. 0000000016 ***      Thread: 140084397799168  (TIX: 2)

  I. 05/08 10:41:22. 0000000016 **************************************************

  I. 05/08 10:41:22. 0000000016 

  I. 05/08 10:41:22. 0000000016 140084397799168 Stacktrace requested from stcxtlib/st_server.cxx:2643 on thread 140084397799168 (TIX 2) start stacktrace

  I. 05/08 10:41:22. 0000000016     **  Error from IQ connection:  SA connHandle: 6  SA connID: 16  IQ connID: 0000000016  Name: sqsh-3.0 User: etsybsa

  I. 05/08 10:41:22. 0000000016     **  Time of error:  2026-05-08 10:41:22

  I. 05/08 10:41:22. 0000000016     **  IQ Version:  SAP IQ/16.1.050/16610/P/SP05.16

  I. 05/08 10:41:22. 0000000016     **  OS info:  IQ built on: Linux/Linux64 - x86_64 - 3.10.0-327,  Executed on: Linux/uatdb3w98m7.etrade.com/3.10.0-1160.144.1.el7.x86_64/#1 SMP Mon Dec 15 12:12:52 EST 2025/x86_64

  I. 05/08 10:41:22. 0000000016     **  Command status when error occurred:  NO COMMAND OR CURSOR ACTIVE

  I. 05/08 10:41:22. 0000000016     **  Parser command text:

  I. 05/08 10:41:22. 0000000016 alter database upgrade

  I. 05/08 10:41:22. 0000000016     **  Dump all thread stacks at stcxtlib/st_server.cxx:2643 for PID: 10179

  I. 05/08 10:41:22. 0000000016 ***************** This is the STACKTRACE ***************

  I. 05/08 10:41:22. 0000000016 ===== Thread Number 140084397799168 (IQ connID: 0000000016) (IQSaintForbid: 1) =====

  I. 05/08 10:41:22. 0000000016 pc: 0x400e71 backtrace+21

  I. 05/08 10:41:22. 0000000016 pc: 0x7f67eca8991c pcstkwalk(stk_trace*, int, db_log*, hos_fd*, unsigned long long)+3c

  I. 05/08 10:41:22. 0000000016 pc: 0x7f67eca8a0bb ucstkgentrace(int, int)+15b

  I. 05/08 10:41:22. 0000000016 pc: 0x7f67eca8aa4c DumpAllThreads(char const*, unsigned int, int)+2bc

  I. 05/08 10:41:22. 0000000016 pc: 0x7f67ec805821 hos_ABORT(char const*, unsigned int, char const*, char*, char*, sigcontext*, int, int)+4f1

  I. 05/08 10:41:22. 0000000016 pc: 0x7f67ed6727ec SigHndlr+11c

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68229e4630 <unknown>

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68239b6579 ut_throw_exception()+19

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6822ee79f3 DisplayMsgAndThrow(an_errmap_index, char*, Database*)+93

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6822ee8014 SA_Fatal(Database*, an_errmap_index, unsigned int, __va_list_tag*)+184

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6822ee88a2 DB_Fatal(Database*, an_errmap_index, unsigned int, ...)+82

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6823682286 CacheImpl::Panic(CacheInfo*)+2b6

  I. 05/08 10:41:22. 0000000016 pc: 0x7f682368251b CacheImpl::Alloc()+16b

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6823682a15 CacheImpl::Install(a_cache_name, bool, bool)+f5

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6823682b05 CacheImpl::Install(IDatabaseFile*, unsigned int)+25

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68237e7802 DatabaseFile::NewPage(unsigned int)+52

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68237e6ba4 DatabaseFile::alloc_page(a_page_type, unsigned int, unsigned int)+34

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68237ec077 alloc_temp_page(Database*, a_page_type)+17

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6822ed683d RelocatableHeap::alloc_page(Database*, a_heap_type, Worker*)+13d

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6822ed696e RelocatableHeap::alloc_page()+1e

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6822ed72aa RelocatableHeap::Alloc(unsigned long, unsigned int)+27a

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68237392bd SQLParser::InitBaseExpr(int, an_allocation_type, unsigned short, unsigned int)+2d

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6823739d05 SQLParser::pa_column_common(char*, char*, char*)+45

  I. 05/08 10:41:22. 0000000016 pc: 0x7f682373b691 SQLParser::pa_indirect_column_full(char*, unsigned int, char*, unsigned int, char*, unsigned int)+21

  I. 05/08 10:41:22. 0000000016 pc: 0x7f682373b7b3 SQLParser::pa_resolve_dots_as_column(a_base_expr*)+63

  I. 05/08 10:41:22. 0000000016 pc: 0x7f682373b9d0 SQLParser::pa_dotted_suffix_expr(unsigned int, a_base_expr*, a_column*)+d0

  I. 05/08 10:41:22. 0000000016 pc: 0x7f682378a974 SQLParser::actions(unsigned int, yystype*)+c7c4

  I. 05/08 10:41:22. 0000000016 pc: 0x7f682378fee5 SQLParser::yyparse()+3c5

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68236fb90f PSpawns(void (*)(void*), void*, __jmp_buf_tag (**) [1])+3f

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68236fbac2 SQLParser::Parse(UTIStream&, unsigned int, a_parse_status*, a_statement**)+72

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68236fbc30 ParseSupport::StringToCommand(UTIStream&, Connection*, IDBHeap*, a_parse_parms*, a_parse_status*, a_statement**, unsigned int, SQLFlagger*)+50

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68231a05da parse(a_statement_heap_ref*, dfv_Value const&, a_parse_goal, unsigned int*, unsigned int, unsigned int, unsigned int*, SQLFlagger*, char const*, a_parser_dialect)+47a

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68231a11d1 PrepareStringUsingHeap(a_statement_heap_ref*, dfv_Value const&, a_parse_goal, unsigned int*, unsigned int, unsigned int, SQLFlagger*, char const*, a_parser_dialect)+51

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68231a15cb PrepareStringAgain(a_statement_heap_ref*, dfv_Value const&, a_parse_goal, unsigned int*, a_parser_dialect)+2b

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6822f3afe0 load_proc_definition(df_SysCursor*, unsigned int*)+670

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6822f3c0ee load_proc_by_name(char*)+6e

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6822f3d3bb DB_Load_procedure(unsigned int*, char*, unsigned int, an_errmap_index*, unsigned int)+2fb

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6823108ffb Lookup_procedure(unsigned int, char*, an_errmap_index*)+2b

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6823109206 populate_v17_1_sysproc_columns(Database*, Connection*)+156

  I. 05/08 10:41:22. 0000000016 pc: 0x7f682307edf1 sp_populate_sysproc(InternalProcCall&)+21

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6823080d1e RunInternalProcedure(Connection*, a_context_ref*)+19e

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68230ffacb process_ext_int_remote_call(Connection*, a_context_ref*, unsigned int, dfm_CallInfo*)+24b

  I. 05/08 10:41:22. 0000000016 pc: 0x7f682310353b exec_procedure_stmt(Connection*, a_context_ref*, a_statement*, unsigned int, unsigned int)+2d5b

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6823104610 run_procedure(a_context_ref*, dfm_CallInfo*, unsigned int, Connection*, unsigned int)+310

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6823105b07 call_procedure(Connection*, a_proc_def*, a_trigger_def*, a_base_expr*, a_procedure_arg*, unsigned int, a_db_cursor*, bool, a_statement*, a_call*)+117

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6823108167 dbi_stmt_batch(a_statement*, a_procedure*, bool, unsigned int)+1a7

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68231c2195 DoExecuteBodyLocal(Connection*, a_stmt*, a_statement*, a_stmt_identifier*, bool, unsigned int, unsigned short)+1645

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68231c35de DoExecuteStmt(Connection*, a_stmt*, a_statement*, a_stmt_identifier*, unsigned short, unsigned int, unsigned int)+dce

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68231c59d6 db__execute_str(Connection*, dfv_Value const&, unsigned int, unsigned int, unsigned int)+176

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68230d1263 Exec_Statement(char const*, char*, int, dfv_Value, void (*)(Database*, dfv_Value const&), Database*)+93

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68230d335e Exec_SQL_Script(char const*, void (*)(Database*, dfv_Value const&), Database*)+20e

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6822deace7 Exec_SQL_Script_and_check_for_cancel(Connection*, char const*)+10

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6822deb15e do_system_upgrade(an_upgrade_database*, DBCapabilities const&)+44b

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68230d6598 dbi_upgradedatabase(Connection*, a_statement*)+1558

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68231c1fb9 DoExecuteBodyLocal(Connection*, a_stmt*, a_statement*, a_stmt_identifier*, bool, unsigned int, unsigned short)+1469

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68231c35de DoExecuteStmt(Connection*, a_stmt*, a_statement*, a_stmt_identifier*, unsigned short, unsigned int, unsigned int)+dce

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68231c738f db__execute_any_imm(Connection*, an_sqlpres_receive*)+11f

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68231db896 RequestProcedure::call()+eb6

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6822f7d9b1 Worker::spawn(Procedure*)+31

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68231df786 EngStream::handle_ind(unsigned char, unsigned int)+156

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68231e12bf EngStream::execute()+7ff

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68231e143d RQConnItem::do_request()+d

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68231d91de RQBaseItem::do_work(Worker*)+1e

  I. 05/08 10:41:22. 0000000016 pc: 0x7f682321d147 RequestQueue::worker_body()+77

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68231da599 request_task(void*)+89

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68236667be run_task_body+1e

  I. 05/08 10:41:22. 0000000016 pc: 0x7f682321eda8 UnixTask::pre_body(void*)+78

  I. 05/08 10:41:22. 0000000016 pc: 0x7f68229dcea5 <unknown>

  I. 05/08 10:41:22. 0000000016 pc: 0x7f6821ef7b0d clone+6d

  ---

• srvlog shows:

  I. 05/08 10:41:13.626833 <,38,CONNECT

  I. 05/08 10:41:13.626876 E,38,-102,Database server connection limit exceeded

  I. 05/08 10:41:13.626902 >,38

  I. 05/08 10:41:15.037858 <,6,EXEC_ANY_IMM,drop connection 1

  I. 05/08 10:41:15.038302 User "etsybsa" dropped connection 1 ("ACTIMIZE_ETL")

  I. 05/08 10:41:15.038378 Connection terminated abnormally

  I. 05/08 10:41:15.038425 Disconnected TCPIP client's AppInfo: HOST=uat31w70m15.etrade.com;EXE=tomcat1

  I. 05/08 10:41:15.038469 >.,6

  I. 05/08 10:41:18.544986 <,39,CONNECT

  I. 05/08 10:41:18.547911 E,39,-102,Database server connection limit exceeded

  I. 05/08 10:41:18.548002 >,39

  I. 05/08 10:41:20.233677 <,6,EXEC_ANY_IMM,alter database upgrade

  I. 05/08 10:41:20.245690 Starting checkpoint of "UATIQ3W98M7" (UATIQ3W98M7.db) at Fri May 08 2026 10:41:20.245

  I. 05/08 10:41:20.287758 Finished checkpoint of "UATIQ3W98M7" (UATIQ3W98M7.db) at Fri May 08 2026 10:41:20.287

  I. 05/08 10:41:21.762292 Cache size adjusted to 196844K

  I. 05/08 10:41:21.775899 Cache size adjusted to 197868K

  I. 05/08 10:41:21.777454 Cache size adjusted to 198892K

  I. 05/08 10:41:21.779053 Cache size adjusted to 199916K

  I. 05/08 10:41:21.781002 Cache size adjusted to 200940K

  I. 05/08 10:41:21.782688 Cache size adjusted to 202864K

  …

  …

  I. 05/08 10:41:22.422939 Cache size adjusted to 254964K

  I. 05/08 10:41:22.435171 Cache size adjusted to 256012K

  I. 05/08 10:41:22.453264 Cache size adjusted to 257040K

  I. 05/08 10:41:22.455041 Cache size adjusted to 258072K

  I. 05/08 10:41:22.457396 Cache size adjusted to 259104K

  I. 05/08 10:41:22.498927 Cache size adjusted to 260152K

  I. 05/08 10:41:22.524745 Cache size adjusted to 260260K

  I. 05/08 10:41:22.544537 Dumping cache info to 'IQ_cache_10179.0.dmp' ...

  I. 05/08 10:41:22.562192 Completed dumping cache info

  I. 05/08 10:41:22.562315 Dumping cache info to 'IQ_cache_10179.1.dmp' ...

  I. 05/08 10:41:22.579311 Completed dumping cache info

  I. 05/08 10:41:26.173077 <,40,CONNECT

  I. 05/08 10:41:26.187931 Database server shutdown due to HUP signal

• IQ Version:  SAP IQ/16.1.050/16610/P/SP05.16

alter database upgrade, crash, stack trace, caught signal 8, SA_Fatal, CacheImpl::Panic, sql anywhere -1009058, no dbspaces open in readwrite mode, cache size adjusted, catalog cache, -c, -cl, -ch, iq upgrade, sap iq 16.1 sp05 , KBA , BC-SYB-IQ , Sybase IQ , Problem