Thursday, February 11, 2016

1630154 - SAP HANA Database: Crash of HDBIndexserver while data load

Symptom
You try to load data into the SAP HANA Database and run into errors.
The following error types indicate a relation to this specific error:
  • Crash during load (SIGSEGV/signal 11)
  • Corrupted data in the loaded table after a crash. You might get an errormessage like the following or similar:
  • Error "trying to read type Bool but found type unsupported"



Other Terms
SAP HANA Database, Crash, Memory Corruption, NewDB, correction, CSV, load, Data services


Reason and Prerequisites
Prerequisite: SAP HANA Database: Revision 15 or previous

Reason: Due to a programming error in SAP HANA Database Revision 15 or previous versions a memory corruption can occur during the load of data. This leads to crashes of HDBIndexserver when this part of memory is accessed again.


Solution
Update to SAP HANA Database Revision 16 or later

There is no fully working workaround available.
Error probability can be reduced with the following load settings
  • parallel loading threads reduced to a minimum
  • Disable AUTO_MERGE for the affected tables with
  • ALTER TABLE <table> WITH PARAMETERS('AUTO_MERGE'='OFF')



Header Data

Released On 09.09.2011 14:08:05
Release Status Released for Customer
Component HAN-DB SAP HANA Database
Other Components
HAN-DB-ENG SAP HANA DB Engines
Priority Correction with high priority
Category Program error

No comments:

Post a Comment