SAP Knowledge Base Article - Preview

2248967 - Crash and Internal Error "slib/s_blockmap.cxx:5547" - SAP IQ

Symptom

1. A secondary writer IQ server got crashed after a series of Internal Error "slib/s_blockmap.cxx:5547"

 **************************************************
 ***   SAP IQ Abort:
 ***      From:  slib/s_blockmap.cxx:5547
 ***      PID: 8896
 ***      Exception Location: 0x9ffffffe83569f40
 ***      Error ID: 2091,  Exception Type: s_internalexception
 ***      Thread: 282  (TID: 48, Original TID: 48)
 ***      Error #: 0,  O/S Error #: 0
 ***      Message:  s_blockmap::Find args:  lbn:1, btype:7, nBlocks:16, translating
 **************************************************

2. Detail error message
 
0000124011 [20896]: Insert for '#TAB001_TMP' completed in 0 seconds.  0 rows inserted.
0000124011 temp Bufman: Incorrect page header read; buffer={btype=14,nlb=16,blk=37841898,pbn=37841898,npb=16,..............
0000124011 ,npb=4120,ctr=178,cta=173,pbn=3545166741088200834,txn=9023013668162503951,sp=143144207,ver=48,pb=5,pus=8207}. slib/s_trycatch.cxx:2797
0000124011 There was an s_buf::Read() error during s_bufman::Find().

..........<< omitted lines >>.............
..........<< omitted lines >>.............

0000124011     ********************************************************
0000124011     **
0000124011     **       Non-Fatal IQ Internal Error Detected
0000124011     **       at slib/s_blockmap.cxx:5547  on thread 285 (TID 27)
0000124011     **       s_blockmap::Find args:  lbn:1, btype:7, nBlocks:16, translating
0000124011     **       Unknown buffer manager internal error
0000124011     **
0000124011     **  Error from IQ connection:  SA connHandle: 14046  SA connID: 21  IQ connID: 0000124011  User: user001
0000124011     **  Time of error:  2015-11-20 09:26:22
0000124011     **  IQ Version:  SAP IQ/16.0.102/20057/P/sp10.03
0000124011     **  OS info:  IQ built on: ITANIUM/HP-UXi 11.31,  Executed on: HP-UX/host002/B.11.31/U/ia64
0000124011     **  Command status when error occured:  CURSOR ACTIVE
0000124011     **  Command text: 
select "a"."COL001", ....................................

..........<< omitted lines >>.............
..........<< omitted lines >>.............
 
0000124011 (0)  0xc0000000272493d0  _Z13ucstkgentraceii + .............
0000124011 (1)  0xc00000002724a6c0  _Z23StackTraceForThisThreadPKciS0_S0_S0_ + 0x630 at oslib/hos_stacktrace.cxx:1895 [/sw/sybaseiq/IQ-16_0/bin64/../lib64/libiq16.so]
0000124011 (2)  0xc000000027424820  _ZN10s_blockmap10ThrowErrorE18s_bufman_errorInfoPKci + .............
0000124011 (3)  0xc000000027400b50  _ZN10s_blockmap4FindEysiP19s_bufmanCallerStats + .............
0000124011 (4)  0xc00000002982a070  _ZN6hs_vdo8GetValueERK11hs_vdorecidmPvPm + .............
0000124011 (5)  0xc000000029e8a3f0  _ZN11db_TableDef7OpenIdsEji + .............
0000124011 (6)  0xc000000029e9e970  _ZN11db_TableDef9LoadTableEP7UITableP10db_CatalogP11st_databasejjP8st_txncbjP13st_connectioni + .............
0000124011 (7)  0xc000000029e4d5b0  _ZN10db_Catalog9LoadTableEP7UITablejjjP8st_txncbji + .............
0000124011 (8)  0xc000000029e25910  _ZN10db_Catalog16FindTableVersionEP13st_connectionP7UITablejjj + .............
0000124011 (9)  0xc000000029e2b330  _ZN10db_Catalog17FindTableByITableEP7UITablejjj + .............
0000124011 (10) 0xc000000026762080  _ZN18opt_TableReference16InitTableColumnsEP7df_HeapP10opt_Select + .............
0000124011 (11) 0xc0000000267159d0  _ZN10opt_Select16InitializeTablesEv + .............
0000124011 (12) 0xc0000000267166a0  _ZN10opt_Select23InitializeNestedQueriesEP12opt_QueryExp + .............
0000124011 (13) 0xc0000000267242c0  _ZN10opt_Select22FindAndProcessSubqueryEP7df_HeapP11a_base_exprji + .............

  ..........<< omitted lines >>.............
  ..........<< omitted lines >>.............

0000124011     ******************* End of STACKTRACE ******************
0000124011     **
0000124011     **       End of stack trace from Non-Fatal IQ Internal Error slib/s_blockmap.cxx:5547
0000124011     **
0000124011     ********************************************************
0000124011    
0000124011 Exception Thrown from slib/s_blockmap.cxx:5547, Err# 0, tid 27 origtid 27
0000124011    O/S Err#: 0, ErrID: 2091 (s_internalexception); SQLCode: -1001012, SQLState: 'QFA12', Severity: 18
0000124011 [20521]: Internal state violation, please contact SAP IQ support
0000124011    s_blockmap::Find args:  lbn:1, btype:7, nBlocks:16, translating

3. Checked the referenced table in the suspicious query with verify mode, but no error detected.

4. It's not reproducible.


Read more...

Environment

IQ : SAP IQ 16.0 SP10 PL03 HPIA 64bit (Multiplex)
OS : HP-UX B.11.31 U ia64

Product

SAP IQ 16.0

Keywords

IQ, crash, s_blockmap, slib/s_blockmap.cxx:5547, s_blockmap::Find, _ZN10s_blockmap10ThrowErrorE18s_bufman_errorInfoPKci, _ZN10s_blockmap4FindEysiP19s_bufmanCallerStats, Unknown buffer manager internal error , 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.