Connection with Mosquitto is lost very often

Third party integrations
,
1

Since a couple of days, could be since latest 0.117.5 update, Home Assistant loses the MQTT connection to Mosquitto. Restart of Mosquitto add-on solves it, but after some time (30 minutes) it happens again.
Very annoying because I have a lot of zigbee2mqtt devices that become unavailable then.

Mosquitto broker always show this error in the log, which is quite useless:

1605090136: Saving in-memory database to /data/mosquitto.db.
1605090137: Error: No error information.

Home Assistant log shows this:

Logger: homeassistant.components.mqtt
Source: components/mqtt/__init__.py:1015 
Integration: MQTT ([documentation](https://www.home-assistant.io/integrations/mqtt), [issues](https://github.com/home-assistant/home-assistant/issues?q=is%3Aissue+is%3Aopen+label%3A%22integration%3A+mqtt%22)) 
First occurred: 10:50:38 (2 occurrences) 
Last logged: 11:22:21

Disconnected from MQTT server 192.168.178.51:1883 (1)

I reinstalled the Mosquitto broker addon a couple of times, but that also does not solve it.

Do others also experience this?

2

I think I solved it. The persistent database file /data/mosquitto.db was probably corrupt. Moved that folder and reinstalled Mosquitto Broker addon. And now that file and folder have been freshly rebuild. Seems that my SD card is slowly dying, time for a new project to get HA booted from harddisk or ssd.

Meanwhile also learned how useful the Portainer add-on is to get into the docker command line environments of addons and supervisor.