Post by berne on Nov 9, 2021 13:07:25 GMT -8
Hi Doc, Because I am fundamentally a lazy person (retired), do you have or know of any code that will reboot the RPi when obvious SQL data errors start occurring?
For some reason, this morning at about 5:30 AM, I started getting a constant Temperature reading from both the outdoor and indoor sensors. This propagated until I realized something was wrong (39F on a 72 F day). A RPi reboot solved the issue at least for now. It seems like I might have to write some code to look for repeating T measurements (maybe 3 or 4) in the SQL database, which then triggers a reboot. I have crontab running my CO2 sensor on reboot (just writing to a CSV file, not your SQL DB yet) and also notifying me via e-mail when it does so, so that would also be a nice feature.
thx, Berne
For some reason, this morning at about 5:30 AM, I started getting a constant Temperature reading from both the outdoor and indoor sensors. This propagated until I realized something was wrong (39F on a 72 F day). A RPi reboot solved the issue at least for now. It seems like I might have to write some code to look for repeating T measurements (maybe 3 or 4) in the SQL database, which then triggers a reboot. I have crontab running my CO2 sensor on reboot (just writing to a CSV file, not your SQL DB yet) and also notifying me via e-mail when it does so, so that would also be a nice feature.
thx, Berne
