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

Search for additional results

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