Mike, Yes, would appear something was not right. I will make a note to have a look at how --rebuild-daily decides on whether it is actually going to do anything or not, that may give us a clue. I guess now that the daily summaries have been dropped and successfully rebuilt we will never know for sure.
Gary On Thursday, 3 January 2019 12:25:13 UTC+10, MikeQ wrote: > > Gary, > > I have weeWX running on a Raspberry Pi 2 Model B Rev 1.1 > > sqlite> SELECT COUNT(*) FROM archive; > 788656 > > wee_database returns no extra info on the command line when running only a > --rebuild-daily and it takes less than a second: > > pi@weatherpi:/var/lib/weewx $ sudo wee_database --rebuild-daily > Using configuration file /etc/weewx/weewx.conf > Using database binding 'wx_binding', which is bound to database > 'archive_sqlite' > All daily summaries will be rebuilt. > Proceed (y/n)? y > Rebuilding daily summaries in database 'weewx.sdb' ... > Daily summaries up to date in 'weewx.sdb' > > Now dropping the daily tables prior to rebuild: > > pi@weatherpi:/var/lib/weewx $ sudo wee_database --drop-daily > Using configuration file /etc/weewx/weewx.conf > Using database binding 'wx_binding', which is bound to database > 'archive_sqlite' > Proceeding will delete all your daily summaries from database 'weewx.sdb' > Are you sure you want to proceed (y/n)? y > Dropping daily summary tables from 'weewx.sdb' ... > Daily summary tables dropped from database 'weewx.sdb' in 2.20 seconds > > Running daily rebuild after drop: > > pi@weatherpi:/var/lib/weewx $ sudo wee_database --rebuild-daily > Using configuration file /etc/weewx/weewx.conf > Using database binding 'wx_binding', which is bound to database > 'archive_sqlite' > All daily summaries will be rebuilt. > Proceed (y/n)? y > Rebuilding daily summaries in database 'weewx.sdb' ... > Records processed: 788000; Last date: 2018-12-31 10:50:00 PST (1546282200) > Processed 788658 records to rebuild 2749 day summaries in 1498.94 > seconds > Rebuild of daily summaries in database 'weewx.sdb' complete > > So something is not running correctly if a rebuild is run standalone > without dropping the tables first. > > -- 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]. For more options, visit https://groups.google.com/d/optout.
