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

Search for additional results

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