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.
SAP Knowledge Base Article - Preview