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

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 ONE Support launchpad (Login required).

Search for additional results

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