SAP Knowledge Base Article - Preview

2815047 - Fatal Error in s_bufhash::DeleteStaleBuf and server crash - SAP IQ

Symptom

Fatal abort happened for one thread in which a SQL script was running deletes:

Fatal Error in s_bufhash::DeleteStaleBuf(idx=1965,new=0x7fc523d68d50); s=0x7fc524b07da0, pbn=411229717); dumping sbufs.

| 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
+----------+-----------------------------------------+------------+------------+------------+------------+------------+------------+-------------
0x7fc524b07da0 | a d n V y w B c i s P U m x f z r H L | 1 | 16387 | 12269 | 26703 | 0x7fb595eac000 | 0000000000 | 2639..2639
0x7fc523d68d50 | a d n V Y w B c i s P u m x f z r h L | 0 | 0 | 16572864 | 628 | 0x7fbc816e2000 | 0000000000 | 299055..299055
-----------+----------------------+----------------------+------------+-----+----------------------+------------+-------+-------+----------------------
&s_dskbkhdr| Block Type | Transaction ID | SavePoint | Ver | Physical Block | Data |NumPBlk|NumLBlk| Req/Actual Comp Types
-----------+----------------------+----------------------+------------+-----+----------------------+------------+-------+-------+----------------------
0x7fb595eac000 | bt(f) | 276857444 | 494 | 1 | 411229717 | 0x7fb595eac020 | 3 | 16 | ANY/LZRW1
0x7fbc816e2000 | vdo | 278036305 | 5145 | 1 | 411229717 | 0x7fbc816e2020 | 3 | 16 | ANY/LZRW1
CHAIN DATA: _a=18419, _b=100561, _s=0x7fc524d81160.
CHAIN DATA: _a=18205, _b=927, _s=0x7fc5245af128.
CHAIN DATA: _a=16572864, _b=628, _s=0x7fc523d68d50.
CHAIN DATA: _a=12269, _b=26703, _s=0x7fc524b07da0.
s_bufhash @ 0x7fc6f400a5b8
99592/131072 Buckets used:
-----------+------------+------------------+----------------------+-----------------+--------------

...

131071 | 5133 | 0000000000003c8f | 5093 | 0x7fc5257b0b98 | 3421..5123
131071 | 21134 | 0000000000004805 | 349415 | 0x7fc524898f88 | 1715..1738
Bucket Sizes [0-9,>]: 01100231102000100210310020101102020011011111000100021221011101122100111000303110

...

FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF


**************************************************
*** SAP IQ Abort:
*** From: slib/s_bufhash.cxx:804
*** Rethrown from: oslib/hos_throw.cxx:313
*** PID: 11304
*** Exception Location: 0x0x7fc55956ba40
*** Error ID: 533, Exception Type: hos_assertexception
*** Thread: 140485584152320 (TID: 2257, Original TID: 2257)
*** Error #: 3, O/S Error #: 0
*** Argument:

**************************************************

**************************************************

** Error from IQ connection:
** Time of error: 2019-07-08 11:58:21
** IQ Version: SAP IQ/16.1.020/11410/P/sp02.10
** OS info: IQ built on: Linux/Linux64 - x86_64 - 2.6.18-194, Executed on: Linux/db61w112m3.etrade.com/3.10.0-862.11.6.el7.x86_64/#1 SMP Fri Aug 10 16:55:11 UTC 2018/x86_64
** Command status when error occured: NO COMMAND OR CURSOR ACTIVE Dump all thread stacks at slib/s_bufhash.cxx:804 for PID: 11304

Stack information:

hos_ABORT(char const*, unsigned int, hos_exception const&, char*, char*, sigcontext*)+0x43a
Throw(hos_exception const&)+0x3fc
hos_assertexception::ThrowException(char const*, int, hos_assertexception::errors)+0x2a
s_bufhash::DeleteStaleBuf(unsigned int, s_buf*)+0x4e3
s_buf::Write(s_bufman_errorInfo*, hos_bio::allocPrivilege, int, int, int)+0x13c0
s_blockmap::HelperFlush(s_bufman_errorInfo*)+0x57b
s_commitRequest::Perform(s_bufman_errorInfo*)+0x1e
s_cacheTeamWorkIter::ExecWork(int&, unsigned int)+0x19f
workAllocator::DoWork(unsigned int)+0xba
hos_thread::Main()+0x210
hos_lwtask::Start(hos_lwtask*)+0x5b
IQWorkerStarter(void*)+0x52
run_task_body+0x2d


Read more...

Environment

SAP IQ 16.1 SP02

Product

SAP IQ 16.1

Keywords

"s_bufhash::DeleteStaleBu" , "s_bufhash.cxx:804", 's_bufhash', , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.