SAP Knowledge Base Article - Preview

2583645 - New connections cannot be established after error "Tried to destroy a userlocked buffer" failed - SAP IQ 

Symptom


After an error on "temp Bufman: Tried to destroy a userlocked buffer" with a non-fatal stack trace below,
new connections could not be established.

New connection attempts could fail with either of the following errors:

  • "ApplicationName connected to database DatabaseName over TCPIP, a moment later followed by "Canceling current request".
  • "IQNLSJobName connected to database DatabaseName over TCPIP, a moment later followed by "Connection terminated abnormally"
  • DBISQL connection fails with timeout

 

Excerpt of IQMSG


| 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
+----------+-----------------------------------------+------------+------------+------------+------------+------------+------------+-------------
0x7fe2378282c8 | a D n v y w B c i s P U m x f z r h L | 1 | 16385 | 378905144 | 693 | 0x7fe22b8c7000 | 00x2114ad8 | 2..2
ERROR: Destroying Locked Logical Buffer

********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at slib/s_bufman.cxx:5322 on thread 140630763603712 (TID 1104)
**

***************** This is the STACKTRACE ***************


s_bufman_exception::s_bufman_exception
s_bufpartition::DestroyLogicalBuffer
s_blockmap::Destroy
s_blockmap::Destroy
s_bm::InternalDestroy
s_bm::~s_bm
s_buf_sync_array::~s_buf_sync_array
s_SerializedFileBlockmap::~s_SerializedFileBlockmap
s_blockmap::Unlock
dfo_FileSource::CloseFile
s_FileOffsetWorkAllocator::DoneWithCurrentWU

.....

******************* End of STACKTRACE ******************
**
** End of stack trace from Non-Fatal IQ Internal Error slib/s_bufman.cxx:5322
**
********************************************************

Exception Thrown from slib/s_bufman.cxx:5322, Err# 5, tid 1104 origtid 1104
O/S Err#: 0, ErrID: 2055 (s_bufman_exception); SQLCode: -1009048, SQLState: 'QSA48', Severity: 23
[20069]: temp Bufman: Tried to destroy a userlocked buffer; buffer={btype=17,nlb=16,blk=693,pbn=0,npb=0,uid=378905144,mn=2,upmn=2,flgs=0x80000012} page={btype=17,nlb=16,npb=0,ctr=131,cta=131,pbn=0,txn=0,sp=0,ver=1,pb=0,pus=0}.
-- (slib/s_bufman.cxx 5322)

 


Read more...

Environment

SAP IQ 16

Product

SAP IQ 16.0

Keywords

 CR812565, CR#812565, 812565, "Canceling current request", "connection terminated abnormally", timeout,  userlocked , temp, buffer, s_bufman_exception::s_bufman_exception, s_bufpartition::DestroyLogicalBuffer, s_blockmap::Destroy, s_bm::InternalDestroy,s_bm::~s_bm   , 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 for Me (Login required).

Search for additional results

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