Re: [weewx-user] Re: Wrong rain in daily archive but ok in archive

Roberto, You have a lot of odd ball timestamps in your archive but that should not affect things. I'd like to have a closer look at your database and run it through wee_database here where I can monitor what goes on a bit closer. Would you be prepared to email your database to me? You only have

Re: [weewx-user] Re: Wrong rain in daily archive but ok in archive

Hi Gary, attached the info requested. Moreover,to execute the query i perform those steps: cd /var/lib/weewx sudo sqlite3 weewx.sdb Thanks again Roberto Il gio 27 ott 2022, 22:46 gjr80 ha scritto: > So the data is still inconsistent. In my last post I asked you to include > the exact command

Re: [weewx-user] Re: Wrong rain in daily archive but ok in archive

So the data is still inconsistent. In my last post I asked you to include the exact command you used to start sqlite3; you didn't provide that information - could you please provide that. Also, can you provide a wee_debug report. wee_debug

Re: [weewx-user] Re: Wrong rain in daily archive but ok in archive

Hi Gary, thanks in advance for your support,below the command requested: sqlite> SELECT SUM(rain) FROM archive WHERE dateTime>1601157600 AND dateTime<=1601244000; 1.13385826771654 sqlite> SELECT sum FROM archive_day_rain WHERE dateTime=1601157600; 0.645669291338583 sqlite> SELECT MIN(dateTime

Re: [weewx-user] Re: Wrong rain in daily archive but ok in archive

OK, that all looks as expected and importantly no errors. Let's have a look in your database. Can you please start a sqlite3 session with your WeeWX database and execute the following queries: 1. archive rainfall for day of concern: sqlite> SELECT SUM(rain) FROM archive WHERE dateTime>1601157600

Re: [weewx-user] Re: Wrong rain in daily archive but ok in archive

Hi Gary, sorry for late reply,below the output requested pi@raspberrypi:~ $ sudo wee_database --drop-daily Using configuration file /etc/weewx/weewx.conf Using database binding 'wx_binding', which is bound to database 'archive_sqlite' Proceeding will delete all your daily summaries from database

Re: [weewx-user] Re: Wrong rain in daily archive but ok in archive

OK, if there is a discrepancy between the daily summaries and the archive the solution is to drop and rebuild the daily summaries. If that approach does not work we need to track down why. The first step is to look at the output of the wee_database --drop-daily and wee_database --rebuild-daily

Re: [weewx-user] Re: Wrong rain in daily archive but ok in archive

Hi Gary, i performed the step you reported,dropping daily and rebuilding them. I have still the issue,below the queries after steps you reported. Thanks in advance. sqlite> select sum(rain) from archive where dateTime > 1601157600 and dateTime <= 1601244000 and rain != 0; sum(rain) 1.13385826771

Re: [weewx-user] Re: Wrong rain in daily archive but ok in archive

I'm sorry I am a bit confused. You just said 'as reported I already did every step you suggested' but your original post made no mention of the steps I mentioned. It's not clear to me what you have/have not done. Irrespective, can you please stop WeeWX, execute the wee_database --drop-daily and

Re: [weewx-user] Re: Wrong rain in daily archive but ok in archive

Hi gary, As i reported,I already did every step you suggested,data on archive_daily_rain is still wrong Il dom 23 ott 2022, 10:42 gjr80 ha scritto: > Hi, > > Just a couple of points on terminology so we are on the same sheet of > music. In a default install your WeeWX database has a table na

[weewx-user] Re: Wrong rain in daily archive but ok in archive

Hi, Just a couple of points on terminology so we are on the same sheet of music. In a default install your WeeWX database has a table named archive, this is commonly known as 'the archive'. There are numerous other tables in the database whose name are in the format archive_day_x, these tab