SAP Knowledge Base Article - Preview

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)


 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.


SAP IQ 16.0


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.