Import file crashes HANA

[selim_derouiche]

Hello,

I'm sql developer, I'm developping sql script to import files into HANA database.

I Have ~8GO file, 19 fields, 70 characters per line.

I made a mistake in the create table, I invert columns position so character strings are going into numeric ones.

Table was created with UNLOAD PRIORITY 9, delta log is disabled, it is not partitionned.

When I import the file

IMPORT FROM CSV FILE '/odi/file.dmp' INTO ODI.C$_FILE   
WITH RECORD DELIMITED BY '\n'         
FIELD DELIMITED BY ';'        
OPTIONALLY ENCLOSED BY '"'        
ESCAPE '"'        
BATCH 10000        
DATE FORMAT 'YYYY-MM-DD'        
TIMESTAMP FORMAT 'YYYY-MM-DD-HH24.MI.SS.FF6'        
ERROR LOG '/odi/log/file.err'        
FAIL ON INVALID DATA   
THREADS 10  
TABLE LOCK

We got an OOM, since, I put the right columns order, it's ok, but I want to know why HANA Database has crashed.

com.sap.db.jdbc.exceptions.jdbc40.SQLNonTransientConnectionException: Data receive failed [Connection reset].

Can someone explain me what happens please ? are errors logged somewhere to be written in error file later for example ? there is any config to change this behaviour, I don't want that the database crashes because an import file, even There is errors I expect that only import fails without OOM. For information import table is not target table so if there is options to put on that tabe I can, it is created before import and dropped later.

Thanks for help.

Version 2.00.036.00 (hana2sp03) on SUSE Linux Enterprise Server 12 SP4. 300Go of resident memory

[HakanHaslaman]

If you are able to reproduce the issue and have a crash dump, I would recommend to open a support incident.