cancel
Showing results for 
Search instead for 
Did you mean: 

HANA SQL SCRIPT timeout after 12 hours (blocking garbage collection for too long period)

Former Member
0 Kudos

Hello,

I'm trying to run some analysis on data using HANA Studio. We have around 10 Gb of data in the table for analysis (137 Mio records, 16 columns, only integer and double). I have several scripts for analysis either using PAL or R. Both scripts run more than 12 hours, and then stop with the following error:

Could not execute 'CALL ANALYSE()' in 12:mm:ss hours.

It is always about 12 hours and 10 minutes (+- several minutes).

If I check an indexserver trace, it says the following:

" The long running external transaction possibly incurs performance degradation of HANA database. Please commit/rollback a transaction in application or kill the connection by "ALTER SYSTEM DISCONNECT SESSION '434063' " "

and then

"The Connection is disconnected forcefully because it is blocking garbage collection for too long period."

Do you know, how can I change/disable this 12-hours timeout?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member196555
Participant
0 Kudos


What version of HANA Database are you using?

Can you also generate an OOM dump and analyze the memory allocation matrix?

Regards,

Harshad Mishrikotkar.