Just a quick followup re: how long it takes to reconfigure things to the
new default extended schema using Blaine's db as a test...
Rather than grow old(er) trying it on a pi3+ again, I threw compute on it
and did the updates in a vagrant/Parallels vm on a m1 mac mini.
weectl station reconfigure
(answer y - takes 35 secs to do this step)
mv weewx.sdb weewx.sdb.keepme
mv weewx.sdb_new weewx.sdb
weectl database rebuild-daily
(answer y - takes 88 secs to do this step)
And done. About 3 minutes end to end on a m1 mac mini. Pretty cool.
Initial startup and subsequent report runs were blazing fast and
Belchertown worked fine.
You gotta love throwing compute at problems....
Geez these are fast. Initial creation of a zillion NOAA files in just a
few seconds.
Next runs in a fraction of a second. Wow the m1 chip is fast.
2024-01-19T10:50:15.235599-08:00 deb12pip weewxd[3084]: INFO weewx.manager:
Added record 2024-01-19 10:50:00 PST (1705690200) to database 'weewx.sdb'
2024-01-19T10:50:15.246551-08:00 deb12pip weewxd[3084]: INFO weewx.manager:
Added record 2024-01-19 10:50:00 PST (1705690200) to daily summary in
'weewx.sdb'
2024-01-19T10:50:18.956902-08:00 deb12pip weewxd[3084]: INFO
weewx.cheetahgenerator: Generated 128 files for report SeasonsReport in
3.67 seconds
2024-01-19T10:50:19.630892-08:00 deb12pip weewxd[3084]: INFO
weewx.imagegenerator: Generated 60 images for report SeasonsReport in 0.67
seconds
2024-01-19T10:50:19.631922-08:00 deb12pip weewxd[3084]: INFO
weewx.reportengine: Copied 5 files to /home/vagrant/weewx-data/public_html
2024-01-19T10:50:19.636177-08:00 deb12pip weewxd[3084]: INFO
user.belchertown: version 1.3.1
2024-01-19T10:50:25.326411-08:00 deb12pip weewxd[3084]: INFO
weewx.cheetahgenerator: Generated 132 files for report Belchertown in 5.69
seconds
2024-01-19T10:50:25.329042-08:00 deb12pip weewxd[3084]: INFO
weewx.reportengine: Copied 40 files to
/home/vagrant/weewx-data/public_html/belchertown
2024-01-19T10:55:15.234969-08:00 deb12pip weewxd[3084]: INFO weewx.manager:
Added record 2024-01-19 10:55:00 PST (1705690500) to database 'weewx.sdb'
2024-01-19T10:55:15.244564-08:00 deb12pip weewxd[3084]: INFO weewx.manager:
Added record 2024-01-19 10:55:00 PST (1705690500) to daily summary in
'weewx.sdb'
2024-01-19T10:55:15.412840-08:00 deb12pip weewxd[3084]: INFO
weewx.cheetahgenerator: Generated 8 files for report SeasonsReport in 0.15
seconds
2024-01-19T10:55:15.507428-08:00 deb12pip weewxd[3084]: INFO
weewx.imagegenerator: Generated 15 images for report SeasonsReport in 0.09
seconds
2024-01-19T10:55:15.507714-08:00 deb12pip weewxd[3084]: INFO
weewx.reportengine: Copied 0 files to /home/vagrant/weewx-data/public_html
2024-01-19T10:55:15.794254-08:00 deb12pip weewxd[3084]: INFO
weewx.cheetahgenerator: Generated 12 files for report Belchertown in 0.28
seconds
2024-01-19T10:55:15.794966-08:00 deb12pip weewxd[3084]: INFO
weewx.reportengine: Copied 3 files to
/home/vagrant/weewx-data/public_html/belchertown
On Thursday, January 18, 2024 at 11:32:51 PM UTC-8 vince wrote:
> 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/606145b5-d890-4ff5-9006-4d6bf6cd355an%40googlegroups.com.
