Web pages stuck at 11:40, but Wunderground-RF is doing just fine

[Del Merritt]

I've had my station set up since March 2020 (and years ago I was a wview user) with my Davis Vantage Pro 2. Yesterday evening I lost power, and the RPi that runs weewx 4.2.0 isn't on a UPS. When the power returned today just past noon, everything seemed to crank up, but the web pages created stopped at 11:40am (EST) today. The log shows that Wunderground-RF is chugging along fine, and I see appropriate data on wunderground:
   https://www.wunderground.com/dashboard/pws/KMENEWCA14

Below is what should be the relevant - and lightly edited - log extract from the period in question. You can see lots of updates to weewx.sdb up until 11:40. The one smoking gun, perhaps, is the clock error message at 12:26:27?

I have done a systemctl restart weewx.service; didn't seem to help. I stopped it and used screen to confirm I got a "TEST" response from the VP2 console. I confirmed with a sqlite3 PRAGMA integrity-check; that the two database files are OK. I have even done a full reboot of the RPi. 

I did try the "delete from archive where dateTime > X;" trick; didn't help. My weewx.sdb file's timestamp happens to also be stuck at the time the 11:40 record was added, which was 12:26:

  /var/lib/weewx$ ls -lt

   -rw-r--r-- 1 root root 14618624 Dec  1 12:26 weewx.sdb

  -rw-r--r-- 1 root root    57344 Dec  1 12:25 forecast.sdb

Still, the /var/www/html/weewx/index.html with the current date and time has:

  <div id="title">

    <h1 class="page_title">Phil's Hill, Newcastle, ME</h1>

    <p class="la total 30240stupdate">12/01/2020 11:40:00 AM</p>

  </div>

And the graphs on that page (pretty stock) all stop at 11:40am today as well.

Help?

Here's the logfile info from /var/log/messages:

----------------------

Life is good until the power went out:

Nov 30 20:19:33 lunos weewx[791] INFO weewx.restx: Wunderground-RF: Published record 2020-11-30 20:19:33 EST (1606785573)

Dec  1 12:25:34 lunos weewx[791] INFO weewx.restx: Wunderground-RF: Published record 2020-12-01 12:25:35 EST (1606843535)

Dec  1 12:25:35 lunos rsyslogd:  [origin software="rsyslogd" swVersion="8.1901.0" x-pid="347" x-info="https://www.rsyslog.com"] rsyslogd was HUPed

Dec  1 12:25:40 lunos weewx[791] INFO weewx.manager: Added record 2020-11-30 20:55:00 EST (1606787700) to database 'weewx.sdb'

Dec  1 12:25:40 lunos weewx[791] INFO weewx.manager: Added record 2020-11-30 20:55:00 EST (1606787700) to daily summary in 'weewx.sdb'

Dec  1 12:25:40 lunos weewx[791] INFO user.forecast: WUThread: WU: download forecast from 'https://api.weather.com//v3/wx/forecast/daily/5day?geocode=44.09999,-69.58985&format=json&units=e&language=en-US&apiKey=[redacted]'

Dec  1 12:25:40 lunos weewx[791] INFO weewx.manager: Added record 2020-11-30 21:00:00 EST (1606788000) to database 'weewx.sdb'

Dec  1 12:25:40 lunos weewx[791] INFO user.forecast: ZambrettiThread: Zambretti: generated 1 forecast record

Dec  1 12:25:40 lunos weewx[791] INFO weewx.manager: Added record 2020-11-30 21:00:00 EST (1606788000) to daily summary in 'weewx.sdb'

Dec  1 12:25:40 lunos weewx[791] INFO weewx.manager: Added record 2020-11-30 20:55:00 EST (1606787700) to database 'forecast.sdb'

Dec  1 12:25:40 lunos weewx[791] INFO weewx.restx: PWSWeather: Published record 2020-11-30 20:55:00 EST (1606787700)

Dec  1 12:25:40 lunos weewx[791] INFO user.forecast: ZambrettiThread: Zambretti: saved 1 forecast records

Dec  1 12:25:40 lunos weewx[791] INFO weewx.manager: Added record 2020-11-30 21:05:00 EST (1606788300) to database 'weewx.sdb'

Dec  1 12:25:40 lunos weewx[791] INFO weewx.manager: Added record 2020-11-30 21:05:00 EST (1606788300) to daily summary in 'weewx.sdb'

Dec  1 12:25:40 lunos weewx[791] INFO user.forecast: ZambrettiThread: Zambretti: deleted forecasts prior to 1606238740

Dec  1 12:25:40 lunos weewx[791] INFO weewx.restx: PWSWeather: Published record 2020-11-30 21:00:00 EST (1606788000)

Dec  1 12:25:40 lunos weewx[791] INFO weewx.restx: StationRegistry: Published record 2020-11-30 20:55:00 EST (1606787700)

Dec  1 12:25:41 lunos weewx[791] INFO weewx.restx: PWSWeather: Published record 2020-11-30 21:05:00 EST (1606788300)

Dec  1 12:25:41 lunos weewx[791] INFO weewx.manager: Added record 2020-11-30 21:10:00 EST (1606788600) to database 'weewx.sdb'

Dec  1 12:25:41 lunos weewx[791] INFO weewx.manager: Added record 2020-11-30 21:10:00 EST (1606788600) to daily summary in 'weewx.sdb'

Dec  1 12:25:41 lunos weewx[791] INFO user.forecast: WUThread: WU: download forecast from 'https://api.weather.com//v3/wx/forecast/daily/5day?geocode=44.09999,-69.58985&format=json&units=e&language=en-US&apiKey=[redacted]'

Dec  1 12:25:41 lunos weewx[791] INFO weewx.manager: Added record 2020-11-30 21:15:00 EST (1606788900) to database 'weewx.sdb'

Dec  1 12:25:41 lunos weewx[791] INFO weewx.manager: Added record 2020-11-30 21:15:00 EST (1606788900) to daily summary in 'weewx.sdb'

     : snip 8< 8< 8< 8<

Dec  1 12:26:20 lunos weewx[791] INFO weewx.manager: Added record 2020-12-01 11:00:00 EST (1606838400) to database 'weewx.sdb'

Dec  1 12:26:20 lunos weewx[791] INFO weewx.manager: Added record 2020-12-01 11:00:00 EST (1606838400) to daily summary in 'weewx.sdb'

Dec  1 12:26:20 lunos weewx[791] INFO weewx.restx: PWSWeather: Published record 2020-12-01 10:55:00 EST (1606838100)

Dec  1 12:26:21 lunos weewx[791] INFO user.forecast: WUThread: WU: download forecast from 'https://api.weather.com//v3/wx/forecast/daily/5day?geocode=44.09999,-69.58985&format=json&units=e&language=en-US&apiKey=[redacted]'

Dec  1 12:26:21 lunos weewx[791] INFO weewx.manager: Added record 2020-12-01 11:05:00 EST (1606838700) to database 'weewx.sdb'

Dec  1 12:26:21 lunos weewx[791] INFO weewx.manager: Added record 2020-12-01 11:05:00 EST (1606838700) to daily summary in 'weewx.sdb'

Dec  1 12:26:21 lunos weewx[791] INFO weewx.restx: PWSWeather: Published record 2020-12-01 11:00:00 EST (1606838400)

Dec  1 12:26:21 lunos weewx[791] INFO weewx.manager: Added record 2020-12-01 11:10:00 EST (1606839000) to database 'weewx.sdb'

Dec  1 12:26:21 lunos weewx[791] INFO weewx.manager: Added record 2020-12-01 11:10:00 EST (1606839000) to daily summary in 'weewx.sdb'

Dec  1 12:26:21 lunos weewx[791] INFO weewx.restx: PWSWeather: Published record 2020-12-01 11:05:00 EST (1606838700)

Dec  1 12:26:21 lunos weewx[791] INFO weewx.manager: Added record 2020-12-01 11:15:00 EST (1606839300) to database 'weewx.sdb'

Dec  1 12:26:21 lunos weewx[791] INFO weewx.manager: Added record 2020-12-01 11:15:00 EST (1606839300) to daily summary in 'weewx.sdb'

Dec  1 12:26:21 lunos weewx[791] INFO weewx.restx: PWSWeather: Published record 2020-12-01 11:10:00 EST (1606839000)

Dec  1 12:26:22 lunos weewx[791] INFO user.forecast: WUThread: WU: download forecast from 'https://api.weather.com//v3/wx/forecast/daily/5day?geocode=44.09999,-69.58985&format=json&units=e&language=en-US&apiKey=[redacted]'

Dec  1 12:26:22 lunos weewx[791] INFO weewx.restx: PWSWeather: Published record 2020-12-01 11:15:00 EST (1606839300)

Dec  1 12:26:22 lunos weewx[791] INFO weewx.manager: Added record 2020-12-01 11:20:00 EST (1606839600) to database 'weewx.sdb'

Dec  1 12:26:22 lunos weewx[791] INFO weewx.manager: Added record 2020-12-01 11:20:00 EST (1606839600) to daily summary in 'weewx.sdb'

Dec  1 12:26:26 lunos weewx[791] INFO user.forecast: WUThread: WU: download forecast from 'https://api.weather.com//v3/wx/forecast/daily/5day?geocode=44.09999,-69.58985&format=json&units=e&language=en-US&apiKey=[redacted]'

Dec  1 12:26:26 lunos weewx[791] INFO weewx.manager: Added record 2020-12-01 11:25:00 EST (1606839900) to database 'weewx.sdb'

Dec  1 12:26:26 lunos weewx[791] INFO weewx.manager: Added record 2020-12-01 11:25:00 EST (1606839900) to daily summary in 'weewx.sdb'

Dec  1 12:26:27 lunos weewx[791] INFO weewx.restx: PWSWeather: Published record 2020-12-01 11:20:00 EST (1606839600)

Dec  1 12:26:27 lunos weewx[791] INFO weewx.manager: Added record 2020-12-01 11:30:00 EST (1606840200) to database 'weewx.sdb'

Dec  1 12:26:27 lunos weewx[791] INFO weewx.manager: Added record 2020-12-01 11:30:00 EST (1606840200) to daily summary in 'weewx.sdb'

Dec  1 12:26:27 lunos weewx[791] INFO weewx.restx: PWSWeather: Published record 2020-12-01 11:25:00 EST (1606839900)

Dec  1 12:26:27 lunos weewx[791] INFO weewx.manager: Added record 2020-12-01 11:35:00 EST (1606840500) to database 'weewx.sdb'

Dec  1 12:26:27 lunos weewx[791] INFO weewx.manager: Added record 2020-12-01 11:35:00 EST (1606840500) to daily summary in 'weewx.sdb'

Dec  1 12:26:27 lunos weewx[791] INFO weewx.restx: PWSWeather: Published record 2020-12-01 11:30:00 EST (1606840200)

Dec  1 12:26:27 lunos weewx[791] INFO user.forecast: WUThread: WU: download forecast from 'https://api.weather.com//v3/wx/forecast/daily/5day?geocode=44.09999,-69.58985&format=json&units=e&language=en-US&apiKey=[redacted]'

Dec  1 12:26:27 lunos weewx[791] INFO weewx.manager: Added record 2020-12-01 11:40:00 EST (1606840800) to database 'weewx.sdb'

Dec  1 12:26:27 lunos weewx[791] INFO weewx.manager: Added record 2020-12-01 11:40:00 EST (1606840800) to daily summary in 'weewx.sdb'

Dec  1 12:26:27 lunos weewx[791] INFO weewx.restx: PWSWeather: Published record 2020-12-01 11:35:00 EST (1606840500)

Dec  1 12:26:27 lunos weewx[791] INFO weewx.engine: Garbage collected 413 objects in 0.03 seconds

Dec  1 12:26:27 lunos weewx[791] INFO weewx.restx: PWSWeather: Published record 2020-12-01 11:40:00 EST (1606840800)

Dec  1 12:26:27 lunos weewx[791] INFO weewx.engine: Clock error is -57959.95 seconds (positive is fast)

Dec  1 12:26:28 lunos weewx[791] INFO weewx.drivers.vantage: Clock set to 2020-12-01 12:26:28 EST (1606843588)

Dec  1 12:26:30 lunos weewx[791] INFO weewx.restx: Wunderground-RF: Published record 2020-12-01 12:26:30 EST (1606843590)

Dec  1 12:26:30 lunos weewx[791] INFO weewx.restx: Wunderground-RF: Published record 2020-12-01 12:26:30 EST (1606843590)

Dec  1 12:26:33 lunos weewx[791] INFO weewx.cheetahgenerator: Generated 8 files for report SeasonsReport in 5.36 seconds

Dec  1 12:26:39 lunos weewx[791] INFO weewx.restx: Wunderground-RF: Published record 2020-12-01 12:26:40 EST (1606843600)

Dec  1 12:26:40 lunos weewx[791] INFO weewx.restx: Wunderground-RF: Published record 2020-12-01 12:26:41 EST (1606843601)

Dec  1 12:26:42 lunos weewx[791] INFO weewx.restx: Wunderground-RF: Published record 2020-12-01 12:26:43 EST (1606843603)

Dec  1 12:26:45 lunos weewx[791] INFO weewx.restx: Wunderground-RF: Published record 2020-12-01 12:26:45 EST (1606843605)

Dec  1 12:26:46 lunos weewx[791] INFO weewx.restx: Wunderground-RF: Published record 2020-12-01 12:26:47 EST (1606843607)

Dec  1 12:26:48 lunos weewx[791] INFO weewx.restx: Wunderground-RF: Published record 2020-12-01 12:26:49 EST (1606843609)

----------------------

Cheers,

-Del

[gjr80]

Hi,

The symptoms you describe sound like a case of corrupt station memory, common enough when a Davis station experiences a power outage. Try working through the Corrupt station memory section of the Troubleshooting Davis stations wiki entry.

Gary

[Del Merritt]

Gary: thanks. After some more reading I tried a "deep" power cycle (didn't help) and finally did a wee_device --dump followed by a wee_devive --clear-memory; the HTML pages are back online.

First time I recall this happening, and nice to have a responsive community.

Cheers,

-Del

--
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/e25488fd-2949-49a4-bbe3-4674cb298de7n%40googlegroups.com.