AIO frequent faults requiring containers to be restarted

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.

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.

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.

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.

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