SAP Knowledge Base Article - Preview

3106897 - Stack traces and errors and index corruption leading to drop index is failing - SAP IQ

Symptom

  • The server at 12:30:45 - A server received the following non-fatal errors:

 {1710} main Bufman: Decompression error during Read; from slib/s_buf.cxx:1837 into buffer 33be3e7f80
 {1710} expected: btype=5,pbn=192144781,txn=12436131114,sp=39,nlb=16,npb=6,iscmp=1,uid=51214189235,blk=682569,mn=1425616,upmn=1433718,flgs=0x80000018
 {1710} header: btype=5,pbn=192144781,txn=12433477038,sp=644267,nlb=16,npb=6,iscmp=1,ctr=136,cta=134,ver=1,pb=179,pus=27209
 {1710} buffer: 0x0005001000068886000000000b73e58d00000002e517cdae0009d4ab01b36a49
 {1710} Expected Pad1: 179 (0xb3), Pad2: 27209 (0x6a49)
 {1710} Got Pad1: 179 (0xb3), Pad2: 27209 (0x6a49)
  ** slib/s_buf.cxx:1837
   **  Current command:  NO COMMAND OR CURSOR ACTIVE

     ********************************************************
     **
     **       Non-Fatal IQ Internal Error Detected
     **       at slib/s_buf.cxx:1837  on thread 1710 (TID 1701)
     **
     **       Please report this to SAP IQ support
     **       with the following diagnostic information,
     **       and, if possible, with the user's command.
     **
     **  Error from IQ connection:
     **  Time of error:  2021-07-08 12:30:45
     **  IQ Version:  SAP IQ/16.0.110/13291/P/sp11.24
     **  OS info:  IQ built on: Sun_Sparc/OS 5.10,  Executed on: SunOS/dccps3236/5.10/Generic_153153-01/sun4v
     **  Command status when error occured:  NO COMMAND OR CURSOR ACTIVE
===== Thread Number  1710 =====
StackTraceForThisThread
s_buf::DumpOnBufmanError
s_buf::Read
s_bufpartition::FindForPrefetch(s_connectionCacheStats
s_blockmap::Prefetch
s_prefetchRequest::PeeperPrefetch
s_cacheTeamWorkIter
workAllocator::DoWork
Page dump for sbuf @ 33be3e7f80
 _dskBlk @ 3231f34000
 Physical block #: 192144781 (0xb73e58d)
 Blocks read: 6
 Expected Pad1: 179 (0xb3), Pad2: 27209 (0x 6a49)
 File #40 (catid 16429): /idas_prd/database/IDAS_PRD/dev/glsrdev_033
 Starting Block: 191315520 (0xb673e40)
 File Physical Block Number: 829262 (0xca74e)
 File size: 4194296 blocks, 34359672832 bytes.
                 | I I N I I H I I I I I I I I I I H I H I |
         Flags:  | s s e s s a s s n s s s s s s s a n e s |
                 | D D e V B s B C W S P U M Q S F s A a P |
                 | i i d e u B l h a p r s a u t r A f d r |
                 | r r s r s u o e s e e e p a a e f f O e |
                 | t t D s y s c c h c f r   r l e f i f A |
                 | i y e i   y k S A i e L   a e l i n T l |
                 | a   a o   W M u r a t o   n   i l n x i |
                 | b   l n   a a m e l c c   t   s i t n o |
       s_buf(s)  | l   l e   i p V a F h k   i   t t y L c |
       follow... | e   o d   t p a   L e e   n   P y A i a
                 |     c     e e l   B d d   e   a   r s t |
                 |           r d i   u       d   g   e t e |
                 |           s   d   f           e   a   d |
+----------------+-----------------------------------------+------------+------------+------------+------------+------------+------------+--------------+----------------+----------------+
|  &s_buf        | A D N V Y W B C I S P U M Q X F Z R H L | LockRefCnt | DBSpaceID  | BlkMapUID  | Blk Num    | _dskBlk    | BlockMap   | VersionRange | prev           | next           |
+----------------+-----------------------------------------+------------+------------+------------+------------+------------+------------+--------------+----------------+----------------+
      33be3e7f80 | a d n V Y W B c i s P U m q x f z r h L |          1 |          0 | 51214189235 |     682569 | 3231f34000 | 0000000000 |   1425616..1433718 |                0 |                0
---------------------+----------------------+----------------------+------------+-----+----------------------+------------+-------+-------+----------------------
&s_dskbkhdr          | Block Type           | Transaction ID       | SavePoint  | Ver | Physical Block       | Data       |NumPBlk|NumLBlk| Req/Actual Comp Types
---------------------+----------------------+----------------------+------------+-----+----------------------+------------+-------+-------+----------------------
          3231f34000 |                bt(f) |          12433477038 |     644267 |   1 |            192144781 | 3231f34020 |     6 |    16 | ANY/LZRW1
 PBN=192144781 (0xb73e58d)

  • At 14:48:44 , the server received:
    Database server shutdown due to HUP signal
    TCPIP listener on IP address (::):4955 is exiting
    TCPIP listener on IP address 0.0.0.0:4955 is exiting

  • Once the server came back up, dropping the index failed with:
      ********************************************************
      **
      **       Non-Fatal IQ Internal Error Detected
      **       at slib/s_bm.cxx:2240  on thread 460 (TID 2)
      **       Bitmap result bitcount not in legal range.
      **       this=ffffffff2107d238,error={num=1,os=0,id=2049,msg=-1009045},bmec=1
      **
      **       Please report this to SAP IQ support
      **       with the following diagnostic information,
      **       and, if possible, with the user's command.
      **
      **  Error from IQ connection:  SA connHandle: 97  SA connID: 57  IQ connID: 0000000322  User: DBA
      **  Time of error:  2021-07-08 14:19:26
      **  IQ Version:  SAP IQ/16.0.110/13291/P/sp11.24
      **  OS info:  IQ built on: Sun_Sparc/OS 5.10,  Executed on: SunOS/dccps3236/5.10/Generic_153153-01/sun4v
      **  Command status when error occured:  COMMAND ACTIVE
      **  Command text:  drop index "USER"."table"."index_name"
    sbm_exception::sbm_exception
     s_bm::SetBits
    s_VersioningBlockmap::Deallocate
    s_blockmap::DestroyAllMappedPages
    hs_ohc::Destroy
    db_IndexDef::DestroyIndex
    db_IndexDef*db_TableDef
    db_Catalog::DropIndex
     st_command::DoCmdThroughResourceGate
    db_iqddl::DropIndex
    UIQDDL_DropIndex
    st_SAIQInterfaceInfo
    st_SAIQInterface
    saint_iqthresholdddl::DropIndex
    Exception Thrown from slib/s_bm.cxx:2240, Err# 1, tid 2 origtid 2
    O/S Err#: 0, ErrID: 2049 (sbm_exception); SQLCode: -1009045, SQLState: 'QSA45', Severity: 14
    Bitmap failed internal checks. Please check your IQ message file for additional information.
    Rbck

  • Unable to drop the index - tried several times with same results.


Read more...

Environment

SAP IQ 16.0 SP 11 PL24

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

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