Year plots and NOAA reports after transferring MySql to Sqlite

[Joachim Puttkammer]

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.



2. the annual graphs are also only created with the data from the end of February (I deleted all annual images once).



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.

[Tom Keffer]

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

--
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+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/a1ca712d-4ce2-4d05-9e37-f2f828c4cb39n%40googlegroups.com.

[Joachim Puttkammer]

the result doesn't look good, only 15 records.

The MySql DB shows 86 records, that were not transferred .

How can I make up for this transfer?

[Joachim Puttkammer]

I changed the archive interval on 5 April

[Tom Keffer]

Are you sure you rebuilt the daily summaries?

wee_database --drop-daily

wee_database --rebuild-daily

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/f088bb9c-434e-4258-bd26-f3e271472ac7n%40googlegroups.com.

[Joachim Puttkammer]

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. 

[Tom Keffer]

Try deleting the NOAA reports and let WeeWX regenerate them.

There's a bug that prevents wind from appearing in yearly summaries. For a fix, see this thread: https://groups.google.com/g/weewx-user/c/FCcu3ORLB2k/m/uqUs30RDBgAJ

-tk

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/3334fc25-20bc-4049-991d-1302adc7158cn%40googlegroups.com.

[Joachim Puttkammer]

It worked, so simple  and also the bug report.
Thanks for the help.