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

Search for additional results

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