wsum and sumtime are different after upgrading to 4.1.1

42 views
Skip to first unread message

David Geiger

unread,
Aug 19, 2020, 8:57:12 PM8/19/20
to weewx-user
I have been a long time user of weewx, great software!

I recently updated from 3.9.2 to 4.1.1. After the update, I noticed that my average yearly outTemp was different. I took a look in the database and noticed that after the upgrade, my wsum and sumtime are a factor of 300 times greater than before the upgrade. Before, sumtime = 288 each day, after the upgrade it = 86400 each day. I noticed it in the archive_day_outTemp table. The average for the day is still correct, but when you run for a span that includes 3.9.2 and 4.1.1, the 4.1.1 far out weighs the 3.9.2.

I have my archive interval set to 300. It was not changed between 3.9.2 and 4.1.1

Tom Keffer

unread,
Aug 20, 2020, 8:03:01 AM8/20/20
to weewx-user
Daily summaries created by versions earlier than v3.7.0 did not weight the sums with the length archive interval. See issue #61. Summaries created by v3.7.0 or later, do weight the sums. You can tell the difference  between the two types of summaries by examining some metadata. 

echo "select value from archive_day__metadata where name='Version'" | sqlite3 weewx.sdb

The intention is that the daily summaries are either one or the other: the sums are either not weighted (version=1), or they are weighted (version=2). I don't know why your database would be a little of each. It should not be.

This can all be fixed by dropping, then rebuilding, the daily summaries. The utility wee_database can do this.

-tk

--
You received this message because you are subscribed to the Google Groups "weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/b9f624ae-fcb7-40ab-bada-263a3d665300n%40googlegroups.com.

David Geiger

unread,
Aug 20, 2020, 2:37:26 PM8/20/20
to weewx-user
That fixed it, thank you!
Reply all
Reply to author
Forward
0 new messages