We are connecting to Redshift database from Matillion. our jobs occassionally getting failed with error "[Amazon](600000) Error setting/closing connection: Connection reset by peer." Anyone faced this type of issues and found any work around?

Matillion ETL
1

we are connecting to Redshift database from Matillion. our jobs occassionally getting failed with error
“Amazon Error setting/closing connection: Connection reset by peer.”
Anyone faced this type of issues and found any work around?

2

To clarify, we are using Matillion on AWS EC2 host and connect to Redshift. this error is happening intermittently for last few months.

3

Hello @avnkumar​

Sorry to hear you have met this error, I would strongly recommend raising this with our support team here.

They can help diagnose what is causing this error for you.

Kind regards, Joe

4

Created a support case now. looking forward for a resolution. thanks