SAP Knowledge Base Article - Preview

3108130 - "Alter database upgrade" causes crash during upgrade to IQ16.1SP05 or higher - SAP IQ

Symptom

Server crashes during upgrade from SAP IQ/16.0.sp11.22 Sun_Sparc/OS 5.10/64bit to  SAP IQ/16.1 SP05 Sun_Sparc/OS

**************************************************
***   SAP IQ Abort:
***      From:  stcxtlib/st_server.cxx:2462
***      PID: 5472
***      Message: caught signal 10, program abort
***      Thread: 609  (TID: 3)

Stacktrace requested from stcxtlib/st_server.cxx:2462 on thread 609 (TID 3) start stacktrace
**  Error from IQ connection:  SA connHandle: 2  SA connID: 6  IQ connID: 0000000070  User: XXXXX

**  Parser command text:
alter database upgrade
**  Dump all thread stacks at stcxtlib/st_server.cxx:2462 for PID: 5472
 
***************** This is the STACKTRACE ***************

===== Thread Number 609 (IQ connID: 0000000070) (IQSaintForbid: 1) =====
pc: 0 <unknown>(fffffffe729d85a8, 0, 0, fffffffffffffff8, 0)
pc: fffffffe6ec64074 void DumpAllThreads(const char*,unsigned,int)+76c(4, fffffffe715d1020, fffffffe715d0178, 7ffef6dffec40, 0)
pc: fffffffe6e7c08f4 void hos_ABORT(const char*,unsigned,const char*,char*,char*,sigcontext*,int,int)+6f4(fffffffe6dc84f71, 99e, fffffffe729db780, fffffffe714ba800, fffffffe729d9f04)
pc: fffffffe6fb75aec SigHndlr+54(a, fffffffffc84c4b1, 37b3800, fffffffe71438aa0, 0)
pc: ffffffff7dedcdd4 <unknown>(a, fffffffe729dbe80, fffffffe729dbba0, fffffffe6fb75a98, 0)
pc: ffffffff7decf7c4 <unknown>(0, fffffffe729dbe80, 0, ffffffff784afa40, a)
pc: ffffffff7decfb1c <unknown>(a, fffffffe729dbe80, fffffffe729dbba0, ffffffff676b1830, 1ac00)
pc: ffffffff669f1724 unsigned char dfv_Row::GetStrFirstByte(unsigned)const+34(fffffffe80419d88, c, ffffffff66a01360, ffffffff676b1830, fffffffe80419d88)
pc: ffffffff662a0d08 a_table_permission*dbi_load_table_perms(Database*,unsigned,unsigned,unsigned,a_table_permission**)+2e8(fffffffe80428008, c, fffffffe81abc208, ffffffff676309d8, fffffffe814202e8)
pc: ffffffff660c12a8 UserDef*Database::FindUserByID(unsigned)+6c8(fffffffe80428008, 170, fffffffe804196c8, ffffffff675e8f80, ffffffff660bb268)
pc: ffffffff66075c74 a_proc_def*load_proc_definition(df_SysCursor*,unsigned*)+4c4(fffffffe81ae0e88, fffffffe81aecbb8, 9c3, fffffffe80428014, ffffffff675ee704)
pc: ffffffff660761b4 a_proc_def*load_proc_by_name(char*)+4c(fffffffe813907e8, 22058, 22000, ffffffff675e8f80, 1)
pc: ffffffff66076c04 a_proc_def*DB_Load_procedure(unsigned*,char*,unsigned,an_errmap_index*,unsigned)+4ec(fffffffe729dca24, 103b540c8, fffffffe80428510, fffffffe81486868, ffffffff67613950)
pc: ffffffff663c9384 unsigned populate_v17_1_sysproc_columns(Database*,Connection*)+194(fffffffe80428008, fffffffe813907e8, 1, ffffffff65d733a0, ffffffff65d7339e)
pc: ffffffff6630ab64 int sp_populate_sysproc(InternalProcCall&)+58(fffffffe729dcce8, 726f6300, 20000000, ffffffff675e8f80, 18)
pc: ffffffff662ba794 void call_function(int(*)(InternalProcCall&),InternalProcCall&)+7c(ffffffff6630ab0c, fffffffe729dcce8, ffffffff65eb4b50, 73, 73)
pc: ffffffff662ba9f0 void RunInternalProcedure(Connection*,a_context_ref*)+98(fffffffe803a7808, fffffffe802d2cc8, 0, fffffffe80237dc8, 19400)
pc: ffffffff663b3ac0 void process_ext_int_remote_call(Connection*,a_context_ref*,unsigned,dfm_CallInfo*)+78(fffffffe803a7808, fffffffe729ddee8, 0, 0, 6500)
pc: ffffffff663c0744 unsigned run_procedure(a_context_ref*,dfm_CallInfo*,unsigned,Connection*,unsigned)+2148(ffffffff676841f8, ffffffff6774e318, fffffffe8041b7c8, fffffffe803a7808, fffffffe729ddee8)
pc: ffffffff663c6b98 void dbi_stmt_batch(a_statement*,a_procedure*,bool,unsigned)+268(0, fffffffe806c9008, fffffffe729ddee8, fffffffe806c9238, fffffffe80b4e088)
pc: ffffffff664de884 a_cursor*DoExecuteBodyLocal(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,bool,unsigned,unsigned short)+1b28(fffffffe803a7808, ffffffff675e8f80, 0, 0, 0)
pc: ffffffff664e0060 void DoExecuteStmt(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,unsigned short,unsigned,unsigned)+838(fffffffe803a7808, 0, ffffffff30f762d0, 0, 0)
pc: ffffffff664e2d58 void db__execute_str(Connection*,const dfv_Value&,unsigned,unsigned,unsigned)+140(fffffffe803a7808, fffffffe729e0c58, 1, fffffffe80428008, 1)
pc: ffffffff6636163c unsigned Exec_SQL_Script(const char*,void(*)(Database*,const dfv_Value&),Database*)+5fc(ffffffff65d7019f, 0, 67, ffffffff675e8f80, ffffffff67721db0)
pc: ffffffff663676fc unsigned Exec_SQL_Script_and_check_for_cancel(Connection*,const char*)+c(fffffffe803a7808, ffffffff65d7019f, 1002c4780, ffff, 1)
pc: ffffffff66369244 unsigned do_system_upgrade(an_upgrade_database*,const DBCapabilities&)+514(ffffffff323947a0, fffffffe729e2708, 8000000, ffffffff378ae000, fffffffe80428010)
pc: ffffffff6636b148 void dbi_upgradedatabase(Connection*,a_statement*)+17c0(fffffffe803a7808, 1, fffffffe8a274990, 200000, 1)
pc: ffffffff664dea18 a_cursor*DoExecuteBodyLocal(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,bool,unsigned,unsigned short)+1cbc(fffffffe803a7808, ffffffff675e8f80, ffffffff323942d0, fffffffe729e3088, ffffffff323947a0)
pc: ffffffff664e0060 void DoExecuteStmt(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,unsigned short,unsigned,unsigned)+838(fffffffe803a7808, 1, ffffffff323942d0, 0, fffffffe803040e8)
pc: ffffffff664e239c void db__execute(Connection*,an_sqlpres_receive*)+4c4(fffffffe803a7808, fffffffe729e3260, 0, 102e94e7b, ffffffff)
pc: ffffffff6651b464 void do_request(Worker*,an_sqlpres_receive*)+12c(54, fffffffe729e3260, ffffffff6651b0e8, 5, fffffffe803a7808)
pc: ffffffff6650fd80 void RequestProcedure::call()+820(fffffffe729e37d8, 18, ffffffff6760283c, fffffffe729e3260, ffffffff675e8f80)
pc: ffffffff660f6ed4 int Worker::spawn(Procedure*)+74(1002c4890, fffffffe729e37d8, fffffffe8a273b48, 0, ffffffff675e8f80)
pc: ffffffff66513158 void EngStream::execute()+a30(101cfebd0, fffffffe729e3a47, 100fe8920, ffffffff67602868, ffffffff67602870)
pc: ffffffff66513c54 void RQConnItem::do_request()+4(101cfecd8, ff000000, ffffffff7e02a980, ffffffff784afa40, ffffffff784afa40)
pc: ffffffff66514654 unsigned RQBaseItem::do_work(Worker*)+24(101cfecd8, 1002c4890, 0, ff000000, 0)
pc: ffffffff665c69d4 void RequestQueue::worker_body()+284(ffffffff6761f870, ffffffff67654be0, 1002c4890, ffffffff675e8f80, ffffffff66514630)
pc: ffffffff665145f0 void request_task(void*)+138(1308, 167360, 167000, ffffffff675e8f80, ffffffff677502e0)
pc: ffffffff665cac7c void*UnixTask::pre_body(void*)+31c(184000, fffffffe729e3f46, fffffffe729e4000, 0, 2000)
I. 10/08 15:33:37. 0000000000 
==== Thread Number 610 =====


Read more...

Environment

  • SAP IQ I6.0 sp11.22
  • SAP IQ16.1 SP05 

Product

SAP IQ 16.1

Keywords

Database upgrade, do_system_upgrade, dbi_upgradedatabase, sql_security, ISYSPROCEDURE , KBA , BC-SYB-IQ , Sybase IQ , Known Error

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.