I just did AppTemperature but its working for me. Although i dont think i use any of the other columns as my station doesnt provide it.
Missing data calculations took about 8 minutes for 7 years of data on a Pi4. On Friday 19 January 2024 at 19:14:09 UTC+9 mh081...@gmail.com wrote: > 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:x...@gw.martenhinrichs.de:8883/ > <http://pi:x...@gw.martenhinrichs.de: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 > > ####################################################################################################### > > > > > > mh081...@gmail.com 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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/a9ff770a-a173-496b-a19f-e0a09046a184n%40googlegroups.com.
