SAP Knowledge Base Article - Preview

2757723 - HANA secondary DB is not coming up

Symptom

Secondary database is failing to start due to checksum error from persistence area.

1. Crash Stack
[CRASH_STACK] Stacktrace of crash: (2019-02-11 07:19:10 016 Local)
----> Pending exceptions (possible root cause) <----
exception 1: no.3020043 (DataAccess/PageAccess/impl/PageImpl.cpp:402)
Wrong checksum: Calculated 4120484705 with checksum algorithm 1 (LogCRC32SparseDataAdler32), stored 3810173030.; $verifiedForInternalReorganization$=false; $pno$=0x1007L; $ppno$=0x1800000d4898P [0xd4898000,16k-RowStore,0]; $lpno$=0x1007L; $ppno$=0x1800000d4898P [0xd4898000,16k-RowStore,0]
exception throw location:
1: 0x00007f711e55c0d3 in PageAccess::Page::verifyChecksum(PageAccess::SizeClass) const+0x60 at PageImpl.cpp:398 (libhdbdataaccess.so)
2: 0x00007f711e55d296 in PageAccess::PageControlBlock::onLoad(unsigned int, PageAccess::PageNo const&, PageAccess::PageNo const&, bool, bool)+0x8b2 at Page.hpp:298 (libhdbdataaccess.so)
3: 0x00007f711e54b35d in PageAccess::LogicalPageControlBlock::onLoad(unsigned int, bool, bool)+0x1b9 at LogicalPageImpl.cpp:350 (libhdbdataaccess.so)
4: 0x00007f711e4d1d68 in PageAccess::AbsolutePageAccessLoadCallback::copyPageData(bool, unsigned long, PageAccess::SuperblockNo const&, char const*, unsigned long, bool)+0x254 at AbsolutePageAccessImpl.cpp:1911 (libhdbdataaccess.so)

2. Daemon trace
Comment file contains: nameserver: persistence initialization failed

3. Nameserver trace
==
Wrong checksum: Calculated 4120484705 with checksum algorithm 1 (LogCRC32SparseDataAdler32), stored 3810173030.; $verifiedForInternalReorganization$=false; $pno$=0x1007L; $ppno$=0x1800000d4898P [0xd4898000,16k-RowStore,0]
exception throw location:
...
[29863]{-1}[-1/-1] 2019-02-11 16:02:30.120652 f topology Topology.cpp(00339) : assign failed with persistence startup error. exception 1: no.3020027 (DataAccess/PageAccess/impl/PageImpl.cpp:605)
Invalid checksum algorithm 11.; $verifiedForInternalReorganization$=false; $pno$=0x20L; $ppno$=0x9000001b2900P [0x1b2900000,256k,0]
exception throw location:
1: 0x00007f555ca09d14 in PageAccess::Page::calcChecksum(PageAccess::ChecksumAlgorithm, unsigned long) const+0x100 at PageImpl.cpp:605 (libhdbdataaccess.so)
2: 0x00007f555ca09e13 in PageAccess::Page::calcChecksum(PageAccess::ChecksumAlgorithm, PageAccess::SizeClass) const+0xa0 at PageImpl.cpp:567 (libhdbdataaccess.so)
3: 0x00007f555ca0a093 in PageAccess::Page::verifyChecksum(PageAccess::SizeClass) const+0x20 at PageImpl.cpp:396 (libhdbdataaccess.so)
4: 0x00007f555ca0b296 in PageAccess::PageControlBlock::onLoad(unsigned int, PageAccess::PageNo const&, PageAccess::PageNo const&, bool, bool)+0x8b2 at Page.hpp:298 (libhdbdataaccess.so)
5: 0x00007f555c9f935d in PageAccess::LogicalPageControlBlock::onLoad(unsigned int, bool, bool)+0x1b9 at LogicalPageImpl.cpp:350 (libhdbdataaccess.so)
6: 0x00007f555c9f18f8 in PageAccess::LogicalPageAccessImpl::loadPageInternal(PageAccess::PageNo const&, DataContainer::ContainerID const&, ResourceManager::ResourceHint const&, ResourceManager::Disposition, bool, bool&, ResourceManager::HandleMissingResourceMode, bool const&)+0x274 at LogicalPageAccessImpl.cpp:1451 (libhdbdataaccess.so)
7: 0x00007f555c9f35ac in PageAccess::LogicalPageAccessImpl::loadPage(PageAccess::PageNo const&, DataContainer::ContainerID const&, ResourceManager::Disposition, Synchronization::SharedHandle&, ResourceManager::HandleMissingResourceMode)+0x38 at LogicalPageAccessImpl.hpp:130 (libhdbdataaccess.so)
8: 0x00007f555c9f364e in PageAccess::LogicalPageAccess::loadPage(PageAccess::PageNo const&, DataContainer::ContainerID const&, ResourceManager::Disposition, Synchronization::SharedHandle&, ResourceManager::HandleMissingResourceMode)+0x4a at LogicalPageAccessImpl.cpp:455 (libhdbdataaccess.so)
==


Read more...

Environment

  • HANA 1.0
  • HANA 2.0
  • Replication (Delta Data Shipping)

Product

SAP Customer Relationship Management 7.0 ; SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

HANA, Replication, Secondary, check_active_persistence_for_delta_sync, --force_full_replica, checksum, Wrong checksum: Calculated , KBA , HAN-DB-HA , SAP HANA High Availability (System Replication, etc.) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.