Immutable solution version
`heroku pg:copy` fails after a few `starting copy` logs
Complete solution
Shows how to fix `heroku pg:copy` fails after a few `starting copy` logs. Use it when you hit this exact problem. Skip it when your error message or symptom looks different.
TL;DR
Run with HEROKUDEBUG=1 and HEROKUDEBUG_HEADERS=1 to see where the copy stalls, and consider pinning the CLI version in your CI install step if a newer release broke it.
Steps
- Do you want to request a feature or report a bug? ----------------------------------------------------- We are running on the latest version. We use
curl https://cli-assets.heroku.com/install-ubuntu.sh | shto install the heroku cli. - If heroku pg:copy fails after a few 'starting copy' logs on the latest CLI, one reporter resolved it by downgrading the Heroku CLI to 9.5.1. Run with HEROKUDEBUG=1 and HEROKUDEBUG_HEADERS=1 to see where the copy stalls, and consider pinning the CLI version in your CI install step if a newer release broke it.
When to use
You are seeing this: Do you want to request a feature or report a bug? ----------------------------------------------------- We are running on the latest version. Use this skill when you run into "heroku pg:copy fails after a few starting copy logs".
When not to use
If your error message or symptom does not match what is described above, this is probably not your fix. Search for your exact error text instead of forcing this one to fit.
Versions
Versions mentioned in the source: 9.5.1. If you are on something much newer or older, the details may have shifted.
Why this happens
The original report does not dig into a root cause. It documents the symptom and the fix that resolved it.
Sources
- https://cli-assets.heroku.com/install-ubuntu.sh
Evidence
In gh:heroku/cli#3146 (https://github.com/heroku/cli/issues/3146), the reporter ran into this: Do you want to request a feature or report a bug? ----------------------------------------------------- We are running on the latest version. We use curl https://cli-assets.heroku.com/install-ubuntu.sh | sh to install the heroku cli. The verified resolution: If heroku pg:copy fails after a few 'starting copy' logs on the latest CLI, one reporter resolved it by downgrading the Heroku CLI to 9.5.1. Run with HEROKUDEBUG=1 and HEROKUDEBUG_HEADERS=1 to see where the copy stalls, and consider pinning the CLI version in your CI install step if a newer release broke it.
By @issueatlas · Version 2 · Exact version
Embed this skill
Add this card to a website or documentation page. It links to the current skill on Vectle.
<a href="https://vectle.com/skills/skl_52gR2OptfYc_tVDYeix-EQ" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">`heroku pg:copy` fails after a few `starting copy` logs <span>— Vectle</span></a>