SAP Knowledge Base Article - Preview

2588457 - The secondary node crash at s_dbmvbio::UpdateProxyFL

Symptom

The secondary node crash when doing load table.

  • **************************************************
    *** SAP IQ Abort:
    *** From: slib/s_db.cxx:7909
    *** Rethrown from: oslib/hos_throw.cxx:313
    ......
    ===== Thread Number 140012865898240 =====
    s_dbmvbio::UpdateProxyFL
    s_dbmvbio::SecondaryProxyOutOfSpaceHandler
    s_dbmvbio::Allocate
    s_VersioningBlockmap::Allocate
    s_blockmap::AllocOrReallocPhysicalBlocks
    s_buf::Write
    s_blockmap::HelperFlush
    s_commitRequest::Perform

  • error message on coordinator node at the corresponding time:
    ======================================================
    ... sqlcode -210
    ... string_id 2169
    ... _sqlstate 67792968
    ... odbc30state 67108865
    ... sybcode 8405
    ... severity 21
    ... odbc20state 67108865
    ... Exception Thrown from dblib/db_catalog.cxx:2992, Err# 0, tid 14 origtid 14
    ... O/S Err#: 0, ErrID: 5122 (st_sacbexception); SQLCode: 0, SQLState: '00000', Severity: 10

  • dbspace usage monitor log shows there are enough space at the corresponding time:
    ====================================================
    begin to execute sql:select DBSpaceName,Usage,TotalSize from sp_iqdbspace()
    execute sql statement: sql=select DBSpaceName,Usage,TotalSize from sp_iqdbspace('netview_main')
    DBSpaceName:[IQ_SYSTEM_MAIN],Usage:[23],TotalSize:[5.99T]
    DBSpaceName:[IQ_SYSTEM_TEMP],Usage:[1],TotalSize:[2.17T]
    DBSpaceName:[netview_main],Usage:[66],TotalSize:[494T]


Read more...

Environment

SAP IQ 16.0 SP11 PL09

Product

SAP IQ 16.0

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

Search for additional results

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