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 ONE Support launchpad (Login required).

Search for additional results

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