Here is what I did and it worked for me :)
michael.k...@gmx.at schrieb am Samstag, 28. November 2020 um 10:38:28 UTC+1:
>
> 1606431600 -2.9 1606461229 6.5 1606483508 90.7493145743143 287
> 90.7493145743143 287
> 1606345200 -1.4 1606376580 5.8 1606396159 208.754783549784 288
> 208.754783549784 288
> 1606258800 -2.5 1606290557 5.3 1606310759 71.2823196248196 288
> 71.2823196248196 288
> 1606172400 -2.1 1606194900 9.9 1606224600 752.777460317461 286
> 752.777460317461 286
> 1606086000 0.29997 1606171800 7.6 1606136074 951.861259018759 288
> 951.861259018759 288
> 1605999600 -0.1001 1606073204 10.2 1606050999 884.716731601731 288
> 884.716731601731 288
> 1605913200 -1.6 1605940146 7.7 1605966081 442.098484848485 288
> 442.098484848485 288
> 1605826800 0.29997 1605913105 6.2 1605872440 1254.14992424242 287
> 1254.14992424242 287
> 1605740400 4.7 1605740431 13.9 1605793485 2373.86111111111 288
> 2373.86111111111 288
> 1605654000 3.1 1605733623 16.0 1605706154 2105.63747835498 288
> 2105.63747835498 288
> 1605567600 4.8 1605652944 13.6 1605615932 2268.75462121212 288
> 2268.75462121212 288
> 1605481200 1.4 1605493171 8.9 1605535929 1811.52088383838 288
> 1811.52088383838 288
> *1605394800 2.1 1605473931 16.1 1605445486 2346.52735930736 288
> 2346.52735930736 288*
> *1605308400 5.5 1605328978 17.3 1605360608 2590.47363636364 288
> 650228.309292929 69058*
> *1605222000 4.0 1605238302 14.9 1605272440 2255.38090909091 288
> 676614.272727273 86400*
> 1605135600 2.7 1605160230 12.0 1605186834 1942.27053030303 288
> 582681.159090909 86400
> 1605049200 3.5 1605078802 11.3 1605095884 1937.71213564214 285
> 581313.640692641 85500
> 1604962800 1.2 1604988775 9.4 1605013839 1337.86883477633 287
> 401360.650466329 86100
> 1604876400 -0.1001 1604903428 9.3 1604925619 1065.95282828283 288
> 319785.848484848 86400
>
> So I guess if you just set sumtime = count and wsum = sum for all
> archive_day tables it should work?
> michael.k...@gmx.at schrieb am Samstag, 28. November 2020 um 09:27:44
> UTC+1:
>
>>
>> I am observing the same situation, as well as other WeeWX users near me.
>> The average is clearly off since the 4.2.0 update. It also affects yearly
>> average since then. So I guess this is something that happened with the
>> 4.2.0 Version. I don't want to rebuild my daily values, how to find the bad
>> values and correct them? Probably in the archive_daily table of the day I
>> made the update?
>>
>> I found something: It's a change with "sum":
>> 1-13 has "new" sumtime, 14 a mix (the day I updated) and old sumtime are
>> 15 and and older:
>>
>> Isn't there a config that sets how this is calculated?
>>
>>
>> b.cl...@gmail.com schrieb am Donnerstag, 19. November 2020 um 19:43:57
>> UTC+1:
>>
>>> Yeah, everything looks great again.
>>> Thank you Tom for that excellent support.
>>> Greetings from Suedlohn (Germany).
>>> Berny
>>>
>>> tke...@gmail.com schrieb am Donnerstag, 19. November 2020 um 17:56:56
>>> UTC+1:
>>>
>>>> So, for some reason, the weighted sum (field 'wsum') has too high a
>>>> value, or the sum of observation time (field 'sumtime') has too low a
>>>> value.
>>>>
>>>> The easiest fix is to just rebuild the daily summaries using the
>>>> wee_database
>>>> utility <http://www.weewx.com/docs/utilities.htm#wee_database_utility>.
>>>>
>>>> Stop weewxd. then,
>>>>
>>>> *wee_database --drop-daily*
>>>> *wee_database --rebuild-daily*
>>>>
>>>> Restart weewxd
>>>>
>>>> For a database of your size, it shouldn't take more than a minute or
>>>> two.
>>>>
>>>> It could take some time for the NOAA and html files to get corrected.
>>>> You can speed things up by deleting them and allowing weewx to regenerate
>>>> them.
>>>>
>>>> -tk
>>>>
>>>>
>>>>
>>>> On Thu, Nov 19, 2020 at 8:48 AM Berny Cl <b.cl...@gmail.com> wrote:
>>>>
>>>>> sqlite> select sum(wsum)/sum(sumtime) from archive_day_outTemp where
>>>>> strftime("%Y-%m",dateTime,'unixepoch','localtime')=='2020-11';
>>>>> 60.1308595259353
>>>>>
>>>>> Ok, that looks the same like the value in my history table.
>>>>>
>>>>> tke...@gmail.com schrieb am Donnerstag, 19. November 2020 um 17:13:38
>>>>> UTC+1:
>>>>>
>>>>>> 1. That looks reasonable. One other query to try:
>>>>>>
>>>>>> sqlite> *select sum(wsum)/sum(sumtime) from archive_day_outTemp
>>>>>> where strftime("%Y-%m",dateTime,'unixepoch','localtime')=='2020-11';*
>>>>>>
>>>>>> 2. If that doesn't reveal anything, I will send you an instrumented
>>>>>> version of xtypes.py that will log the calculation.
>>>>>>
>>>>>>
>>>>>> On Thu, Nov 19, 2020 at 6:44 AM Berny Cl <b.cl...@gmail.com> wrote:
>>>>>>
>>>>>>> sqlite> select avg(outTemp) from archive where strftime("%Y-%m",
>>>>>>> dateTime,'unixepoch','localtime')=='2020-11';
>>>>>>> 51.117818676717 <(781)%20867-6717>
>>>>>>> sqlite> select sum(sum)/sum(count) from archive_day_outTemp where
>>>>>>> strftime("%Y-%m",dateTime,'unixepoch','localtime')=='2020-11';
>>>>>>> 51.114923603352
>>>>>>>
>>>>>>> Thank you!
>>>>>>> OK, I did that. The two numbers are very close. I think they are
>>>>>>> correct (in Fahrenheit) but in my history table the temperature ist too
>>>>>>> high (in degree Celsius).
>>>>>>>
>>>>>>> tke...@gmail.com schrieb am Donnerstag, 19. November 2020 um
>>>>>>> 15:02:55 UTC+1:
>>>>>>>
>>>>>>>> Most likely it's some bad data. Let's check the database directly.
>>>>>>>>
>>>>>>>> First find the database. If you did a package install, it's most
>>>>>>>> likely at /var/lib/weewx/weewx.sdb. If you did a setup.py install,
>>>>>>>> it's at
>>>>>>>> /home/weewx/archive/weewx.sdb. Let's assume the former.
>>>>>>>>
>>>>>>>> Then, run two queries:
>>>>>>>>
>>>>>>>> *sqlite /var/lib/weewx/weewx.sdb*
>>>>>>>> sqlite> *select avg(outTemp) from archive where strftime("%Y-%m",
>>>>>>>> dateTime,'unixepoch','localtime')=='2020-11';*
>>>>>>>> sqlite> *select sum(sum)/sum(count) from archive_day_outTemp where
>>>>>>>> strftime("%Y-%m",dateTime,'unixepoch','localtime')=='2020-11';*
>>>>>>>>
>>>>>>>> The first method calculates the average temperature for Nov 2020 by
>>>>>>>> using the main archive table. The second by using the daily summaries.
>>>>>>>> The
>>>>>>>> two numbers should be very close. See what you get and we'll take it
>>>>>>>> from
>>>>>>>> there.
>>>>>>>>
>>>>>>>> -tk
>>>>>>>>
>>>>>>>>
>>>>>>>> On Thu, Nov 19, 2020 at 4:43 AM Berny Cl <b.cl...@gmail.com> wrote:
>>>>>>>>
>>>>>>>>> Hi everybody,
>>>>>>>>> since the last update to version 4.20, i have noticed an incorrect
>>>>>>>>> value for the monthly average temperature at the history table and
>>>>>>>>> also in
>>>>>>>>> the monthly NOAA table.
>>>>>>>>> I use the niculskin and my station is a FineOffset (WS 1080).
>>>>>>>>>
>>>>>>>>> See at: http://haus-volmering.de/history.html
>>>>>>>>> (Durchschnittstemperatur = Average Temperature for Nov is
>>>>>>>>> obviously incorrect)
>>>>>>>>>
>>>>>>>>> How can I fix that?
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> 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/277ec811-21b4-41e9-8fc1-cda38d87014dn%40googlegroups.com
>>>>>>>>>
>>>>>>>>> <https://groups.google.com/d/msgid/weewx-user/277ec811-21b4-41e9-8fc1-cda38d87014dn%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>>>>>>> .
>>>>>>>>>
>>>>>>>> --
>>>>>>> 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/87243ab4-47a4-4c85-b004-530f84e77673n%40googlegroups.com
>>>>>>>
>>>>>>> <https://groups.google.com/d/msgid/weewx-user/87243ab4-47a4-4c85-b004-530f84e77673n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>>>>> .
>>>>>>>
>>>>>> --
>>>>> 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/f5a4768c-27f7-49c6-807e-496296d0c380n%40googlegroups.com
>>>>>
>>>>> <https://groups.google.com/d/msgid/weewx-user/f5a4768c-27f7-49c6-807e-496296d0c380n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>>> .
>>>>>
>>>>
--
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/b370f95c-e31b-47fa-aede-c74019e67e43n%40googlegroups.com.
--Show all tables that contain relevant archive_day values
SELECT name FROM sqlite_master
WHERE type IN ('table','view')
AND name NOT LIKE 'sqlite_%'
AND name NOT LIKE 'archive'
AND name NOT LIKE 'archive_day__metadata'
ORDER BY 1;
--may vary
update archive_day_ET set wsum=sum, sumtime=count;
update archive_day_UV set wsum=sum, sumtime=count;
update archive_day_altimeter set wsum=sum, sumtime=count;
update archive_day_appTemp set wsum=sum, sumtime=count;
update archive_day_appTemp1 set wsum=sum, sumtime=count;
update archive_day_barometer set wsum=sum, sumtime=count;
update archive_day_batteryStatus1 set wsum=sum, sumtime=count;
update archive_day_batteryStatus2 set wsum=sum, sumtime=count;
update archive_day_batteryStatus3 set wsum=sum, sumtime=count;
update archive_day_batteryStatus4 set wsum=sum, sumtime=count;
update archive_day_batteryStatus5 set wsum=sum, sumtime=count;
update archive_day_batteryStatus6 set wsum=sum, sumtime=count;
update archive_day_batteryStatus7 set wsum=sum, sumtime=count;
update archive_day_batteryStatus8 set wsum=sum, sumtime=count;
update archive_day_cloudbase set wsum=sum, sumtime=count;
update archive_day_co set wsum=sum, sumtime=count;
update archive_day_co2 set wsum=sum, sumtime=count;
update archive_day_consBatteryVoltage set wsum=sum, sumtime=count;
update archive_day_dewpoint set wsum=sum, sumtime=count;
update archive_day_dewpoint1 set wsum=sum, sumtime=count;
update archive_day_extraHumid1 set wsum=sum, sumtime=count;
update archive_day_extraHumid2 set wsum=sum, sumtime=count;
update archive_day_extraHumid3 set wsum=sum, sumtime=count;
update archive_day_extraHumid4 set wsum=sum, sumtime=count;
update archive_day_extraHumid5 set wsum=sum, sumtime=count;
update archive_day_extraHumid6 set wsum=sum, sumtime=count;
update archive_day_extraHumid7 set wsum=sum, sumtime=count;
update archive_day_extraHumid8 set wsum=sum, sumtime=count;
update archive_day_extraTemp1 set wsum=sum, sumtime=count;
update archive_day_extraTemp2 set wsum=sum, sumtime=count;
update archive_day_extraTemp3 set wsum=sum, sumtime=count;
update archive_day_extraTemp4 set wsum=sum, sumtime=count;
update archive_day_extraTemp5 set wsum=sum, sumtime=count;
update archive_day_extraTemp6 set wsum=sum, sumtime=count;
update archive_day_extraTemp7 set wsum=sum, sumtime=count;
update archive_day_extraTemp8 set wsum=sum, sumtime=count;
update archive_day_forecast set wsum=sum, sumtime=count;
update archive_day_hail set wsum=sum, sumtime=count;
update archive_day_hailBatteryStatus set wsum=sum, sumtime=count;
update archive_day_hailRate set wsum=sum, sumtime=count;
update archive_day_heatindex set wsum=sum, sumtime=count;
update archive_day_heatindex1 set wsum=sum, sumtime=count;
update archive_day_heatingTemp set wsum=sum, sumtime=count;
update archive_day_heatingVoltage set wsum=sum, sumtime=count;
update archive_day_humidex set wsum=sum, sumtime=count;
update archive_day_humidex1 set wsum=sum, sumtime=count;
update archive_day_inDewpoint set wsum=sum, sumtime=count;
update archive_day_inHumidity set wsum=sum, sumtime=count;
update archive_day_inTemp set wsum=sum, sumtime=count;
update archive_day_inTempBatteryStatus set wsum=sum, sumtime=count;
update archive_day_leafTemp1 set wsum=sum, sumtime=count;
update archive_day_leafTemp2 set wsum=sum, sumtime=count;
update archive_day_leafWet1 set wsum=sum, sumtime=count;
update archive_day_leafWet2 set wsum=sum, sumtime=count;
update archive_day_lightning_distance set wsum=sum, sumtime=count;
update archive_day_lightning_disturber_count set wsum=sum, sumtime=count;
update archive_day_lightning_energy set wsum=sum, sumtime=count;
update archive_day_lightning_noise_count set wsum=sum, sumtime=count;
update archive_day_lightning_strike_count set wsum=sum, sumtime=count;
update archive_day_luminosity set wsum=sum, sumtime=count;
update archive_day_maxSolarRad set wsum=sum, sumtime=count;
update archive_day_nh3 set wsum=sum, sumtime=count;
update archive_day_no2 set wsum=sum, sumtime=count;
update archive_day_noise set wsum=sum, sumtime=count;
update archive_day_o3 set wsum=sum, sumtime=count;
update archive_day_outHumidity set wsum=sum, sumtime=count;
update archive_day_outTemp set wsum=sum, sumtime=count;
update archive_day_outTempBatteryStatus set wsum=sum, sumtime=count;
update archive_day_pb set wsum=sum, sumtime=count;
update archive_day_pm10_0 set wsum=sum, sumtime=count;
update archive_day_pm1_0 set wsum=sum, sumtime=count;
update archive_day_pm2_5 set wsum=sum, sumtime=count;
update archive_day_pressure set wsum=sum, sumtime=count;
update archive_day_radiation set wsum=sum, sumtime=count;
update archive_day_rain set wsum=sum, sumtime=count;
update archive_day_rainBatteryStatus set wsum=sum, sumtime=count;
update archive_day_rainRate set wsum=sum, sumtime=count;
update archive_day_referenceVoltage set wsum=sum, sumtime=count;
update archive_day_rxCheckPercent set wsum=sum, sumtime=count;
update archive_day_signal1 set wsum=sum, sumtime=count;
update archive_day_signal2 set wsum=sum, sumtime=count;
update archive_day_signal3 set wsum=sum, sumtime=count;
update archive_day_signal4 set wsum=sum, sumtime=count;
update archive_day_signal5 set wsum=sum, sumtime=count;
update archive_day_signal6 set wsum=sum, sumtime=count;
update archive_day_signal7 set wsum=sum, sumtime=count;
update archive_day_signal8 set wsum=sum, sumtime=count;
update archive_day_snow set wsum=sum, sumtime=count;
update archive_day_snowBatteryStatus set wsum=sum, sumtime=count;
update archive_day_snowDepth set wsum=sum, sumtime=count;
update archive_day_snowMoisture set wsum=sum, sumtime=count;
update archive_day_snowRate set wsum=sum, sumtime=count;
update archive_day_so2 set wsum=sum, sumtime=count;
update archive_day_soilMoist1 set wsum=sum, sumtime=count;
update archive_day_soilMoist2 set wsum=sum, sumtime=count;
update archive_day_soilMoist3 set wsum=sum, sumtime=count;
update archive_day_soilMoist4 set wsum=sum, sumtime=count;
update archive_day_soilTemp1 set wsum=sum, sumtime=count;
update archive_day_soilTemp2 set wsum=sum, sumtime=count;
update archive_day_soilTemp3 set wsum=sum, sumtime=count;
update archive_day_soilTemp4 set wsum=sum, sumtime=count;
update archive_day_supplyVoltage set wsum=sum, sumtime=count;
update archive_day_txBatteryStatus set wsum=sum, sumtime=count;
update archive_day_uvBatteryStatus set wsum=sum, sumtime=count;
update archive_day_wind set wsum=sum, sumtime=count;
update archive_day_windBatteryStatus set wsum=sum, sumtime=count;
update archive_day_windDir set wsum=sum, sumtime=count;
update archive_day_windGust set wsum=sum, sumtime=count;
update archive_day_windGustDir set wsum=sum, sumtime=count;
update archive_day_windSpeed set wsum=sum, sumtime=count;
update archive_day_windchill set wsum=sum, sumtime=count;
update archive_day_windrun set wsum=sum, sumtime=count;
