Rowstore Table Corruption

Possible Rowstore Table Corruption When Continuous Page Flush is Enabled:

Prerequisites:

1- SAP HANA database Revision 120 - 122.03
2- Continuous page flush is enabled
  (parameter global.ini -> [persistence] -> continuous_flush_interval_s> 0).
   In SAP HANA database SPS12 continuous page flush is enabled by default, even if the parameter      is not explicitly set Slow disk IO will increase the likelihood to run into this problem

Solution: 

Disable continuous page flush to prevent future corruptions by running the following SQL command:

ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'system') SET ('persistence','continuous_flush_interval_s') = '0' WITH RECONFIGURE;

To revert back -

ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'system') UNSET ('persistence', 'continuous_flush_interval_s') WITH RECONFIGURE; 

Note - Default Value is continuous_flush_interval_s > 0 .You have to set = 0 to disable.