SAP Knowledge Base Article - Preview

3683797 - MPX got massively corrupted after detected DBSPACE out of space error - SAP IQ

Symptom

  • Dbspace DATASPACE1 is  OUT OF SPACE
    ***************** This is the STACKTRACE ***************
    ..s_blockmap::ThrowIfOutOfSpace
    ..s_blockmap::FindAndMakeDirtiable
    ..s_pageListCursor::PositionPage
    ..v2s_bmcontext::bmlfblkselfget
    ..v2s_bmcontext::bmselfreldif
    ..s_bm::TurnOff
    ..hs_dp::DeleteInternal
  • After restart the IQ server, IPHR error detected
    main Bufman: Incorrect page header read; from slib/s_trycatch.cxx:3200 into buffer 0x7fffeae593a0
    O/S Err#: 0, ErrID: 2100 (s_corruptdiskblkhdrexception); SQLCode: -1009039, SQLState: 'QSA39', Severity: 14
    main Bufman: An error was detected on a database page. You may have a damaged index. For additional information, please check your IQ message file or run sp_iqcheckdb. 
    -- (slib/s_blockmap.cxx 9126)  
  • Dbcc alloc on a database couldn't complete due to bufman error. Dbcc verify on individual tables was returning "DBCC Inconsistent Disk Block Headers" errors.


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

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 for Me (Login required).

Search for additional results

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