SAP Knowledge Base Article - Preview

2297346 - An internal error "slib/s_blockmap.cxx:12664" happened and FP index corrupted.

Symptom

1) An internal error "slib/s_blockmap.cxx:12664" happened while extracting data.
  I. 02/28 14:37:36. 0000086265   The following exception is BUFMAN_BLOCKMAP_INFO_ERROR (-1009047)
  I. 02/28 14:37:36. 0000086265   from s_ROBlockmapCursor::Find
  I. 02/28 14:37:36. 0000086265 Blockmap Member Variables for 1c64beb3c8
  I. 02/28 14:37:36. 0000086265 From slib/s_dpidx.cxx:571
  I. 02/28 14:37:36. 0000086265   _nextPartitionForHelperFlush = 0
  ............
  ............
  I. 02/28 14:37:36. 0000086265 Exception Thrown from slib/s_blockmap.cxx:12664, Err# 0, tid 1848 origtid 1848
  I. 02/28 14:37:36. 0000086265    O/S Err#: 0, ErrID: 2091 (s_internalexception); SQLCode: -1001012, SQLState: 'QFA12', Severity: 18
  I. 02/28 14:37:36. 0000086265 [20521]: Internal state violation, please contact SAP IQ support

2) Stacktrace
  void StackTraceForThisThread(.................
  void s_blockmap::ThrowError(s_bufman_errorInfo,.................
  s_buf*s_ROBlockmapCursor::Find(.................
  void*s_bArrayCursor::Find(.................
  void s_bArrayLocater::LoadBlock(.................
  unsigned*s_bArrayLocater::LocateTokenRecord(.................
  s_indexfetch::s_fetchRetVal hs_dpfetch::FetchNoCopyContiguous(.................
  int s_fetchRow::FetchContiguous()+.................
  int vp_Cursor::Fetch()+.................
  int dfjo_HashParaT1::FetchOpus()+.................
  int dfo_cOrderByParaIn::ExecWork(.................
  void workAllocator::DoWork(.................

3) DBCC report
  ** DBCC Status Errors Detected ******
  ** DBCC Unknown Exceptions 1 ******
      
  ================================================== ============================== ======
  Index Summary   
  ================================================== ============================== ======
  ** Inconsistent Index Count 1 ******
     Verified Index Count 62 
  ** Non-Completed Index Count 1 ******
  
  ** Inconsistent Index OWNER001.TAB001_blockmap_error.ASIQ_IDX_T3386_C37_FP ******
 
4) It seems like it's very similar with CR 786326 which is dup of 786619.
     Those CRs have been fixed in SP10 PL10.
 
  [CR 786326]
  I. 06/26 23:47:46. 0000004870 Exception Thrown from dblib/db_iqutility.cxx:8665, Err# 20, tid 6 origtid 6
  I. 06/26 23:47:46. 0000004870    O/S Err#: 0, ErrID: 1034 (db_dbccexception); SQLCode: -1000276, SQLState: 'QDB69', Severity: 23
  I. 06/26 23:47:46. 0000004870 [21094]: At least one mode and target must be specified. 
  I. 06/27 00:01:57. 0000004870   The following exception is BUFMAN_BLOCKMAP_INFO_ERROR (-1009047)
  I. 06/27 00:01:57. 0000004870   from s_ROBlockmapCursor::Find
  I. 06/27 00:01:57. 0000004870 Blockmap Member Variables for 0x12fcedb888
  I. 06/27 00:01:57. 0000004870 From slib/s_dpidx.cxx:563
  ............
  ............
  I. 06/27 00:01:58. 0000004870 Exception Thrown from slib/s_blockmap.cxx:12531, Err# 0, tid 1270 origtid 1270
  I. 06/27 00:01:58. 0000004870    O/S Err#: 0, ErrID: 2091 (s_internalexception); SQLCode: -1001012, SQLState: 'QFA12', Severity: 18
  I. 06/27 00:01:58. 0000004870 [20521]: Internal state violation, please contact SAP IQ support
  
  *** DBCC report from CR 786326
  I. 06/27 00:03:19. 0000004870 ** DBCC Status: Errors Detected  ******
  I. 06/27 00:03:19. 0000004870 ** DBCC Unknown Exceptions: 3  ******
  I. 06/27 00:03:19. 0000004870  :   
  I. 06/27 00:03:19. 0000004870 Index Summary:   
  I. 06/27 00:03:19. 0000004870 ** Inconsistent Index Count: 3  ******
  I. 06/27 00:03:19. 0000004870    Verified Index Count: 45 
  I. 06/27 00:03:19. 0000004870 ** Non-Completed Index Count: 3  ******
  I. 06/27 00:03:19. 0000004870  :   
  I. 06/27 00:03:19. 0000004870 Allocation Summary:   
  I. 06/27 00:03:19. 0000004870    Blocks Total: 183500772 
  I. 06/27 00:03:19. 0000004870    Blocks in Use: 92171126 
  I. 06/27 00:03:19. 0000004870 ** Blocks with Multiple Owners: 2  ******


Read more...

Environment

SAP IQ 16.0. SP10 PL07
Solaris 10

Product

SAP IQ 16.0

Keywords

IQ, slib/s_blockmap, s_ROBlockmapCursor, s_buf*s_ROBlockmapCursor::Find, BUFMAN_BLOCKMAP_INFO_ERROR, Internal state violation, slib/s_dpidx , 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.