SAP Knowledge Base Article - Preview

2923107 - SAP IQ aborts with "s_blockmap_ondisk::DeleteBlockmapEntry" stacktrace

Symptom

SAP IQ aborts with following stacktrace during a loading job.

  • stacktrace

...
hos_ABORT

ThrowAbort
Throw
s_blockmap_ondisk::DeleteBlockmapEntry
s_blockmap::DeregisterPhysicalBlockId
s_blockmap::Destroy
s_blockmap::DestroyAllMappedPagesInMemory
s_blockmap::DestroyAllMappedPages
hs_csort::~hs_csort
hs_csort::~hs_csort
dfo_HGIndexInsert::~dfo_HGIndexInsert
dfo_HGIndexInsert::~dfo_HGIndexInsert
dfo::DestroyLastLeaf
dfo::ClearAndDestroyChildren
dfo_Root::~dfo_Root
dfo_Root::~dfo_Root
void throwsafe_delete<dfo_Root>
db_dmlcommand::Shutdown
db_dmlcommand::~db_dmlcommand
db_dmlcommand::~db_dmlcommand
db_LoadTable::~db_LoadTable
db_LoadTable::db_LoadTableTerminator
...

  • * iqmsg of the loading session

...
I. 05/06 07:31:10. 0001091347 [20897]: 42000000 Rows, 7 Seconds
I. 05/06 07:31:19. 0001091347 [20897]: 43000000 Rows, 9 Seconds
I. 05/06 07:32:52. 0001091347 [bmp-trace-tout][rpbid] tid:1825 bmp:6000000a08976b08 lbn:5054758 next-lbn:5054760 pbn:34960306 nb:� compr?1 updateNext?0
I. 05/06 07:32:52. 0001091347 [bmp-trace-tout][rpbid] tid:1843 bmp:6000000a08976b08 lbn:5054918 next-lbn:5054920 pbn:100820045 nb:� compr?1 updateNext?0
I. 05/06 07:32:52. 0001091347 Warning, s_bufpartition::GetCleanPage is retrying to avert a potential deadlock, retry=1, tid=1843
I. 05/06 07:32:52. 0001091347 Warning, s_bufpartition::GetCleanPage is retrying to avert a potential deadlock, retry=1, tid=1825
I. 05/06 07:35:55. 0001091347 [20896]: Insert for 'cust_table' completed in 637 seconds. 43267031 rows inserted.
I. 05/06 07:35:58. 0001091347
I. 05/06 07:35:58. 0001091347
I. 05/06 07:35:58. 0001091347 **************************************************
I. 05/06 07:35:58. 0001091347 *** SAP IQ Abort:
I. 05/06 07:35:58. 0001091347 *** From: ...
I. 05/06 07:35:58. 0001091347 *** Rethrown from: oslib/hos_throw.cxx:313
I. 05/06 07:35:58. 0001091347 *** PID: 5376
I. 05/06 07:35:58. 0001091347 *** Exception Location: 0x9ffffffeb2e654d0
I. 05/06 07:35:58. 0001091347 *** Error ID: 514, Exception Type: hos_bitvecexception
...

But re-run worked fine and DBCC with verify mode returned 'No Error'.


Read more...

Environment

  • SAP IQ : 16.0 SP11 PL24 / Multiplex
  • O/S      : HP-UX on IA64 64bit 

Product

SAP IQ 16.0

Keywords

"s_blockmap_ondisk::DeleteBlockmapEntry"; "s_blockmap::DeregisterPhysicalBlockId", "hos_bitvecexception", CR821630,CR-821630, , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Bug Filed

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.