SAP Knowledge Base Article - Preview

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


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 ***************



******************* 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)






SAP IQ 16.0


 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.