2588457 - The secondary node crash at s_dbmvbio::UpdateProxyFL - SAP IQ

• 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]

SAP IQ 16.0 SP11 PL09

KBA , BC-SYB-IQ , Sybase IQ , Problem