|
Post by cdenney on Aug 3, 2022 18:44:56 GMT -8
Every sensor except the indoor temp/hum and barometric pressure (can't remember if that one is on the rack or not) has been stuck on the same values for nearly 3 hours (ignore AQI, that sensor failed a while ago). Over the past week or so, I've been getting periods like this, although usually not for all sensors, and never for this long before. Rebooting the pi does not seem to fix it. WeatherRack has been deployed for ~6 months.
|
|
|
Post by SDL on Aug 8, 2022 10:14:27 GMT -8
Can you show me the last few entries in the MySQL database table for Weather?
Than may tell me what is going on.
BP
|
|
|
Post by cdenney on Aug 10, 2022 7:51:12 GMT -8
I've attached a .csv export of the database from a more recent stuck section. This one changed the value it was stuck on a few times, so there are three different flat periods. I included some data before and after. The stuck period is between rows 15 and 74.
|
|
Sopwith
Junior Member
"If it works out of the box - what fun is that?"
Posts: 69
Raspberry Pi: Yes
Other Device: Pico Pi
|
Post by Sopwith on Aug 10, 2022 10:03:00 GMT -8
If you are willing to share your data for support purposes only, I have attached a script that will dump the WeatherData table to a csv file. There is a README.txt file in the zip archive that tells you how to run it. You do not have to post your data in this forum. Send me a private message and I will instruct you on how to get the file to me. Having all of the table data will give us a better view of what is going on. SopwithAttachments:dump_weatherdata.zip (1.37 KB)
|
|
|
Post by cdenney on Aug 10, 2022 15:53:22 GMT -8
I'm confused, is the WeatherData table not what I attached? I renamed it, but it should be an excerpt from the table of a period where the data was stuck. If you need a larger segment, I can certainly do that. Also, I doubt your script will work for me as I store the SQL database on my home server rather than the pi, so it would need at least some amount of adjustment.
|
|
|
Post by SDL on Aug 14, 2022 14:13:15 GMT -8
Thanks for the script Sopwith!
Cdenny,
It looks like you are not receiving continuous data from the WeatherRack2. Or something is not correct in your removing code. The way for us to tell the difference, is let's see what is coming in from the WeatherRack2. Find a time that the signals seem to lock and then go into the nohup.out file that is showing lots of data, including the raw data coming in from the WeatherRack2. Use your timestamp to find the matches.
Once we know that, we then know whether the issue is a connectivity issue or somewhere in the code. You can also move the WR2 to about 10m away from the SDR antenna on the Pi to test this.
BP
|
|