Symptom
SAP IQ has been aborted with following stacktrace during a loading job or just selecting query.
- stacktrace
...
hos_ABORT
ThrowAbort
Throw
hos_bitvec::ClearBits ..
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
...
-
other * iqmsg of select query
I. 07/04 19:14:42. 0000013744
.. Txn 1182282608 0 1182282608
.. Warning: s_dbmvbio::Allocate has timed out on _proxyFLcv inside tid:140082567689984 lockTimeoutDuration:10
.. Warning, s_bufpartition::GetCleanPage is retrying to avert a potential deadlock, retry=1, tid=140082567689984
..
.. Warning, s_bufpartition::GetCleanPage is retrying to avert a potential deadlock, retry=1, tid=140082563479296
.. Query A1302052_L_0__20220704-192201_12058_txn_1182282608 executed in: 438.287 second(s)
..
.. **************************************************
.. *** SAP IQ Abort:
.. *** From: /home/iqabuild/views/links/r16.1.0_sp04_nbld_linux_64/gitsrc/cm/iqa/include/hos_bv.h:603
..
.. *** Error ID: 514, Exception Type: hos_bitvecexception
.. *** Thread: 140091571709696 (TID: 34, Original TID: 34)
...
===== Thread Number 140091571709696 (IQ connID: 0000013744) =====
..
.. DumpAllThreads ..
.. hos_ABORT ..
.. Throw ..
.. hos_bitvec::ClearBits ..
.. 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_cOrderBy::~dfo_cOrderBy ..
.. dfo_cOrderByParaExch::~dfo_cOrderByParaExch ..
.. dfo::DestroyLastLeaf ..
.. dfo_Root::~dfo_Root ..
.. dfo_Root::~dfo_Root ..
.. st_cursor::~st_cursor ..
.. st_cursorIQtoSA::~st_cursorIQtoSA ..
.. df_CloseCursor::~df_CloseCursor ..
.. st_iqdml::CloseCursor ..
.. UIQDML_CloseCursor+0x18
...
But re-run worked fine and DBCC with verify mode returned 'No Error'.
Read more...
Environment
- SAP IQ : 16.0 SP11.24 , 16.1 SP04.09 ,16.1 SP04.12,
- All OS
Product
Keywords
"s_blockmap_ondisk::DeleteBlockmapEntry"; "s_blockmap::DeregisterPhysicalBlockId", "hos_bitvecexception", "hos_bitvec::ClearBits" , CR821630,CR-821630,CR-826586, , 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.
SAP Knowledge Base Article - Preview