SAP Knowledge Base Article - Preview

2136728 - SAP IQ 15.2 server aborts on select query

Symptom

IQ server aborted with stacktrace below on a select count query:

Line 11206: I. 02/11 17:58:08. 0000000016
Line 11207: I. 02/11 17:58:08. 0000000016 **************************************************
Line 11208: I. 02/11 17:58:08. 0000000016 ***   Sybase IQ Abort:
Line 11209: I. 02/11 17:58:08. 0000000016 ***      From:  st_server.cxx:1409
Line 11210: I. 02/11 17:58:08. 0000000016 ***      PID: 32380
Line 11211: I. 02/11 17:58:08. 0000000016 ***      Message: caught signal 11, program abort
Line 11212: I. 02/11 17:58:08. 0000000016 ***      Thread: 419019072  (TID: 103)
Line 11213: I. 02/11 17:58:08. 0000000016 **************************************************
Line 11215: I. 02/11 17:58:08. 0000000016     **  Error from IQ connection:  SA connHandle: 2  SA connID: 29  IQ connID: 0000000016  User: xxx
Line 11215: I. 02/11 17:58:08. 0000000016     **  Error from IQ connection:  SA connHandle: 2  SA connID: 29  IQ connID: 0000000016  User: xxx
Line 11216: I. 02/11 17:58:08. 0000000016     **  Time of error:  2015-02-11 17:58:08
Line 11217: I. 02/11 17:58:08. 0000000016     **  IQ Version:  Sybase IQ/15.2.0/101123/P/ESD 2
Line 11218: I. 02/11 17:58:08. 0000000016     **  OS info:  IQ built on: Enterprise Linux64 - x86_64 - 2.6.9-67.0.4.ELsmp,  Executed on: Linux/DCSLOPNIDB04/2.6.18-238.5.1.el5/#1 SMP Mon Feb 21 05:52:39 EST 2011/x86_64
Line 11219: I. 02/11 17:58:08. 0000000016     **  Command status when error occured:  CURSOR ACTIVE
Line 11220: I. 02/11 17:58:08. 0000000016     **  Command text:
Line 11221: I. 02/11 17:58:08. 0000000016            AND (
Line 11222: I. 02/11 17:58:08. 0000000016 UNT
Line 11226: I. 02/11 17:58:08. 0000000016  Avg. Wait Time: 0 msec. ,   Avg. Insert Time: 0 msec.,  Avg. Sort Time: 0 msec.,   #Bitvec partitions: 0,   #Shadows: 0,   #Threads:
Line 11227: I. 02/11 17:58:08. 0000000016  InsertsComplete Time: 0 msec. ,   Avg Release Resource Time:0 msec.,   Max Release Resource Time:0 msec.,  Total Complete Time : 0msec.
Line 11228: I. 02/11 17:58:08. 0000000016 [20535]: Query Plan:
Line 11229: I. 02/11 17:58:08. 0000000016 [20535]: 0    #31:  Root
Line 11228: I. 02/11 17:58:08. 0000000016 [20535]: Query Plan:
               Line 12055: I. 02/11 17:58:08. 0000000016 /usr/local/sybase15_2/IQ-15_2/bin64/../lib64/libiq15.so(SigHndlr+0x4e) [0x2b031cead24e]
Line 12057: I. 02/11 17:58:08. 0000000016 /lib64/libpthread.so.0 [0x31a940eca0]
Line 12059: I. 02/11 17:58:08. 0000000016 /lib64/libc.so.6(memcpy+0x35) [0x31a887b395]
Line 12061: I. 02/11 17:58:08. 0000000016 /usr/local/sybase15_2/IQ-15_2/bin64/../lib64/libiq15.so(_ZN11s_packedRec24AcceptDataFieldFromHDValEP11s_fieldInfoP10s_fieldLoc+0x10a) [0x2b031cdd2f2a]
Line 12063: I. 02/11 17:58:08. 0000000016 /usr/local/sybase15_2/IQ-15_2/bin64/../lib64/libiq15.so(_ZN11s_packedRec22ConditionKeysFromHDValERK15s_packedRecDesc+0x134) [0x2b031cdd26d4]
Line 12065: I. 02/11 17:58:08. 0000000016 /usr/local/sybase15_2/IQ-15_2/bin64/../lib64/libiq15.so(_ZN11s_packedRec9AcceptRecERK15s_packedRecDesc+0x1cd) [0x2b031cdd3bcd]
Line 12067: I. 02/11 17:58:08. 0000000016 /usr/local/sybase15_2/IQ-15_2/bin64/../lib64/libiq15.so(_ZN7s_phash17InsertKeyIfUniqueEPKPK9hos_datum+0xc2) [0x2b031cde4f62]
Line 12069: I. 02/11 17:58:08. 0000000016 /usr/local/sybase15_2/IQ-15_2/bin64/../lib64/libiq15.so(_ZN20dfe_ManyCachedValues8EvaluateEv+0xa2) [0x2b031c5f9862]
Line 12071: I. 02/11 17:58:08. 0000000016 /usr/local/sybase15_2/IQ-15_2/bin64/../lib64/libiq15.so(_ZN14dfp_InSubQuery10AddToCacheEv+0xb1) [0x2b031c8197e1]
Line 12073: I. 02/11 17:58:08. 0000000016 /usr/local/sybase15_2/IQ-15_2/bin64/../lib64/libiq15.so(_ZN22dfo_VerticalLeafCursor21ExecuteINSubQueryBodyEP14dfp_InSubQuery+0x178) [0x2b031c7ddbc8]


Read more...

Environment

SAP IQ 15.2

Product

SAP Sybase IQ 15.2

Keywords

SAP IQ, Sybase IQ, 15.2, s_packedRec, ConditionKeysFromHDVal, AcceptRec, s_packedRecDesc, s_phash, InsertKeyIfUnique,  dfe_ManyCachedValues, EvaluateEv, shadow parallelism , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.