Symptom
- While a SQL script was running, in IQ16 SP11, the below error happened and server crashed.
"Fatal Error in s_bufhash::DeleteStaleBuf... dumping sbufs." - It happened just one time and nothing inconsistency on related table.
- After the crash, when the IQ was rebooted, the same script and inserting worked well.
- *iqmsg =>
...
I. 03/24 18:35:45. 0001226071 Update Started:
I. 03/24 18:35:45. 0001226071 #Result
I. 03/24 18:35:45. 0001226071 [20895]: Update Pass 1 completed in 0 seconds.
I. 03/24 18:35:45. 0001226071 [20895]: Update Pass 2 completed in 0 seconds.
I. 03/24 18:35:45. 0001226071 [20896]: Update for '#Result' completed in 0 seconds. 2454 rows updated.
I. 03/24 18:35:45. 0001226071 [20896]: Insert for 'MYTABLE1M' completed in 0 seconds. 2454 rows inserted.
I. 03/24 18:35:45. 0001226071 [20917]: Delete of 580 rows started for table:
I. 03/24 18:35:45. 0001226071 [20919]: Delete of 580 rows completed for table: STMonthData, 0 seconds.
I. 03/24 18:35:46. 0001226071 [20896]: Insert for 'MYTABLEMonthData' completed in 1 seconds. 4908 rows inserted.
I. 03/24 18:35:46. 0000000000 Fatal Error in s_bufhash::DeleteStaleBuf(idx=15,new=12b0cb4b8); s=12aff39b8, pbn=2176891); dumping sbufs.
...
I. 03/24 18:35:46. 0000000000 Bucket Sizes [0-9,>]: 000000010000001501200033000001130000000000101001012010000000000100000001001010000 ...
I. 03/24 18:35:46. 0000000000 111000100010000000000120002000001101033110000200010110010020000000002000001100101000001...
I. 03/24 18:35:46. 0000000000 Pool Usage ([0-9,>]=References, 'F'=Free, '!' = Conflict): 111111111111111111111111111111F11111111111111F1111111111111111111111 ...
I. 03/24 18:35:46. 0000000000 111111111111111F11111111111111F11111111111111111111111111111111111111111F111111111111F1111111111111111111111111F11111...
....
I. 03/24 18:35:46. 0000000000 **************************************************
I. 03/24 18:35:46. 0000000000 *** SAP IQ Abort:
I. 03/24 18:35:46. 0000000000 *** From: slib/s_bufhash.cxx:640
I. 03/24 18:35:46. 0000000000 *** PID: 4194460
I. 03/24 18:35:46. 0000000000 *** Exception Location: 0x12545fc30
...
===== Thread Number 106400 =====
...
...hos_ABORT ..
...ThrowAbort..
...Throw ..
...hos_assertexception::ThrowException ..
...s_bufhash::DeleteStaleBuf ..
...s_buf::Write ..
...s_blockmap::Flush ..
...s_commitRequest::Perform ..
...s_cacheTeamWorkIter::ExecWork ..
Read more...
Environment
- IQ 16.0 SP11
- IQ 16.1
Product
Keywords
"s_bufhash::DeleteStaleBuf" ; 's_bufhash.cxx:640" ; , 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.