Are you sure you rebuilt the daily summaries? *wee_database --drop-daily* *wee_database --rebuild-daily*
On Mon, Apr 11, 2022 at 5:16 AM Joachim Puttkammer <[email protected]> wrote: > I changed the archive interval on 5 April > > Joachim Puttkammer schrieb am Montag, 11. April 2022 um 14:12:35 UTC+2: > >> the result doesn't look good, only 15 records. >> [image: daily_summaries.png] >> >> The MySql DB shows 86 records, that were not transferred . >> How can I make up for this transfer? >> >> [email protected] schrieb am Sonntag, 10. April 2022 um 17:16:41 UTC+2: >> >>> Hi, Joachim, >>> >>> You said you checked the database archive table, but how about the daily >>> summaries? What do you get for >>> >>> SELECT datetime(dateTime,'unixepoch','localtime'), count FROM >>> archive_day_outTemp WHERE dateTime >= 1640995200; >>> >>> This will show how many records (count) are in each daily summary since >>> the beginning of the year. The count must be non-zero for the date to show >>> in the NOAA report. >>> >>> -tk >>> >>> On Sun, Apr 10, 2022 at 6:14 AM Joachim Puttkammer <[email protected]> >>> wrote: >>> >>>> I use a Pi4 without a fan and Debian Buster as my operating system. >>>> Installed is *Weewx-Multi *( vers. 4.7 Season and Belchertown skin for >>>> both instances: Davis / Ecowitt ) with a MySQl database. The CPU >>>> temperature reached almost 80° and the Raspberry started to have problems. >>>> On 27 February, I switched the database to Sqlite without importing the >>>> existing MySQl data and the CPU temperature was then at 60°C. >>>> Yesterday I did a transfer of all MySQl databases with "wee_database >>>> --config=/etc/weewx/xyz.conf --transfer --dest-binding=dest_binding" and a >>>> "rebuild-daily" . It worked without errors and all records ( table archive >>>> I have checked ) are present. >>>> Unfortunately 2 problems occur: >>>> 1. the entries up to 28 February are missing from the February NOAA >>>> table and the months January and February are missing from the year table. >>>> >>>> [image: NOAA.png] >>>> >>>> 2. the annual graphs are also only created with the data from the end >>>> of February (I deleted all annual images once). >>>> >>>> [image: year.png] >>>> >>>> This is the case for both instances. >>>> >>>> The NOAA report behaves identically with the Belchertown skin. Only the >>>> yearly graphic is complete, in contrast to the season skin. >>>> >>>> As an attachment, here is the syslog with debug = 0 and debug = 1. >>>> >>>> >>>> -- >>>> 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 on the web visit >>>> https://groups.google.com/d/msgid/weewx-user/a1ca712d-4ce2-4d05-9e37-f2f828c4cb39n%40googlegroups.com >>>> <https://groups.google.com/d/msgid/weewx-user/a1ca712d-4ce2-4d05-9e37-f2f828c4cb39n%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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/f088bb9c-434e-4258-bd26-f3e271472ac7n%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/f088bb9c-434e-4258-bd26-f3e271472ac7n%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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEBiA%2BVi76uuspj3Yv9epC5sR-CnP_5XhUuXGVSBDSPk0A%40mail.gmail.com.
