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.