The db is running on another RPI-4b 4GB in the home LAN. No errors in the db-log. I like mariadb. This worked perfectly for years. Right now the system load is high as i am migrating data. I will check again as soon as the load settels down again ...
vince schrieb am Dienstag, 2. Dezember 2025 um 20:22:32 UTC+1: > Need more information. > > > > - What kind of system is running the db ? > > > - Where is this db system located - on your LAN ? On internet ? > > > - Are you seeing errors on the remote db server ? > > > - why do you need to use mariadb at all ? > > And also... > > - We need to see your 'current' logs from weewx startup through 'two' > full report cycles. > > If it was ok using sqlite3 as your db, and it is not ok using mariadb as > your db, the issue is likely a mariadb/weewx misconfiguration or a network > issue. > > If you (temporarily) switch back to sqlite3 and it is then ok again, it is > 'very' likely you have a mariadb/weewx misconfiguration or a network issue. > > > On Tuesday, December 2, 2025 at 11:09:41 AM UTC-8 Zed wrote: > >> @vince >> attached please find the diag-log. >> WeeWX is running on a RPI-4b 4GB. Right now the load is high because i'm >> migrating data. >> Normaly is works perfectly well since years. >> >> vince schrieb am Dienstag, 2. Dezember 2025 um 18:10:37 UTC+1: >> >>> If it broke when you switched from (local) sqlite to (remote) mariadb, >>> you likely have network or configuration issues in your mariadb setup >>> between the weewx system and that other system. >>> >>> What kind of pi are you running on ? What kind of system is running the >>> db ? Are you seeing errors on the remote db server ? >>> >>> As Tom said, we need to see your 'current' logs from weewx startup >>> through 'two' full report cycles. >>> >>> You might also attach the 'current' output of "*weectl diag >>> --output=filename*" after checking the output file has no >>> usernames/passwords in it. Weectl is pretty good about obfuscating such >>> things but it can't be perfect in all cases. >>> >>> On Tuesday, December 2, 2025 at 8:17:04 AM UTC-8 Tom Keffer wrote: >>> >>>> It's possible your reports are taking too long to process. Easy to do >>>> with a RPi. >>>> >>>> But it's hard to say without seeing a log. >>>> >>>> On Tue, Dec 2, 2025 at 7:56 AM Zed <[email protected]> wrote: >>>> >>>>> Hm, now i'm suffering: >>>>> >>>>> "INFO weewx.engine: Launch of report thread aborted: existing report >>>>> thread still running" >>>>> >>>>> How can i figure out, what's wrong? >>>>> >>>>> Zed schrieb am Dienstag, 2. Dezember 2025 um 16:28:48 UTC+1: >>>>> >>>>>> @John Smith You made my day! Looks like i'm getting old ;-) >>>>>> John Smith schrieb am Dienstag, 2. Dezember 2025 um 11:25:07 UTC+1: >>>>>> >>>>>>> You didn't configure weeWX for MariaDB >>>>>>> >>>>>>> Added record 2025-12-01 23:05:00 CET (1764626700) to database >>>>>>> 'weewx.sdb' >>>>>>> >>>>>>> >>>>>>> Specifically this section: >>>>>>> >>>>>>> >>>>>>> [DataBindings] >>>>>>> [[wx_binding]] >>>>>>> database = archive_sqlite >>>>>>> table_name = archive >>>>>>> manager = weewx.manager.DaySummaryManager >>>>>>> schema = weewx.schemas.wview_extended.schema >>>>>>> >>>>>>> >>>>>>> On Tue, 2 Dec 2025 at 21:03, Zed <[email protected]> wrote: >>>>>>> >>>>>>>> I had to upgrade my VEnv-installation from 4.9.1 to 5.2.0. >>>>>>>> The data is stored in mariadb since ever. >>>>>>>> Now in the reports i see the the values since the upgrade but none >>>>>>>> before. Not in the view week, month or year. >>>>>>>> The database backup contains several hundreds of thousand of >>>>>>>> records. So i guess the data is still there. >>>>>>>> What causes the old data to be hidden? >>>>>>>> >>>>>>>> S. issues #1043 >>>>>>>> <https://github.com/weewx/weewx/issues/1043#issue-3683018851> >>>>>>>> >>>>>>>> -- >>>>>>>> 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 visit >>>>>>>> https://groups.google.com/d/msgid/weewx-user/b1f919c7-439a-42f8-b952-1e96fc5a5366n%40googlegroups.com >>>>>>>> >>>>>>>> <https://groups.google.com/d/msgid/weewx-user/b1f919c7-439a-42f8-b952-1e96fc5a5366n%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 visit >>>>> https://groups.google.com/d/msgid/weewx-user/c779e7ed-b1b6-4a1d-97eb-31abdb5406a5n%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/weewx-user/c779e7ed-b1b6-4a1d-97eb-31abdb5406a5n%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 visit https://groups.google.com/d/msgid/weewx-user/222b6e08-be18-4d64-99d2-af7c247186dfn%40googlegroups.com.
