SAP Knowledge Base Article - Preview

3299776 - HANA indexserver failed to start with error “Allowed rowcount exceeded: was rowPosCount”

Symptom

  • Indexserver failed to start, you can see error like below in indexserver trace.
    Sometimes indexserver even got crashed with same error.

  • You have referred to note 3013617 to enable delta merge during startup, but the error remains.
    [global.ini] > [persistence] >[merge_during_crash_recovery] = true 

[58696]{-1}[-1/-1]  e CSARedo          OverflowCheck.cpp(00211) : void CSAccessor::Redo::OverflowCheck::incSumOfRowsForInsert(size_t) failed at /data/jenkins_prod/workspace/310aos5ayq/s/CSAccessor/Redo/OverflowCheck.cpp:143! Table = <db_name>::<schema_name>:<table_name> (t 305654), sum of row positions = 2147483643, sum of row positions in delta = 1029048763, sum of row positions deleted = 1023410176, row positions change= 3
[58696]{-1}[-1/-1]  e CSARedo          RedoHandler.cpp(01372) : Exception during REDO of ; TableName='<schema_name>:<table_name>' (tableOID=305654), ContainerID=0xfe0f173f36
...............
[58696]{-1}[-1/-1]  e Logger           RecoveryHandlerImpl.cpp(02832) : ERROR REPLAYING LOG, last potential recoverable position: 0x24910254b49, message: exception  1: no.3100025  (CSAccessor/Redo/OverflowCheck.cpp:143) TID: 58696
    Allowed rowcount exceeded: was rowPosCount [2147483643] by current rowCount [3] in [<db_name>::<schema_name>:<table_name> (t 305654)] with fragmentSet [FragmentID=945, FragmentType=delta, FragmentColumnCount=347, FragmentRowCount= 1029048763, FragmentBaseRowID=1827090069, FragmentMaxRowID=2856138838, FragmentObjectMinContiguousRowID=1827090069, ColumnFragmentDeltaRowIDObject[isInvertedIndexEmpty=false, DeltaRowIDDictionaryStorage[usingTransientAdd=true, usingPersistentUnsortedAdd=false, m_baseTransientVid=0, m_baseTransientRowID=1827090069, m_minRowID=1827090069, m_maxRowID=2856138838, m_lastFlushedBaseTransRowID=1827090069, m_lastFlushedBaseTransVID=0, m_Values.size()=1029048770, ParentFragment=945F:0xfe0f173f36C]]][FragmentID=946, FragmentType=main, FragmentColumnCount=347, FragmentRowCount= 1118434881, FragmentBaseRowID=1, FragmentMaxRowID=1827090068, FragmentObjectMinContiguousRowID=1, isActiveMainFragment=true]
exception throw location:



Read more...

Environment

  • SAP HANA Platform Edition 1.0
  • SAP HANA Platform Edition 2.0

Product

SAP HANA, platform edition all versions

Keywords

allowed rowcount exceeded, indexserver, start, delta merge , KBA , HAN-DB , SAP HANA Database , 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.