Homeassistant can not read MQTT, other clients can.mosquitto.db corrupt?

Configuration
1

Hi

I have one backend with MQTT-broker and a lot of clients:

backend:

  • RPI-87:
    • RaspberryPi 4, running homeassistant on docker
    • add-on: Mosquitto broker V5.1

frontend(s)

  • RPI-82, homeassistant in docker connected to backend
  • RPI-83, homeassistant in docker connected to backend
  • RPI-86, homeassistant in docker connected to backend
  • DEB-17, homeassistant in docker connected to backend
  • MQTT-explorer
  • node-red
  • …

As you can see: a lot of clients connected to the same MQTT broker.

Yesterday, it is the second time that

  • the homeassistant clients can connect to broker (I can see incomming connections in the log of my broker)
  • the homeassistant clients can not see the devices (defined on the mqtt-broker) anymore
  • the other clients (MQTT-Assistant, node-red, CLI mosquitto_sub, etc… still can connect to MQTT-broker and see messages published by the devices.

So my solution now:

  • stop MQTT broker
  • delete mosquitto.db on /usr/share/hassio/addons/data/core_mosquitto/mosquitto.db
  • restart MQTT broker
  • restart the devices that produce the mqtt messages (in my case: zigbee2mqtt, ems-esp, …)

The first time, I thought this was a hickup, however, it is the second time now in a timespan of +/- 1 month.

Anybody experiences the same problems?
Is there a solution for this?

kind regards,
Bart