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
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.
SAP Knowledge Base Article - Preview