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.