search

coorasse / heroku-api-postgres

A Ruby library to invoke Heroku Postgres APIs
MIT License
12 stars 12 forks source link

Capturing backups is broken #7

Open mashedkeyboard opened 5 years ago

mashedkeyboard commented 5 years ago

Upon trying to capture a backup, I get the following response:

D, [2019-08-09T22:28:20.859430 #15130] DEBUG -- : [httplog] Connecting: postgres-starter-api.heroku.com:443
D, [2019-08-09T22:28:21.634924 #15130] DEBUG -- : [httplog] Sending: POST http://postgres-starter-api.heroku.com:443/client/v11/databases/[redacted]/backups
D, [2019-08-09T22:28:21.635028 #15130] DEBUG -- : [httplog] Data: {}
D, [2019-08-09T22:28:21.635071 #15130] DEBUG -- : [httplog] Status: 201
D, [2019-08-09T22:28:21.635114 #15130] DEBUG -- : [httplog] Benchmark: 0.43098 seconds
D, [2019-08-09T22:28:21.635167 #15130] DEBUG -- : [httplog] Response:
{"uuid":"[redacted]","num":2,"from_name":"DATABASE","from_type":"pg_dump","from_url":"postgres://[redacted]:[redacted]@[redacted]:[redacted]/[redacted]","to_name":"BACKUP","to_type":"gof3r","to_url":"[redacted]","options":{},"source_bytes":null,"processed_bytes":0,"succeeded":null,"warnings":0,"created_at":"2019-08-09 21:28:21 +0000","started_at":null,"canceled_at":null,"updated_at":null,"finished_at":null,"deleted_at":null,"purged_at":null,"num_keep":2}

Subsequently running the .wait polling feature gives me this trace ad infinitum:

D, [2019-08-09T22:28:25.061589 #15130] DEBUG -- : [httplog] Connecting: postgres-starter-api.heroku.com:443
D, [2019-08-09T22:28:25.460741 #15130] DEBUG -- : [httplog] Sending: GET http://postgres-starter-api.heroku.com:443/client/v11/apps/[redacted]/transfers/
D, [2019-08-09T22:28:25.460870 #15130] DEBUG -- : [httplog] Data: 
D, [2019-08-09T22:28:25.460937 #15130] DEBUG -- : [httplog] Status: 404
D, [2019-08-09T22:28:25.461006 #15130] DEBUG -- : [httplog] Benchmark: 0.09356 seconds
D, [2019-08-09T22:28:25.461102 #15130] DEBUG -- : [httplog] Response:
<h1>Not Found</h1>

No backup is seen when running heroku pg:backups either.

Any ideas?

vincentlkl commented 5 years ago

@mashedkeyboard Did you manage to find out why is it so?

backups_client.list(app_id) i am getting same error too. <h1>Not Found</h1>

I cannot debug anything as there are no other error logs

However, I found this: https://devcenter.heroku.com/articles/connecting-to-heroku-postgres-databases-from-outside-of-heroku

I don't know if both are related.

coorasse commented 3 years ago

what is the database plan? (free, hobby, standard, etc...)