Is this line correct and the hostname listed in /etc/hosts or a LAN resolver?
host = mariadb.local On Wed, 3 Dec 2025 at 10:40, John Smith <[email protected]> wrote: > Why didn't you copy your old config when you updated, or did it get > deleted somehow and there is no backup of it? > > On Wed, 3 Dec 2025 at 06:30, Zed <[email protected]> wrote: > >> 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 >> <https://groups.google.com/d/msgid/weewx-user/222b6e08-be18-4d64-99d2-af7c247186dfn%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/CAGTinV6HVM8fbfBXFVZfDEKrzJLhWBdTRvQjNuJN%2Brat4aXAoA%40mail.gmail.com.
