The 519 s cycle was a cold start: you’d just scanned the database from sqlite3 and restarted the container, so nothing was cached and the first cycle paid your measured ~190 s cold scan plus first-run forecast work. The next cycle — 103 s — is your real steady state, right in line with your ~150 s warm scan doing most of the work.


And note 21:50:20: “Launch of report thread aborted: existing report thread still running.” That’s the message this thread began by saying never appears. It was always there — it just needs the process to survive to the next archive boundary, and beta4’s shorter lock windows finally let it.


Your cycles are still spending most of their time on that one empty-column scan. Bound the lookback and they drop from ~100 s to ~10.


John

On Aug 4, 2026, at 7:05 PM, Tom Mitchell <[email protected]> wrote:

Well the hits keep coming. When I started the container back up after running the queries against the db, for some reason the report cycle that had been taking 120-150 seconds took almost 10 minutes, and beta4/weewx did as I originally expected. The only changes I made are those in the beta4 update. I am curious why it does what I expect.

vt-1  | 2026-08-04 21:43:35,179 weewxd[8] INFO weewx.engine: Loading station type Vantage (weewx.drivers.vantage)
vt-1  | 2026-08-04 21:43:41,211 weewxd[8] INFO user.wxskyfield: Service version: 1.14
vt-1  | 2026-08-04 21:43:41,211 weewxd[8] INFO user.wxskyfield: WxSkyfield status: enabled...continuing.
vt-1  | 2026-08-04 21:43:41,213 weewxd[8] INFO user.wxskyfield: stars    : True
vt-1  | 2026-08-04 21:43:41,213 weewxd[8] INFO user.wxskyfield: user_root: /home/weewx/weewx-data/bin/user
vt-1  | 2026-08-04 21:43:41,214 weewxd[8] INFO user.wxskyfield: Skyfield version: 1.54.
vt-1  | 2026-08-04 21:43:41,299 weewxd[8] INFO user.wxskyfield: Loaded 420 named stars from the Hipparcos catalog.
vt-1  | 2026-08-04 21:43:41,301 weewxd[8] INFO user.wxskyfield: Skyfield almanac registered; reports will use Skyfield for almanac computations.
vt-1  | 2026-08-04 21:43:41,303 weewxd[8] INFO weewx.engine: StdConvert target unit is 0x1
vt-1  | 2026-08-04 21:43:41,303 weewxd[8] INFO weewx.wxservices: StdWXCalculate will use data binding wx_binding
vt-1  | 2026-08-04 21:43:41,310 weewxd[8] INFO weewx.engine: Archive will use data binding wx_binding
vt-1  | 2026-08-04 21:43:41,310 weewxd[8] INFO weewx.engine: Record generation will be attempted in 'hardware'
vt-1  | 2026-08-04 21:43:41,311 weewxd[8] INFO weewx.engine: Using archive interval of 300 seconds (specified by hardware)
vt-1  | 2026-08-04 21:43:41,313 weewxd[8] INFO weewx.restx: StationRegistry: Station will be registered.
vt-1  | 2026-08-04 21:43:41,315 weewxd[8] INFO weewx.restx: Wunderground-RF: Data for station KVTLUNEN4 will be posted
vt-1  | 2026-08-04 21:43:41,319 weewxd[8] INFO weewx.restx: PWSWeather: Data for station KVTLUNEN4 will be posted
vt-1  | 2026-08-04 21:43:41,328 weewxd[8] INFO weewx.restx: CWOP: Data for station EW2749 will be posted
vt-1  | 2026-08-04 21:43:41,334 weewxd[8] INFO weewx.restx: WOW: Data for station 5419f9b8-2beb-e711-bd60-0003ff5962e0 will be posted to https://wow.metoffice.gov.uk/automaticreading
vt-1  | 2026-08-04 21:43:41,336 weewxd[8] INFO weewx.restx: AWEKAS: No config info. Skipped.
vt-1  | 2026-08-04 21:43:41,336 weewxd[8] INFO user.mqtt: service version is 0.24
vt-1  | 2026-08-04 21:43:41,336 weewxd[8] INFO user.mqtt: binding to ['archive', 'loop']
vt-1  | 2026-08-04 21:43:41,336 weewxd[8] INFO user.mqtt: data_binding is wx_binding
vt-1  | 2026-08-04 21:43:41,342 weewxd[8] INFO user.mqtt: topic is weather/vt
vt-1  | 2026-08-04 21:43:41,342 weewxd[8] INFO user.mqtt: desired unit system is US
vt-1  | 2026-08-04 21:43:41,343 weewxd[8] INFO user.mqtt: data will be uploaded to mqtt://tom:[email protected]:1883
vt-1  | 2026-08-04 21:43:41,344 weewxd[8] INFO user.windy: version is 0.8
vt-1  | 2026-08-04 21:43:41,356 weewxd[8] INFO user.windy: Data will be uploaded to https://stations.windy.com/api/v2/observation/update
vt-1  | 2026-08-04 21:43:41,357 weewxd[8] INFO weewx.engine: 'pyephem' not detected, extended almanac data is not available
vt-1  | 2026-08-04 21:43:41,360 weewxd[8] INFO weewxd: Starting up weewx version 5.4.0
vt-1  | 2026-08-04 21:43:43,363 weewxd[8] INFO weewx.engine: Clock error is -0.36 seconds (positive is fast)
vt-1  | 2026-08-04 21:43:43,363 weewxd[8] INFO weewx.engine: Using binding 'wx_binding' to database 'weewx.sdb'
vt-1  | 2026-08-04 21:43:43,364 weewxd[8] INFO weewx.manager: Starting backfill of daily summaries
vt-1  | 2026-08-04 21:43:43,364 weewxd[8] INFO weewx.manager: Daily summaries up to date
vt-1  | 2026-08-04 21:43:45,867 weewxd[8] INFO weewx.engine: Starting main packet loop.
vt-1  | 2026-08-04 21:43:49,968 weewxd[8] INFO user.mqtt: client established for mqtt://tom:[email protected]:1883
vt-1  | 2026-08-04 21:45:19,339 weewxd[8] INFO weewx.manager: Added record 2026-08-04 21:45:00 EDT (1785894300) to database 'weewx.sdb'
vt-1  | 2026-08-04 21:45:19,391 weewxd[8] INFO weewx.manager: Added record 2026-08-04 21:45:00 EDT (1785894300) to daily summary in 'weewx.sdb'
vt-1  | 2026-08-04 21:45:20,063 weewxd[8] INFO weewx.restx: Windy: Published record 2026-08-04 21:45:00 EDT (1785894300)
vt-1  | 2026-08-04 21:45:21,746 weewxd[8] INFO user.new_belchertown: version 2.1beta4
vt-1  | 2026-08-04 21:45:44,763 weewxd[8] ERROR weewx.restx: StationRegistry: Failed to publish record 2026-08-04 21:45:00 EDT (1785894300): HTTP Error 429: TOO MANY REQUESTS
vt-1  | 2026-08-04 21:50:19,565 weewxd[8] INFO weewx.manager: Added record 2026-08-04 21:50:00 EDT (1785894600) to database 'weewx.sdb'
vt-1  | 2026-08-04 21:50:19,704 weewxd[8] INFO weewx.manager: Added record 2026-08-04 21:50:00 EDT (1785894600) to daily summary in 'weewx.sdb'
vt-1  | 2026-08-04 21:50:20,134 weewxd[8] INFO weewx.engine: Launch of report thread aborted: existing report thread still running
vt-1  | 2026-08-04 21:50:20,815 weewxd[8] INFO weewx.restx: Windy: Published record 2026-08-04 21:50:00 EDT (1785894600)
vt-1  | 2026-08-04 21:54:00,639 weewxd[8] INFO weewx.cheetahgenerator: Generated 16 files for report new-belchertown in 519.73 seconds
vt-1  | 2026-08-04 21:54:06,452 weewxd[8] INFO weeutil.rsyncupload: rsync'd 61 files (5,013,997 bytes) in 1.33 seconds
vt-1  | 2026-08-04 21:55:19,799 weewxd[8] INFO weewx.manager: Added record 2026-08-04 21:55:00 EDT (1785894900) to database 'weewx.sdb'
vt-1  | 2026-08-04 21:55:19,871 weewxd[8] INFO weewx.manager: Added record 2026-08-04 21:55:00 EDT (1785894900) to daily summary in 'weewx.sdb'
vt-1  | 2026-08-04 21:55:20,682 weewxd[8] INFO weewx.restx: Windy: Published record 2026-08-04 21:55:00 EDT (1785894900)
vt-1  | 2026-08-04 21:56:04,272 weewxd[8] INFO user.new_belchertown: New forecast Current Conditions file downloaded to /home/weewx/weewx-data/public_html/belchertown/json/current_conditions.json
vt-1  | 2026-08-04 21:57:03,975 weewxd[8] INFO weewx.cheetahgenerator: Generated 16 files for report new-belchertown in 103.70 seconds
vt-1  | 2026-08-04 21:57:09,611 weewxd[8] INFO weeutil.rsyncupload: rsync'd 26 files (4,826,059 bytes) in 1.25 seconds

--
Tom Mitchell

--
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/4D732B5A-852E-4492-A23A-EE12BBAD047B%40johnkline.com.

Reply via email to