Skip to content
This repository has been archived by the owner on Sep 4, 2021. It is now read-only.

Backup cluster failing at postgres dump step #4504

Closed
kipparker opened this issue Jan 17, 2019 · 1 comment
Closed

Backup cluster failing at postgres dump step #4504

kipparker opened this issue Jan 17, 2019 · 1 comment

Comments

@kipparker
Copy link

I'm unable to run a cluster backup. The process creates the json file, but always fails on the postgres dump step. The output doesn't have much detail:

Creating cluster backup...
16.88 KB 7.60 KB/s error dumping postgres database: error running postgres export: :

I can see each attempt is creating a job in the postgres app, but with no output there. The logs from postgres itself look like:

[2019-01-17T09:48:32.476155Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.476 UTC LOG:  connection received: host=100.100.85.0 port=56552
[2019-01-17T09:48:32.477125Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.477 UTC LOG:  connection authorized: user=flynn database=postgres
[2019-01-17T09:48:32.495478Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.495 UTC LOG:  connection received: host=100.100.85.0 port=56556
[2019-01-17T09:48:32.496471Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.496 UTC LOG:  connection authorized: user=flynn database=65be82f7dfad5cc0503bba9d3483427a
[2019-01-17T09:48:32.575545Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.575 UTC LOG:  disconnection: session time: 0:00:00.080 user=flynn database=65be82f7dfad5cc0503bba9d3483427a host=100.100.85.0 port=56556
[2019-01-17T09:48:32.581602Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.581 UTC LOG:  connection received: host=100.100.85.0 port=56558
[2019-01-17T09:48:32.582774Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.582 UTC LOG:  connection authorized: user=flynn database=67b0769d5d448f382a2bb17fe9ac93ea
[2019-01-17T09:48:32.772124Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.772 UTC LOG:  disconnection: session time: 0:00:00.190 user=flynn database=67b0769d5d448f382a2bb17fe9ac93ea host=100.100.85.0 port=56558
[2019-01-17T09:48:32.778066Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.778 UTC LOG:  connection received: host=100.100.85.0 port=56560
[2019-01-17T09:48:32.778877Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.778 UTC LOG:  connection authorized: user=flynn database=f61a900b42f0a7b1ceb9cc419a2753fa
[2019-01-17T09:48:32.841152Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.841 UTC LOG:  disconnection: session time: 0:00:00.063 user=flynn database=f61a900b42f0a7b1ceb9cc419a2753fa host=100.100.85.0 port=56560
[2019-01-17T09:48:32.847229Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.847 UTC LOG:  connection received: host=100.100.85.0 port=56562
[2019-01-17T09:48:32.848116Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.848 UTC LOG:  connection authorized: user=flynn database=fbb871e88453eec61e2bac39f6853859
[2019-01-17T09:48:32.900467Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.900 UTC LOG:  disconnection: session time: 0:00:00.053 user=flynn database=fbb871e88453eec61e2bac39f6853859 host=100.100.85.0 port=56562
[2019-01-17T09:48:32.905778Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.905 UTC LOG:  connection received: host=100.100.85.0 port=56564
[2019-01-17T09:48:32.906767Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.906 UTC LOG:  connection authorized: user=flynn database=postgres
[2019-01-17T09:48:32.958718Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.958 UTC LOG:  disconnection: session time: 0:00:00.053 user=flynn database=postgres host=100.100.85.0 port=56564
[2019-01-17T09:48:32.963953Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.963 UTC LOG:  connection received: host=100.100.85.0 port=56566
[2019-01-17T09:48:32.964862Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:32.964 UTC LOG:  connection authorized: user=flynn database=template1
[2019-01-17T09:48:33.016284Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:33.016 UTC LOG:  disconnection: session time: 0:00:00.052 user=flynn database=template1 host=100.100.85.0 port=56566
[2019-01-17T09:48:33.017301Z]    60a9c9f3-7f04-4ff6-8bf1-9783d1279633 2019-01-17 09:48:33.016 UTC LOG:  disconnection: session time: 0:00:00.540 user=flynn database=postgres host=100.100.85.0 port=56552

The cluster itself is running well, and I can export individual apps.

Any ideas what's going on here?

@titanous
Copy link
Contributor

Flynn is unmaintained and our infrastructure will shut down on June 1, 2021. See the README for details.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants