2449321 - Error from s_bufpool.cxx in IQ16 sp11 pl06 on HG page rollback during duplicate value insert attempt.

Server crashes on s_bufpool.cxx  during attempt to insert duplicate values into a column which is a part of composite primary key.

In an aggressive delete/insert environment, the crush always follows a relatively small delete immediately following by an insert which would have to be rolled back due to a duplicate value error.

s_bufpool::Release(this=0x7fffac006088,Slot=0x7fffad7f1168,isInHashTable=1,isForShutdown=0): main Bufman
           | 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 O S F s A a P |
           | i i d e u B l h a p r s a w t r A f d r |
           | r r s r s u o e s e e e p n a e f f O e |
           | t t D s y s c c h c f r   e l e f i f A |
           | i y e i   y k S A i e L   r e l i n T l |
           | a   a o   W M u r a t o       i l n x i |
           | b   l n   a a m e l c c       s i t n o |
 s_buf(s)  | l   l e   i p V a F h k       t t y L c |
 follow... | e   o d   t p a   L e e       P y A i a |
           |     c     e e l   B d d       a   r s t |
           |           r d i   u           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 O X F Z R H L | LockRefCnt | DBSpaceID  | BlkMapUID  | Blk Num    | _dskBlk    | BlockMap   | VersionRange
+----------+-----------------------------------------+------------+------------+------------+------------+------------+------------+-------------
0x7fffad7f1168 | a d n V y w B c i s P U m x f z r h L |          1 |          0 |     155476 |      11400 | 0x7ff8e911c000 | 0000000000 |   6822..6822
-----------+----------------------+----------------------+------------+-----+----------------------+------------+-------+-------+----------------------
&s_dskbkhdr| Block Type           | Transaction ID       | SavePoint  | Ver | Physical Block       | Data       |NumPBlk|NumLBlk| Req/Actual Comp Types
-----------+----------------------+----------------------+------------+-----+----------------------+------------+-------+-------+----------------------
0x7ff8e911c000 |                   bt |             21814995 |          1 |   1 |            874048449 | 0x7ff8e911c020 |     4 |    16 | ANY/LZRW1
 
 
**************************************************
***   SAP IQ Abort:
***      From:  slib/s_bufpool.cxx:716
***      Rethrown from:  oslib/hos_throw.cxx:313
***      PID: 25441
***      Exception Location: 0x0x7ffd8695dcc0
***      Error ID: 533,  Exception Type: hos_assertexception
***      Thread: 140726861436672  (TID: 15, Original TID: 15)
***      Error #: 3,  O/S Error #: 0
***      Argument: 
 - (slib/s_bufpool.cxx 716)

s_bufpool::Release
s_bufpool::Rollback
s_bufman::Rollback
st_txncb::Rollback
st_txnMgr::Rollback
st_command::DoCmdThroughResourceGate
st_iqtxn::RollbackTxn
UIQTxn_RollbackTxn+0x15
st_SAIQInterfaceInfo::callFunction
st_SAIQInterface::RunIQFunc
st_SAIQInterface::Execute
saint_iqthresholdtxn::RollbackTxn
DB_Rollback_Chgs
Connection::rollback_work_internal
Connection::rollback_work
Connection::common_cleanup
Connection::close
db__disconnect

 Please NOTE: This stacktrace is identical to CR796640 which is fixed in this release. Difference is in BlockType of an output above.
However, workarouns may still work for bm BlockType (CR 796640) as well. If BlockType is bm, nBit index has to be targeted.
 

IQ16 sp11 pl06.

KBA , BC-SYB-IQ , Sybase IQ , Problem