Solved Nextcloud not responding and will not update

[privsec]

I am getting the following when I try to restart, update, or backup my nextcloud instance

Jul 12 06:18:53 box:settings initCache: pre-load settings   
Jul 12 06:18:53 box:taskworker Starting task 1999. Logs are at /home/yellowtent/platformdata/logs/APP_ID/apptask.log
Jul 12 06:18:53 box:tasks 1999: {"percent":2,"error":null}
Jul 12 06:18:53 box:apptask cloud.website_address.com startTask installationState: pending_update runState: running
Jul 12 06:18:53 box:apptask cloud.website_address.com Updating to 4.9.1-1
Jul 12 06:18:53 box:tasks 1999: {"percent":5,"message":"Verify manifest"}
Jul 12 06:18:53 box:tasks 1999: {"percent":15,"message":"Backing up app"}
Jul 12 06:18:53 box:backups backupApp - Backing up cloud.website_address.com with tag 2021-07-12-061853-750
Jul 12 06:18:53 box:tasks 1999: {"percent":15,"message":"Backup - Snapshotting app cloud.website_address.com"}
Jul 12 06:18:53 box:services cloud.website_address.com backupAddons
Jul 12 06:18:53 box:services cloud.website_address.com backupAddons: Backing up ["postgresql","sendmail","ldap","redis","localstorage","scheduler","turn"]
Jul 12 06:18:53 box:services cloud.website_address.com Backing up postgresql
Jul 12 06:18:53 box:apptask cloud.website_address.com update aborted because backup failed BoxError: Unexpected response code when piping https://IP_ADDRESS:3000/databases/DB_STRING/backup?access_token=SOME_LONG_STRING: 500 message: Internal Server Error filename: /home/yellowtent/appsdata/APP_ID/postgresqldump
at /home/yellowtent/box/src/backups.js:1072:36
at wrapper (/home/yellowtent/box/node_modules/async/dist/async.js:268:20)
at iterateeCallback (/home/yellowtent/box/node_modules/async/dist/async.js:413:21)
at /home/yellowtent/box/node_modules/async/dist/async.js:321:20
at /home/yellowtent/box/src/services.js:1301:9
at f (/home/yellowtent/box/node_modules/once/once.js:25:25)
at Request.<anonymous> (/home/yellowtent/box/src/services.js:1312:53)
at Request.emit (events.js:315:20)
at Request.onRequestResponse (/home/yellowtent/box/node_modules/request/request.js:1059:10)
at ClientRequest.emit (events.js:315:20) {
reason: 'External Error',
details: {},
backupError: true
Jul 12 06:18:53 box:apptask cloud.website_address.com updating app with values: {"installationState":"installed","error":null,"health":null}
Jul 12 06:18:53 box:taskworker Task took 0.103 seconds
Jul 12 06:18:53 box:tasks setCompleted - 1999: {"result":null,"error":{"stack":"BoxError: Unexpected response code when piping https://IP_ADDRESS:3000/databases/DB_STRING/backup?access_token=SOME_LONG_STRING: 500 message: Internal Server Error filename: /home/yellowtent/appsdata/APP_ID/postgresqldump\n at /home/yellowtent/box/src/backups.js:1072:36\n at wrapper (/home/yellowtent/box/node_modules/async/dist/async.js:268:20)\n at iterateeCallback (/home/yellowtent/box/node_modules/async/dist/async.js:413:21)\n at /home/yellowtent/box/node_modules/async/dist/async.js:321:20\n at /home/yellowtent/box/src/services.js:1301:9\n at f (/home/yellowtent/box/node_modules/once/once.js:25:25)\n at Request.<anonymous> (/home/yellowtent/box/src/services.js:1312:53)\n at Request.emit (events.js:315:20)\n at Request.onRequestResponse (/home/yellowtent/box/node_modules/request/request.js:1059:10)\n at ClientRequest.emit (events.js:315:20)","name":"BoxError","reason":"External Error","details":{},"message":"Unexpected response code when piping https://IP_ADDRESS:3000/databases/DB_STRING/backup?access_token=SOME_LONG_STRING: 500 message: Internal Server Error filename: /home/yellowtent/appsdata/APP_ID/postgresqldump","backupError":true}}
Jul 12 06:18:53 box:tasks 1999: {"percent":100,"result":null,"error":{"stack":"BoxError: Unexpected response code when piping https://IP_ADDRESS:3000/databases/DB_STRING/backup?access_token=SOME_LONG_STRING: 500 message: Internal Server Error filename: /home/yellowtent/appsdata/APP_ID/postgresqldump\n at /home/yellowtent/box/src/backups.js:1072:36\n at wrapper (/home/yellowtent/box/node_modules/async/dist/async.js:268:20)\n at iterateeCallback (/home/yellowtent/box/node_modules/async/dist/async.js:413:21)\n at /home/yellowtent/box/node_modules/async/dist/async.js:321:20\n at /home/yellowtent/box/src/services.js:1301:9\n at f (/home/yellowtent/box/node_modules/once/once.js:25:25)\n at Request.<anonymous> (/home/yellowtent/box/src/services.js:1312:53)\n at Request.emit (events.js:315:20)\n at Request.onRequestResponse (/home/yellowtent/box/node_modules/request/request.js:1059:10)\n at ClientRequest.emit (events.js:315:20)","name":"BoxError","reason":"External Error","details":{},"message":"Unexpected response code when piping https://IP_ADDRESS:3000/databases/DB_STRING/backup?access_token=SOME_LONG_STRING: 500 message: Internal Server Error filename: /home/yellowtent/appsdata/APP_ID/postgresqldump","backupError":true}}

[privsec]

When I try to install a new nextcloud app, I get
Addons Error: Error tearing down postgresql. Status code: 500 message: sorry, too many clients already

[girish]

@privsec that bug is fixed in Cloudron 6.3. Before you update, what you can do is: go to Services -> Postgresql -> Restart. Then please retry the update of nextcloud. After nextcloud update succeeds, please update to Cloudron 6.3 which should fix the problem for good.

[privsec]

@girish said in Nextcloud not responding and will not update:

@privsec that bug is fixed in Cloudron 6.3. Before you update, what you can do is: go to Services -> Postgresql -> Restart. Then please retry the update of nextcloud. After nextcloud update succeeds, please update to Cloudron 6.3 which should fix the problem for good.

Trying that now

[privsec]

@privsec That worked, thanks!