Daily summaries without corresponding archive records is definitely an undefined situation, so wee_database probably did the right thing by raising an exception.
But, I'd like to know how it came to be. Did you (Eelco) delete some rows in the archive database? -tk On Fri, Mar 17, 2017 at 2:27 AM, gjr80 <gjroder...@gmail.com> wrote: > Hi, > > Put simply --update will weight a number of daily summary fields according > to the interval used in the archive. Judging by the error trace provided > you appear to have daily summary records for days that have no records in > your archive. I think you have 2 options: > > - The quick fix is to run wee_database with --drop-daily followed by > --rebuild-daily to drop your daily summaries and then rebuild them from > your archive. The rebuild should fix the situation I indicated above and > you will not need to --update, the rebuild takes care of that. This > approach will result in some loss of granularity of the daily summary data > (eg max and min times) but otherwise it's non-destructive. > > - The alternative is to wait for Tom, he may have further insight, or he > may say do a --drop-daily followed by a --rebuild! Of course if your > station is offline you may be missing data if your station does not have > memory. > > I would also be interested to know if you did a wee_database --update > --dry-run beforehand, would like to know if the dry run missed the error. > > Gary > > -- > 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. > For more options, visit https://groups.google.com/d/optout. > -- 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. For more options, visit https://groups.google.com/d/optout.
