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

Search for additional results

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