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:
    type=5,pbn=192144781,txn=12436131114,sp=39,nlb=16,npb=6,iscmp=1,uid=51214189235,blk=682569,mn=1425616,upmn=1433718,flgs=0x8000018
    {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 for Me (Login required).

Search for additional results

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