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

SAP Knowledge Base Article - Preview

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

Symptom

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.
 


Read more...

Environment

IQ16 sp11 pl06.

Product

SAP IQ 16.0

Keywords

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.