Heroku: rogue transfer in progress

Question

I started a migration on Heroku last night that gave me no feedback for hours, and which I eventually stopped because it wasn't clear if the system was even doing anything.

Ever since, it's been a nightmare. I cannot access the relevant database tables in heroku console, I can't migrate, rollback, or use pgbackups.

Helpfully, pgbackups gave me a one line explanation just now:

a transfer is currently in progress

This I assume is the migration I tried to execute hours ago. How can I stop whatever Heroku is doing so I can do a quick restore and get back up and running?

Answer 1

You can remove the problem backup stuck in the "a transfer is currently in progress" by finding the name of the backup and then destroying it. E.g.

heroku pgbackups

My problem backup was listed like this:

b210 | 2013/01/02 12:29.33 | unknown | DATABASE_URL

So to destroy it I just did:

heroku pgbackups:destroy b210

It removed the problem backup for me so I could get on with using pgbackups again properly.

Answer 2

I just had this problem too. Found an easier way of fixing it - briefly remove the pgbackups addon.

heroku addons:remove pgbackups
heroku addons:add pgbackups

WARNING as mentioned in the comments below, this will destroy all extant backups!