# Infinite loop during postgres upgrade

**URL:** <https://meta.discourse.org/t/infinite-loop-during-postgres-upgrade/91767>\
**Category:** Self-hosting\
**Created:** [July 7, 2018, 10:39am UTC](https://meta.discourse.org/t/infinite-loop-during-postgres-upgrade/91767 "2018-07-07T10:39:33Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![vulkanino](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/vulkanino/32/119654_2.png) [@vulkanino](https://meta.discourse.org/u/vulkanino)\
**Post date:** [January 12, 2021, 1:21pm UTC](https://meta.discourse.org/t/infinite-loop-during-postgres-upgrade/91767/5 "2021-01-12T13:21:11Z")

</div>

I’ve been having the same problem for many months now and I can’t upgrade my installation.

It loops and never succeeds. One problem during the `rebuild app` is this:  
`mv: cannot move '/shared/postgres_data' to '/shared/postgres_data_old': Device or resource busy`

Entering in the Docker the postgres version I have is:

```
/usr/lib/postgresql/10/bin/postgres --version
postgres (PostgreSQL) 10.14 (Debian 10.14-1.pgdg100+1)

```

These are the errors I get:

```
FAILED

--------------------

Pups::ExecError: /root/upgrade_postgres failed with return #<Process::Status: pid 47 exit 1>

Location of failure: /pups/lib/pups/exec_command.rb:112:in `spawn'

exec failed with the params "/root/upgrade_postgres"

0c74c9de4d4315b63c0ef9055631f38c0cf4b3dd0be6500fd83ca0a5b13e0d9d

**FAILED TO BOOTSTRAP** please scroll up and look for earlier error messages, there may be more than one.

./discourse-doctor may help diagnose the problem.

```

It looks like there’s a problem in the `/pups/lib/pups/exec_command.rb` script executing `spawn`.

I can start the app though  
./laucher start app

These are the files I have under `/shared`

```
total 48
drwxr-xr-x 12 root root 4096 Jan 12 13:12 .
drwxr-xr-x 57 root root 4096 Dec 15 09:09 ..
drwxr-xr-x 3 discourse www-data 4096 Aug 20 2019 backups
drwxr-xr-x 4 root root 4096 Aug 19 2019 log
drwxr-xr-x 2 postgres postgres 4096 Aug 19 2019 postgres_backup
drwx------ 20 postgres postgres 4096 Jan 12 13:14 postgres_data
drwx------ 19 postgres postgres 4096 Jan 12 13:12 postgres_data_new
drwxrwxr-x 5 postgres postgres 4096 Jan 12 13:14 postgres_run
drwxr-xr-x 2 redis redis 4096 Jan 12 13:07 redis_data
drwxr-xr-x 4 root root 4096 Aug 19 2019 state
drwxr-xr-x 4 discourse www-data 4096 Jan 12 13:14 tmp
drwxr-xr-x 4 discourse www-data 4096 Sep 8 2019 uploads

```

What can I do?

---

_[View the full topic](https://meta.discourse.org/t/infinite-loop-during-postgres-upgrade/91767)._