Re: IRe: [weewx-user] High CPU on 5.10

Yes, that was it. On Thursday, May 30, 2024 at 12:56:18 AM UTC-5 Ian Millard wrote: > Should the last command be: - > weectl database calc-missing > Sent from my iPad. > > On 30 May 2024, at 03:28, Mark Jenks wrote: > >  I ran this, and did the recalc-missing, and it seems to be running > bet

Re: IRe: [weewx-user] High CPU on 5.10

Should the last command be: -weectl database calc-missing Sent from my iPad.On 30 May 2024, at 03:28, Mark Jenks wrote: I ran this, and did the recalc-missing, and it seems to be running better.   Except there is only one record in those tables.Not sure why that would cause that issue.weectl data

IRe: [weewx-user] High CPU on 5.10

I ran this, and did the recalc-missing, and it seems to be running better. Except there is only one record in those tables. Not sure why that would cause that issue. weectl database add-column appTemp weectl database add-column cloudbase weectl database add-column visibility weectl database a

Re: [weewx-user] High CPU on 5.10

Seasons itself doesn't do it, and Belchertown with no settings on it is doing it. So, I'm adding those columns now and recalculating now. On Tuesday, May 28, 2024 at 1:15:56 PM UTC-5 mh081...@gmail.com wrote: > I think this was the Problem with missing Database extended schema object. > I h

Re: [weewx-user] High CPU on 5.10

Here is my Archive table; localhost/weewx/ http://phpmyadmin.mjenks.net/index.php?route=/database/sql&db=weewx Your SQL query has been executed successfully. show columns from archive; dateTime int(11) NO PRI NULL usUnits int(11) NO NULL interval int(11) NO NULL barometer double YES NULL

Re: [weewx-user] High CPU on 5.10

Not sure what you think I am changing within Belchertown. Other than MQTT, I'm just throwing in some settings to make it work. [[[Extras]]] site_title = Jenks Weather Website theme = dark logo_image = http://weather.mjenks.net/weather.jpg ra

Re: [weewx-user] High CPU on 5.10

Ripping out Belchertown completely. I did it before, but didn't let it sit for very long.Will see if the problem exists with Seasons. On Tuesday, May 28, 2024 at 1:15:56 PM UTC-5 mh081...@gmail.com wrote: > I think this was the Problem with missing Database extended schema object. > I had

Re: [weewx-user] High CPU on 5.10

I think this was the Problem with missing Database extended schema object. I had the same problem as i upgraded from weewx 4 to 5. I solved this with. weectl database add-column appTemp weectl database add-column cloudbase weectl database add-column visibility weectl database add-column windrun w

Re: [weewx-user] High CPU on 5.10

The other test would be to disable belchertown, enable seasons, and see if that’s ok. That would check the db vs. the v5 calculated aka synthetic readings feature that slowed some folks down. On Tuesday, May 28, 2024 at 10:25:10 AM UTC-7 Tom Keffer wrote: > I thought of the appTemp angle, but t

Re: [weewx-user] High CPU on 5.10

I thought of the appTemp angle, but those queries involve thousands of small aggregate intervals, not one query over 4 years. Still, it's worth a try. On Tue, May 28, 2024 at 9:07 AM vince wrote: > You seem to be hacking randomly and praying. I'd suggest deleting > Belchertown at this point, v

Re: [weewx-user] High CPU on 5.10

You seem to be hacking randomly and praying. I'd suggest deleting Belchertown at this point, verifying it is deleted, then add it back in. Do not customize it yet. Just run the default setup, it works. Really. My guess is you are missing the appTemp element in the db. There are a bunch of

Re: [weewx-user] High CPU on 5.10

I removed the last two from skin.conf, and it still does the large query. I'll keep digging tonight. generator_list = weewx.cheetahgenerator.CheetahGenerator, weewx.reportengine.CopyGenerator, user.belchertown.HighchartsJsonGenerator On Monday, May 27, 2024 at 10:06:02 PM UTC-5 Mark Jenks wro

Re: [weewx-user] High CPU on 5.10

false alarm so far. mqtt is tied to belchertown.So, seems to be belchertown like you suspected. Digging more tomorrow. On Monday, May 27, 2024 at 10:00:15 PM UTC-5 Mark Jenks wrote: > I just ripped mqtt out also. I'll check it in the morning and see if that > makes a difference. > >

Re: [weewx-user] High CPU on 5.10

I just ripped mqtt out also. I'll check it in the morning and see if that makes a difference. On Monday, May 27, 2024 at 9:52:21 PM UTC-5 Mark Jenks wrote: > Bad news? I uninstalled belchertown, and it's still hitting high CPU on > mariadb and python3. This is the hit to the DB. > > SELECT

Re: [weewx-user] High CPU on 5.10

Bad news? I uninstalled belchertown, and it's still hitting high CPU on mariadb and python3. This is the hit to the DB. SELECT * FROM archive WHERE dateTime > 1704088800 AND

Re: [weewx-user] High CPU on 5.10

Wild guess here. Belchertown writes its own NOAA directory with its own copies of those files that it creates, so verify that you have all the year and month files for all your data in the NOAA dir under the belchertown output directory. It’s ok to prepopulate it from old copies as needed to s

Re: [weewx-user] High CPU on 5.10

That query is asking for every single record over 4 years of data --- about 400,000+ records with a 5 minute archive interval. That's not the use pattern when an xtype is causing the problem . It's hard to imagine why the Belchertown skin wou

[weewx-user] High CPU on 5.10

Just built a new weewx on my Fedora 38 this morning, and attached it to my mariadb. It has 13 years worth of data in it. I am running Belchertown and mqtt, and installed Windy. But I just removed Windy to see if that was it, but still does it. Python and/or moriadb goes to 100% CPU. Mariadb