cbcopy freeze in the middle

[MennaKhaled]

Table to be copied at source:

copy command:

Logs:

And then it's just stuck. First it complained the destination DB and the destination table aren't there so I created them then reinitiated the command and now completely stuck.

Are their logs to check at the source server? the command is initiated at the destination.

[robertmu]

Based on the command you shared, it seems that specifying --dest-host=127.0.0.1 (localhost) may be causing communication failures between the helper processes.

Here's what might be happening:

1. cbcopy works by starting a cbcopy_helper process on both the source and destination database servers
2. When you specify --dest-host=127.0.0.1, the source database's helper process likely tries to connect to port 1024 on localhost (itself), not to the actual destination server
3. The source helper process will continue retrying these connection attempts, causing the tool to appear frozen while it waits for a connection that can never be established
4. This could cause the data transfer to fail silently and the process to hang, as shown in your logs