SAP Knowledge Base Article - Preview

3122734 - Worker node in multiplex is shutting down with Operation not permitted on an OFFLINE DBSpace gls_rdb error

Symptom

Created a new multiplex system, everything comes up just fine.  However, as soon as data is inserted using insert location, the worker node goes down.

Server1 is Coordinator
Server2 is worker node

  • iqmsg log:
    OwnerObjectName        dbo.table1
    I. 11/19 12:18:00. 0000000093 Warning: s_blockmap is throwing while user locked. bmp:0x7f955c02aec8 lockRefCount:1 created from:dblib/db_table.cxx:3191 locked from:slib/s_blockmap.cxx:1341

    ********************************************************
    **
    **       Informational stack trace from Diagnostic Stacktrace in s_blockmap::ThrowError for user locked blockmap
    **       at slib/s_blockmap.cxx:13534 on thread 140281639098112 (TID 22)
    **
    **  Error from IQ connection:  SA connHandle: 1000000093  SA connID: 6  IQ connID: 0000000093  User: dbo

    Stack includes:
    s_blockmap
    hs_vdo
    db_TableDef::LoadTable
    db_Catalog::LoadTable
    st_command::DoCmdThroughResourceGate
    db_iqddl::IQUtilityFetch
    st_SAIQInterfaceInfo::callFunction
    st_SAIQInterface::RunIQFunc
    st_SAIQInterface::Execute
    IQUtilityData::FetchDataFromCursor
    DB_Exec_event_handler
    EventHandler::do_request
    db_Catalog::FindTableVersion
    db_Catalog::FindTableByID
    db_catReplRow::OpenTable
    db_catReplRow::UpdateCatalogFromReplRows
    run_procedure
    dbi_iq_utilities

    Exception Thrown from slib/s_blockmap.cxx:6608, Err# 0, tid 22 origtid 22
    O/S Err#: 0, ErrID: 2105 (s_offlinedbspaceexception); SQLCode: -1009173, SQLState: 'QSB69', Severity: 14
    Operation not permitted on an OFFLINE DBSpace my_dbspace.
    sp_mpxprocesstlvlog exception, SQLSTATE=QSB69 [Operation not permitted on an OFFLINE DBSpace my_dbspace.
    -- (slib/s_blockmap.cxx 6608) ] runstate=S(1)
    ***Emergency Shutdown***
    Exception Thrown from dblib/db_iqutility.cxx:5351, Err# 46, tid 22 origtid 22
    O/S Err#: 0, ErrID: 1025 (db_catalogException); SQLCode: -1009413, SQLState: 'QCB11', Severity: 23
    [21051]: Secondary server cannot maintain catalog sync.
    -- (dblib/db_iqutility.cxx 5351)

  • srvlog:
    Handler for event 'ev_iqbegintxn' caused SQLSTATE 'QCB11'
    Secondary server cannot maintain catalog sync.
    -- (dblib/db_iqutility.cxx 5351)
    Database server shutdown due to HUP signal
    Starting shutdown of database "S01GLP32" 


Read more...

Environment

SAP IQ (all versions)

Product

SAP IQ 16.0

Keywords

KBA , BC-SYB-IQ , Sybase IQ , How To

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.