SAP Knowledge Base Article - Preview

2300161 - Fatal Error in s_bufhash::DeleteStaleBuf ... dumping sbufs and server crash - SAP IQ

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

SAP IQ 16.0

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.