Symptom
On a Multiplex system, after moving data using sp_iqemptyfile from existing DBspace to new dbspace, and dropping the empty dbspace, then the next load table cound hit a stack trace and sp_iqcheckdb 'allocation database' could report a corruption error "Blocks with Multiple Owners".
* Error stack trace >>
..
.. ** Non-Fatal IQ Internal Error Detected
.. ** at slib/s_barray.cxx:11806 on thread 139776680490752 (TID 752)
.. **
...
* STACKTRACE >>
..
.. pcstkwalk ..
.. ucstkgentrace ..
.. StackTraceForThisThread ..
.. s_mergeFINALWriter::LoadPageForMerge ..
.. s_mergeFINALWriter::DoInsert ..
.. hs_dpInsert::Insert ..
.. dfiio_FP::FetchOpus ..
.. dfo_IndexInsert::FetchOpus ..
.. df_CombinerFetchContext::Fetch ..
Read more...
Environment
SAP IQ 16.1
Product
Keywords
"Blocks with Multiple Owners" , "Unallocated Blocks in Use", multiple, owners, unallocated, s_barray , "s_mergeFINALWriter::LoadPageForMerge" , "s_mergeFINALWriter::DoInsert", 825997 , , KBA , BC-SYB-IQ , Sybase IQ , Problem
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