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

• 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.

SAP IQ 16.0 SP 11 PL24

KBA , BC-SYB-IQ , Sybase IQ , Known Error