Domoticz.db bad once again

Moderator: leecollings

Post Reply
Domange
Posts: 6
Joined: Wednesday 16 March 2016 14:53
Target OS: Linux
Domoticz version:
Contact:

Domoticz.db bad once again

Post by Domange »

Hello,

I use Domoticz with some scripts.
Sometimes, one of my scripts seems to have trouble and modify something in the database, and Domoticz crashes with this message
WebServer PO exception occurred : 'stoull'
How to debug this ?
I don't know where is the problem in the database.
I explore the database with DB Browser for sqlite I can see a nan instead of a valid value, I change it but domoticz still crashes.
I remove all the history for this device but nothing changes...

How to trace the different request to identify the bad one ?

I rebuild my configuration for the 4th or 5th time and I don't see how to identify the problem.

Thank you for your help....
Runs fine on ODroid N2 4Gb Ubuntu 18.04 LTS except V2020.1
User avatar
waaren
Posts: 6028
Joined: Tuesday 03 January 2017 14:18
Target OS: Linux
Domoticz version: Beta
Location: Netherlands
Contact:

Re: Domoticz.db bad once again

Post by waaren »

Domange wrote: Friday 03 January 2020 16:35 Sometimes, one of my scripts seems to have trouble and modify something in the database, and Domoticz crashes with this message
I don't know where is the problem in the database.
Have a look at these topics. First one is a dzVents script giving an alert when there could be a database problem. Second one show some approaches to fix a malformed database.

https://www.domoticz.com/forum/viewtopi ... 72&t=26692
https://www.domoticz.com/forum/viewtopi ... 28&t=10984
Debian buster, bullseye on RPI-4, Intel NUC.
dz Beta, Z-Wave, RFLink, RFXtrx433e, P1, Youless, Hue, Yeelight, Xiaomi, MQTT
==>> dzVents wiki
Domange
Posts: 6
Joined: Wednesday 16 March 2016 14:53
Target OS: Linux
Domoticz version:
Contact:

Re: Domoticz.db bad once again

Post by Domange »

Thank you very for your answer.

I don't yet know the dvVents scripts. It's very usefull.

And the database test might help me to solve my issue.
Runs fine on ODroid N2 4Gb Ubuntu 18.04 LTS except V2020.1
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest