With 4.10.2 wee_database ist the tool. Run wee_database --rebuild-daily --date=YYYY-mm-dd where YYYY-mm-dd is whatever local date 1745362800 translates to (my best guess 2025-04-23). Then delete the NOAA file for April 2025. You may need a "sudo" before the command.
If such values are not a repeating pattern, you should be done. JohnP schrieb am Mittwoch, 10. Dezember 2025 um 10:46:46 UTC+1: > Thank you Michael - that was the tip I needed. > > I did already try searching in inches, to no avail - but as you say, I was > looking in the wrong table entirely. > > The offending row is attached. Epoch time 1745362800, which equates to the > correct end of day with my DST offset. > > There are 3 values in the row: > > max - I guess this is the max per daily 5 minute segment (though obviously > unrealistic given the contents of the other table all being zero) > sum - This is the value in inches which converts neatly to 19.79cm > wsum - not sure what this relates to as it doesn't look like a sum of > anything, nor does it look like a metric view of the imperial values (too > big). > > I'm thinking, based on looking at adjacent rows, that I should zero out > all of these fields - is that what you'd recommend? > > > From etc/weewx/weewx.conf, it looks like I am on version 4.10.2 - so > weectl is the right tool. > > What would you suggest I rebuild? Should I delete the NOAA report for > April 2025 also to have that regenerated? > > Thank you again for all the pointers, > > John > > > > > > > > > > On Wednesday, 10 December 2025 at 04:17:44 UTC [email protected] wrote: > > There are several reasons why you mayy not find a 19.79 value in the > database: > > - You are searching the wrong table: you won't find the highest daily > rainfall in the archive table. (Unless all the rain was recorded in a > single interval). Look for the table archive_day_rain and in there you > should find a row with that value (in which unit it may be, I don't know) > - Units: the database doesn't necessarily contain metric values. > Especially if you haven't actively changed the default unit_system for the > database. So the value you are looking for might be stored in inch > > A complete rebuild of your whole history might not be necessary, if such > values aren't a repeating pattern. Which version are you on? wee_database > is from before v5.0. So if you are on a newer version you should use weectl > database - and refer to the docs for the version you use. > > JohnP schrieb am Dienstag, 9. Dezember 2025 um 22:04:09 UTC+1: > > Hi, > > I'm hoping for some pointers to eradicate an erroneous 'Highest Daily > Rainfall' value (see attached image). > > I have 19.79cm of rain registered on 22/April/2025 - a day where there was > no rain at all. > > I've tried to follow some of the steps from other threads, querying the > database for erroneous looking data both from the CLI and by searching with > DB Browser, however I conclude that I am probably looking for the wrong > value in the wrong place! > > Here's what I returned from the database: > > sqlite> select > datetime(dateTime,'unixepoch','localtime'),dateTime,rain,rainRate from > archive where dateTime > 1745276400 and dateTime <= 1745366400; > > 2025-04-22 00:05:00|1745276700|0.0|0.0 > > 2025-04-22 00:10:00|1745277000|0.0|0.0 > > 2025-04-22 00:15:00|1745277300|0.0|0.0 > > <---snip - all zero data for every 5 minute interval ---> > > 2025-04-23 00:45:00|1745365500|0.0|0.0 > > 2025-04-23 00:50:00|1745365800|0.0|0.0 > > 2025-04-23 00:55:00|1745366100|0.0|0.0 > > 2025-04-23 01:00:00|1745366400|0.0|0.0 > > I can't find a '19.79' in the database (or 1978 in case of a round up), > and the sum of the values above would clearly be zero. > > I looked at this post: > https://groups.google.com/g/weewx-user/c/pQohXWFsEjk > > Which talks about dropping the daily database and rebuilding it - however > /etc/weewx/scripts/wee_database (and all scripts in that folder) are not > executable, so I am a little concerned they are orphans from an older > version and are superseded by newer utilities in a different location. > > Any pointers would be much appreciated, thanks in advance. > > J > > -- 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 [email protected]. To view this discussion visit https://groups.google.com/d/msgid/weewx-user/6aaad679-8713-4252-a168-4f7a3ac54d51n%40googlegroups.com.
