Already 1 step closer to the goal. *The year plot is now OK *. I had not run wee_database --drop-daily because the WIKI 'Transfer from MySQL to sqlite' did not mention this command.
The 2022 NOAA annual report does not contain wind speed data. In the Month NOAA report for March 2022 there are no datas from the 1st to 27th. [email protected] schrieb am Montag, 11. April 2022 um 16:50:57 UTC+2: > 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/3334fc25-20bc-4049-991d-1302adc7158cn%40googlegroups.com.
