how to check database file ?

[Dave21w]

How do I check my domoticz.db to find out if it has errors / corrupt
Domoticz will start but almost instantly seems to crash, a fresh install is fine but as soon as I import my old db it fails again, it has been working fine, the problems seem to have started since updating zigbee2mqtt. I can install a much older database (12 months plus) but this is missing a lot of devices.

TIA
Dave

PS. Raspberry Pi 3B+ running Buster from external SSD not an SD Card.

[waltervl]

For database check see the Troubleshooting Wiki https://www.domoticz.com/wiki/Troubleshooting

but immediate crash could also be related to using python plugins on a Raspberry Pi with Bullseye OS. Did you also update your RPi OS?

[meal]

Hello,

To check the integrity of domoticz.db (running on RPI) I perform the following steps

1 - stop domoticz service
sudo service domoticz stop

2 - copy domoticz db to my local computer using FileZilla

3 - restart domoticz
sudo service domoticz start

4 - check the integrity of domoticz.db using DB Browser (SQL Lite)
Open the db
then select menu
Tools/integrity check

BR