2493799 - updating multitable crashes the server with stacktrace - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2493799 - updating multitable crashes the server with stacktrace - SAP IQ

Symptom

Having a multi-table update crashes the server and generates a stack trace.

 

 **  Error from IQ connection:  SA connHandle: 68  SA connID: 28  IQ connID: 0000000630  
 **  IQ Version:  SAP IQ/16.0.0/160405/P/sp08.41    
 **  OS info:  IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5,      
 **  Command status when error occured:  NO COMMAND OR CURSOR ACTIVE    
 **  Parser command text: 
update #Z as "Z"
  ,(select "a","list"("b"."b",' | ') as "c"
    from "a" join "b" on "a"."d" = "b"."e" group by "a") as "ZZ"
  set "Z"."c" = "ZZ"."c" where "Z"."a" = "ZZ"."a"
Dump all thread stacks at stcxtlib/st_server.cxx:1714 for PID: 5602

    ***************** This is the STACKTRACE ***************

 

===== Thread Number  140719201801984  (IQ connID: 0000000630) =====
pc: 0x7ffbba612782 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x32
pc: 0x7ffbba612df1 ucstkgentrace(int, int)+0x121
pc: 0x7ffbba614149 DumpAllThreads(char const*, unsigned int, int)+0x259
pc: 0x7ffbba392dda hos_ABORT(char const*, unsigned int, char const*, char*, char*)+0x26a
pc: 0x7ffbbb1090af SigHndlr+0x4f
pc: 0x7ffff65b1370 _fini+0x3a025fe8
pc: 0x7ffbbd1a0b5f _fini+0xc157d7
pc: 0x7ffbbd1a0b92 _fini+0xc1580a
pc: 0x7ffbbd1aaabc _fini+0xc1f734
pc: 0x7ffbbd1ac1a7 _fini+0xc20e1f
pc: 0x7ffff6e210c0 GetNewTree(a_statement*, a_tabdef_set*, unsigned int*)+0x120
pc: 0x7ffff723f737 new_cursor(IDBHeap*, a_statement*, a_tabdef_set*, unsigned int, PlanInfo*, TableDef*, unsigned int)+0x227
pc: 0x7ffff7240a65 dbi_build_volcano_update(IDBHeap*, a_statement*, unsigned int, unsigned int, PlanInfo*)+0xd5
pc: 0x7ffff6e49d07 a_plan_cache::openDML(a_plan_cache::a_dml_op, a_statement*, a_stmt*, a_stmt_identifier*, unsigned int, TableDef*)+0x227
pc: 0x7ffff6e49e22 a_plan_cache::OpenUpdate(a_statement*, a_stmt*, a_stmt_identifier*, unsigned int)+0x22
pc: 0x7ffff6d4e28d dbi_update(Connection*, a_statement*, a_stmt*, a_stmt_identifier*, unsigned int)+0x2d
pc: 0x7ffff6e44ad3 DoExecuteStmt(Connection*, a_stmt*, a_statement*, a_stmt_identifier*, unsigned short, unsigned int)+0x2c73
pc: 0x7ffff6e44c51 db__execute_any_imm(Connection*, an_sqlpres_receive*)+0x121
pc: 0x7ffff6e526d4 RequestProcedure::call()+0xcd4
pc: 0x7ffff6ca5aee Context::call(Procedure*, Context**)+0x4e
pc: 0x7ffff6ca5bd6 Worker::call_on_stack(Procedure*)+0x56
pc: 0x7ffff6e4f16d TopProcedure::call()+0x3d


Read more...

Environment

  • SAP IQ 15.X
  • SAP IQ 16.X

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

699206; CR 699206; CR#699206; multi-table update; , 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 ONE Support launchpad (Login required).

Search for additional results

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