Hi, as i read in the other posts about this Problem i doing now following.
weectl database add-column appTemp weectl database add-column cloudbase weectl database add-column visibility weectl database add-column windrun weectl database add-column cloud_cover weectl database add-column aqi weectl database calc-missing Answer all wit 'y' Now it seems that the Problem was solved. Belchertown Reports was generated in about 6 seconds. Thanks @vince for your right direction. ############################## Jan 19 11:09:50 wetter weewxd[293936]: INFO weewx.engine: Loading station type Vantage (weewx.drivers.vantage) Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.engine: StdConvert target unit is 0x1 Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.wxservices: StdWXCalculate will use data binding wx_binding Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.engine: Archive will use data binding wx_binding Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.engine: Record generation will be attempted in 'hardware' Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.engine: Using archive interval of 300 seconds (specified by hardware) Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.restx: StationRegistry: Registration not requested. Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.restx: Wunderground-PWS: Data for station IMECKLEN47 will be posted Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.restx: PWSWeather: Data for station MHROSTOCK will be posted Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.restx: CWOP: Posting not enabled. Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.restx: WOW: Posting not enabled. Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.restx: AWEKAS: Posting not enabled. Jan 19 11:09:53 wetter weewxd[293936]: INFO user.mqtt: service version is 0.23 Jan 19 11:09:53 wetter weewxd[293936]: INFO user.mqtt: binding to ['archive', 'loop'] Jan 19 11:09:53 wetter weewxd[293936]: INFO user.mqtt: topic is weather Jan 19 11:09:53 wetter weewxd[293936]: INFO user.mqtt: desired unit system is METRIC Jan 19 11:09:53 wetter weewxd[293936]: INFO user.mqtt: data will be uploaded to mqtt://pi:[email protected]:8883/ Jan 19 11:09:53 wetter weewxd[293936]: INFO user.mqtt: network encryption/authentication will be attempted Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.engine: 'pyephem' detected, extended almanac data is available Jan 19 11:09:53 wetter weewxd[293936]: INFO __main__: Starting up weewx version 5.0.0 Jan 19 11:09:54 wetter weewxd[293936]: INFO weewx.engine: Clock error is 2.69 seconds (positive is fast) Jan 19 11:09:54 wetter weewxd[293936]: INFO weewx.engine: Using binding 'wx_binding' to database 'weewx.sdb' Jan 19 11:09:54 wetter weewxd[293936]: INFO weewx.manager: Starting backfill of daily summaries Jan 19 11:09:54 wetter weewxd[293936]: INFO weewx.manager: Daily summaries up to date Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.wxxtypes: Type beaufort has been deprecated. Use unit beaufort instead. Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.manager: Added record 2024-01-19 10:50:00 CET (1705657800) to database 'weewx.sdb' Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.manager: Added record 2024-01-19 10:50:00 CET (1705657800) to daily summary in 'weewx.sdb' Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.manager: Added record 2024-01-19 10:55:00 CET (1705658100) to database 'weewx.sdb' Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.manager: Added record 2024-01-19 10:55:00 CET (1705658100) to daily summary in 'weewx.sdb' Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.manager: Added record 2024-01-19 11:00:00 CET (1705658400) to database 'weewx.sdb' Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.manager: Added record 2024-01-19 11:00:00 CET (1705658400) to daily summary in 'weewx.sdb' Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.restx: PWSWeather: Published record 2024-01-19 10:50:00 CET (1705657800) Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.manager: Added record 2024-01-19 11:05:00 CET (1705658700) to database 'weewx.sdb' Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.manager: Added record 2024-01-19 11:05:00 CET (1705658700) to daily summary in 'weewx.sdb' Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.engine: Starting main packet loop. Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.restx: PWSWeather: Published record 2024-01-19 10:55:00 CET (1705658100) Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.restx: PWSWeather: Published record 2024-01-19 11:00:00 CET (1705658400) Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.restx: Wunderground-PWS: Published record 2024-01-19 10:50:00 CET (1705657800) Jan 19 11:09:57 wetter weewxd[293936]: INFO weewx.restx: Wunderground-PWS: Published record 2024-01-19 10:55:00 CET (1705658100) Jan 19 11:09:57 wetter weewxd[293936]: INFO weewx.restx: PWSWeather: Published record 2024-01-19 11:05:00 CET (1705658700) Jan 19 11:09:57 wetter weewxd[293936]: INFO weewx.restx: Wunderground-PWS: Published record 2024-01-19 11:00:00 CET (1705658400) Jan 19 11:09:57 wetter weewxd[293936]: INFO weewx.restx: Wunderground-PWS: Published record 2024-01-19 11:05:00 CET (1705658700) Jan 19 11:10:01 wetter CRON[293953]: (root) CMD (/root/get_picture_camera1.sh >/dev/null 2>&1) Jan 19 11:10:01 wetter CRON[293954]: (root) CMD (/root/get_picture_webcam.sh >/dev/null 2>&1) Jan 19 11:10:01 wetter CRON[293956]: (root) CMD (/root/get_picture_camera2.sh >/dev/null 2>&1) Jan 19 11:10:17 wetter weewxd[293936]: INFO weewx.manager: Added record 2024-01-19 11:10:00 CET (1705659000) to database 'weewx.sdb' Jan 19 11:10:17 wetter weewxd[293936]: INFO weewx.manager: Added record 2024-01-19 11:10:00 CET (1705659000) to daily summary in 'weewx.sdb' Jan 19 11:10:18 wetter weewxd[293936]: INFO weewx.restx: Wunderground-PWS: Published record 2024-01-19 11:10:00 CET (1705659000) Jan 19 11:10:18 wetter weewxd[293936]: INFO weewx.restx: PWSWeather: Published record 2024-01-19 11:10:00 CET (1705659000) Jan 19 11:10:19 wetter weewxd[293936]: INFO weewx.cheetahgenerator: Generated 8 files for report SeasonsReport in 0.99 seconds Jan 19 11:10:20 wetter weewxd[293936]: INFO weewx.imagegenerator: Generated 30 images for report SeasonsReport in 1.42 seconds Jan 19 11:10:20 wetter weewxd[293936]: INFO weewx.reportengine: Copied 5 files to /var/www/html/weewx Jan 19 11:10:20 wetter weewxd[293936]: INFO user.belchertown: version 1.3.1 Jan 19 11:10:23 wetter weewxd[293936]: INFO user.belchertown: New forecast file downloaded to /var/www/html/json/forecast.json Jan 19 11:10:26 wetter weewxd[293936]: INFO weewx.cheetahgenerator: Generated 12 files for report Belchertown in 6.25 seconds Jan 19 11:10:26 wetter weewxd[293936]: INFO weewx.reportengine: Copied 40 files to /var/www/html ####################################################################################################### [email protected] schrieb am Freitag, 19. Januar 2024 um 10:32:55 UTC+1: > Hi, > > as you wish. I have no extra/extended schema in my database. > ##### > root@wetter:~# echo "select count(*) from pragma_table_info('archive');" | > sqlite3 /var/tmp/test.sdb > 52 > ##### > > > vince schrieb am Freitag, 19. Januar 2024 um 08:32:51 UTC+1: > >> Followup on this one - If the original poster can check to see if their >> database uses the old original (small) wview schema that would likely help. >> Easiest way is to look to see how many elements are in the database. One >> way to see how many elements you have in your db would be: >> >> - cp weewx.sdb /var/tmp/test.sdb >> - echo "select count(*) from pragma_table_info('archive');" | sqlite3 >> /var/tmp/test.sdb >> - (my db with the extended schema returns "114" as the count) >> - (a db with the original wview schema returns "52" as the count) >> >> >> Switching to the extended schema is a bit of work and takes some time. >> The details are documented at >> http://www.weewx.com/docs/5.0/custom/database/ with the procedure for >> how to switch to the new bigger schema in >> http://www.weewx.com/docs/5.0/custom/database/#reconfigure-using-new-schema >> - but be CAREFUL doing this and ALWAYS work off a copy of your db so if >> anything happens you can revert to a known good db. I've done it so many >> years ago at this point that I'll have to defer to others for pitfalls and >> how they do it, but the links above are how the current docs recommend >> doing so. >> >> Short description to the original Belchertown problem reporters - check >> your db schema. Hopefully that's the pattern of which systems will need to >> take action. >> >> >> -- 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 on the web visit https://groups.google.com/d/msgid/weewx-user/5dd1671a-4114-4312-a040-8e1138e6f697n%40googlegroups.com.
