So, I found an issue with archive.js and see where it was adding a duplicate record for each Hub and Device on startup.
I have added indexes to prevent duplicate record and I store any duplicate record in a table. I will run this for 24 hours and see if I in-fact capture any duplicates.
It may very well be a different issue. The errors I found caused duplicates i DeviceStatus and HubStatus.
I suggest you download create-database-tables.js and archive.js.
Archive or use create-database-tables.js to create a NEW database. Then modify archive.js to use the new database. We are almost done with testing this thing so I’ll start adding a configuration file to make this easier.
If you create a new database, you will need to modify daily-stats.js.
Gary, thanks for sharing that. I am going to try installing this on an Odroid HC1, it’s like a raspberry pi but with a built in sata dock for a 2.5" drive. I’ll post later how it goes.
Hello Gary, thank you very much for the tool. I’ve installed it … learning a bit about RPi and maria SQL along the way. I’ve gots data, and am able to query it, however I’m getting an error every 10 min like
2018-07-13 15:35:23 Error in insertHubStatus
The table is there in the database and most other tables are being updated with data,
but there’s nothing in HubEvents. So:
MariaDB [weatherflow]> select * from HubEvents;
/gives me/ Empty set (0.00 sec)
I’d appreciate any clues you can quickly suggest of where I might start looking.
Thanks. Wayne
Everything working well since last evening with WFArchiver. Having a new set of issues with a field test Hub and, as usual, I can query the WFArchiver data to pull out the diagnostic info I am looking for. A great tool, thanks!
I had to develop a method to keep track of firmware updates. I consider this an important bit of information to know especially if an issue arises after the update.
I’ve had several people ask me about adding notifications. If the application did send notifications what do you want to know and how do you want to be notified?
Interesting idea, but I worry about how much user support work that makes for you. Maybe in WfArchiver-Pro
My own interest is more about things that have stopped happening rather than things that have started happening. But I could see someone wanting temperature or precip notification that could be used to turn on or off devices like heaters, etc.
I’m thinking more on the lines of non-weather related items.
Battery voltage low.
Battery replacement now.
No data received from a module after X minutes.
Loss of UDP data from hub.
Sensor failure after x consecutive times.
Firmware updated.