AIO frequent faults requiring containers to be restarted

ℹ️ Support 📦 Appliances (Docker, Snappy, VM, NCP, AIO)
1

About 4 weeks ago I installed Nextcloud AIO on Linode from their market place. It has never been stable. It stops responding within 6 hours to 5 days, requiring the containers to be restarted. The most recent errors in the admin log associated with the last stall are:

Error no app in context Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 7 no connection to the server 2023-10-18T18:55:16-0700
Error no app in context Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 7 FATAL: terminating connection due to administrator command server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. 2023-10-18T18:55:16-0700

I would really like to get this stable or I’ll need to use a different solution.

2

I have the following addons enabled:

ClamAV (Antivirus backend for Nextcloud, only supported on x64, needs ~1GB additional RAM)

Collabora (Nextcloud Office)

Nextcloud Talk (needs ports 3478/TCP and 3478/UDP open/forwarded in your firewall/router)

Nextcloud Talk Recording-server (needs Nextcloud Talk being enabled and ~1GB additional RAM and ~2 additional vCPUs)

Docker Socket Proxy (needed for Nextcloud App API)

The VM is a dedicated 4 core with 8GB of RAM. Ubuntu 22.04 LTS
Using object storage as primary storage.

Running AIO v7.4.1 as of yesterday, but the stability issues have been present since the start.

3

You could try to disable all optional containers and re-enable one by one if is is stable for a week or so to see whether it is one of them causing the issue.

4

I appreciate the response.

I have already dropped to the minimum containers I need which are, ClamAV, Collabora, Talk, and Talk Recording. I only enabled Docker Socket Proxy after updating a few days ago. Nothing has changed as far a stability.

If I turn off more containers, I don’t have the essential services I need.

5

Sure, but it would maybe help to isolate the root cause of your problems.