Starting a clean weewx.sdb file

John Blanchard

unread,

Sep 14, 2020, 4:28:39 PM9/14/20

to weewx-user

I'm running Weewx 4.11 on Debian 10 (Buster) with a Vantage Vue station.

I want erase all historic data from my computer and rebuild from the memory of the weather station. (I know there is a few months of data held in its memory)

This is the process followed to date:-

- stop weewx

- delete the weewx.sdb file

- delete the contents of /etc/weewx

- delete the contents of /var/www

- uninstall weewx

- purge weewx

- reboot computer

- reinstall weewx and wait for an initial rebuild of data from the weather stations memory

But I do not get a full history rebuild into the new weewx.sdb - the database only rebuilds from the date/time of the last download from the station to the computer - which is say the last 30 minutes.

There is obviously a record of the date/time of the previously downloaded data stored somewhere which I haven't found. Where is this held and how to I reset this to allow a full download, short of a reformat of the hard drive?

Thanks

Tom Keffer

unread,

Sep 14, 2020, 4:52:16 PM9/14/20

to weewx-user

What was the path of the weewx.sdb file that you deleted? It should be /var/lib/weewx/weewx.sdb.

You did not include a log, but I assume that weewxd is using that file, and not one at /home/weewx/archive/weewx.sdb.

--
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+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/ea114e34-1012-43e1-bbf0-2f3dba4fcc11n%40googlegroups.com.

John Blanchard

unread,

Sep 14, 2020, 5:06:00 PM9/14/20

to weewx-user

The file deleted was /var/lib/weewx/weewx.sdb.

Sep 15 09:03:42 weewx-reynolds weewx[1991] INFO weewx.manager: Starting backfill of daily summaries
Sep 15 09:03:42 weewx-reynolds weewx[1991] INFO weewx.manager: Added record 2020-09-15 08:15:00 NZST (1600114500) to database 'weewx.sdb'
Sep 15 09:03:43 weewx-reynolds weewx[1991] INFO weewx.manager: Added record 2020-09-15 08:15:00 NZST (1600114500) to daily summary in 'weewx.sdb'
Sep 15 09:03:43 weewx-reynolds weewx[1991] INFO weewx.manager: Added record 2020-09-15 08:20:00 NZST (1600114800) to database 'weewx.sdb'
Sep 15 09:03:43 weewx-reynolds weewx[1991] INFO weewx.manager: Added record 2020-09-15 08:20:00 NZST (1600114800) to daily summary in 'weewx.sdb'

Tom Keffer

unread,

Sep 14, 2020, 6:06:38 PM9/14/20

to weewx-user

If it's still doing it, we will need to see a log. Set debug=1, restart weewx, post the log through the first reporting cycle.

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/e874b202-8723-4f7e-939f-50ef284aec15n%40googlegroups.com.

John Blanchard

unread,

Sep 14, 2020, 8:54:28 PM9/14/20

to weewx-user

Sep 15 12:40:33 weewx-reynolds weewx[4734] INFO __main__: PID file is /var/run/weewx.pid
Sep 15 12:40:33 weewx-reynolds weewx[4722]: Starting weewx weather system: weewx.
Sep 15 12:40:33 weewx-reynolds systemd[1]: Started LSB: weewx weather system.
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO __main__: Using configuration file /etc/weewx/weewx.conf
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO __main__: Debug is 0
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.engine: Loading station type Vantage (weewx.drivers.vantage)
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.engine: StdConvert target unit is 0x1
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.manager: Created and initialized table 'archive' in database 'weewx.sdb'
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.manager: Created daily summary tables
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.wxservices: The following values will be calculated: pressure=prefer_hardware, altimeter=prefer_hardware, appTemp=prefer_hardware, barometer=prefer_hardware, beaufort=prefer_hardware, cloudbase=prefer_hardware, dewpoint=prefer_hardware, ET=prefer_hardware, heatindex=prefer_hardware, humidex=prefer_hardware, inDewpoint=prefer_hardware, maxSolarRad=prefer_hardware, rainRate=prefer_hardware, windchill=prefer_hardware, windrun=prefer_hardware
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.wxservices: The following algorithms will be used for calculations: altimeter=aaASOS, maxSolarRad=RS
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.engine: Archive will use data binding wx_binding
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.engine: Record generation will be attempted in 'hardware'
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.engine: Using archive interval of 300 seconds (specified by hardware)
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.restx: StationRegistry: Registration not requested.
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.restx: Wunderground: Posting not enabled.
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.restx: PWSweather: Posting not enabled.
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.restx: CWOP: Posting not enabled.
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.restx: WOW: Posting not enabled.
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.restx: AWEKAS: Posting not enabled.
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO __main__: Starting up weewx version 4.1.1
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.engine: Clock error is -0.52 seconds (positive is fast)
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.engine: Using binding 'wx_binding' to database 'weewx.sdb'
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.manager: Starting backfill of daily summaries
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.manager: Added record 2020-09-14 22:05:00 NZST (1600077900) to database 'weewx.sdb'
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.manager: Added record 2020-09-14 22:05:00 NZST (1600077900) to daily summary in 'weewx.sdb'
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.manager: Added record 2020-09-14 22:10:00 NZST (1600078200) to database 'weewx.sdb'
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.manager: Added record 2020-09-14 22:10:00 NZST (1600078200) to daily summary in 'weewx.sdb'
Sep 15 12:40:33 weewx-reynolds weewx[4738] INFO weewx.manager: Added record 2020-09-14 22:15:00 NZST (1600078500) to database 'weewx.sdb'
Sep 15 12:40:34 weewx-reynolds weewx[4738] INFO weewx.manager: Added record 2020-09-14 22:15:00 NZST (1600078500) to daily summary in 'weewx.sdb'

Sep 15 12:40:34 weewx-reynolds weewx[4738] INFO weewx.manager: Added record 2020-09-14 22:20:00 NZST (1600078800) to database 'weewx.sdb'

Continues backfilling until current time then shows

Sep 15 12:41:10 weewx-reynolds weewx[4738] INFO weewx.engine: Starting main packet loop.

Message has been deleted

John Blanchard

unread,

Sep 14, 2020, 9:07:05 PM9/14/20

to weewx-user

Is it something to do with the PID?? the file /var/run/weewx.pid seem to be there when weewx is running and hold a number such as 4738, but disappears when you stop weewx

Tom Keffer

unread,

Sep 14, 2020, 9:14:49 PM9/14/20

to weewx-user

You didn't set debug=1, but that looks normal. The earliest record in your Vantage logger appears to be 2020-09-14 22:05:00 NZST.

You can double check by using the wee_device utility, using the --logger-summary option and a file name. Make sure you stop weewx first.

wee_device --logger-summary=/var/tmp/logger_summary.txt

This will take a few minutes, but it will record in logger_summary.txt what's in the logger.

-tk

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/68ce4928-de86-4e3d-b550-847faa139036n%40googlegroups.com.

Reply all

Reply to author

Forward