DBD::Pg::db pg_putcopyend failed: SSL SYSCALL error

[sabirlas]

We are copying tables from Oracle to Azure PostgreSQL in parallel job mode using below command

ora2pg -t COPY -J 64 -a 'TABLE[AUTHOR]' -T /data1/migration/plit_lob_copy/temp_data -c ../ora2pg.conf

After running for some time it is giving below error. Can you help to fix it.

DBD::Pg::db pg_putcopyend failed: SSL SYSCALL error: Connection timed out at /usr/local/share/perl5/Ora2Pg.pm line 15042.gress.
FATAL: SSL SYSCALL error: Connection timed out

[darold]

I would like to help but this is a network issue, you may have a firewall or possibly at Azure side that is resetting the connection leading to this timeout. I think that in this case Ora2Pg could try to reconnect to the remote host before dying, I mark this issue as need enhancement to not forget.

[sabirlas]

Hi darold
Thank you for you reply.
I would like to share one thing which I have observed.
When I run this command on a on-premise staging postgresql database it creates 64 session in Oracle and only one session on the postgresql. But if I run it to copy it to Azure Postgresql (PAAS) it creates 64 sessions in postgreSQL as well. Any idea why it on azure also it is having 64 sending sessions. Could this be the reason of some sessions are getting terminated with the mentioned error after sometime.

Below is the server settings regarding timeout on Azure PostgreSQL PAAS
idle_in_transaction_session_timeout 0
statement_timeout 0
tcp_keepalives_idle 0
tcp_keepalives_interval 0