Recently facing "Out of Memory Error detected" issue in Matillion

I'm recently facing "Out of Memory Error detected" issue in Matillion, I am using Matillion ETL

Version: 1.68.21 (build 1f89dc0-277150) AMI Version: 1.68.21

 

While this error, issue Matillion automatically restarts itself and some schedules are canceled and there is an update for the next version also available So, is it good to update next version or are there any ideas to overcome this issue 

 

 

Hello @HariRamK

Thank you for your post, I am sorry to hear this, It will need a closer look by our support team to find out what is causing this.

I have raised a support case on your behalf and a member of the support ream will be in contact shortly.

Kind regards, Joe

It's good to hear from you @JoeCommunityManager​, I'm eagerly waiting for support team help.

Keep me posted @HariRamK​ I am here if you need anything else.

Kind regards, Joe

Hi,

 

I'm facing the same issue, what was your solution?

 

Thanks,

Oren

Hi @orenfl2

Which version of Matillion are you using currently?

Hi,

 

1.75.20, the latest LTS one.

It happened also on 1.75.8, and started only since end of December.

There are few ideas from me,

1.You can upgrade to Latest version of Matillion (after reading the release note)

2.Split your project into different folders like Production,stage,Archieve this may help you lot, I think.

 

 

Thank you.

I'm already on the latest.

Will try and check other options.

3.If you're using any python script with dataframe try to empty that after the script run.

4.use vacuum option to job that also make great change.

 

1.75.20, the latest LTS one.

I don't think this one is the latest version, try for 1.76 or 1.77 they both are not LTS, but it would help.

Unfortunately, I cannot update to a non-LTS version.

Oh ok, you can check other option and if not work you can remaind me.

 

Thank you!

I've opened a support case, but in parallel looked into the catalina.out log and may have found the root cause.

Will know in the coming days, if it helped...

yeah ok @orenfl2