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.