SAP Knowledge Base Article - Preview

3122734 - Worker node in multiplex is shutting down with Operation not permitted on an OFFLINE DBSpace myiqdb_space 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
    ...

    Openfile() on /directory/name/filename failed with DirectIO. Trying again without DirectIO.

  • 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 "myiqdb" 


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

Search for additional results

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