For more than a year I have been successfully running weewx on a Pi with
a Vantage Pro system. My data posts to CWOP and to a remote FTP server.
I am currently running v4.1.0. The only extension I have is
deleteVantageWindDir.py.
Recently, power was interrupted to the Pi. Since then, the SQLite
database will not update, CWOP does not update, and stale data from just
before the power loss is uploaded to the FTP server at the specified
interval.
I can open and edit the crashed database (/var/lib/weewx/weewx.sdb)
using DB Browser. The last two data points on the last record are null
(txBatteryStatus and consBatteryVoltage) whereas they normally have
values. The daily summaries for those two points are similarly missing.
If anything else is corrupt or missing, it is not obvious to me.
I have:
1) Deleted the crashed database. Result: a new database gets built
with data stored in the Vantage datalogger. Weewx runs normally with
updates made to CWOP and the remote FTP server. But missing of course
is the data from the past year+.
2) Deleted the last record of the crashed .sdb and restarted weewx.
Result 1: If I do not also update the lastUpdate time value in the
archive_day__metadata table, weewx.manager throws a time mismatch error
and exits. Result 2: If I do update the lastUpdate to match the
timestamp of last record, weewx starts but does not backfill any new
data since the crash, nor does it fetch current data. CWOP does not
update and stale data is FTPd to the server.
3) Deleted the last record, changed lastUpdate to match, deleted all
the daily summary tables in the .sdb, and restarted weewx. Result: the
daily summaries get rebuilt, but the database does not backfill with new
data since the crash, nor does it fetch current data. CWOP does not
update and stale data is FTPd to the server.
4) Run weewx_database --check-strings. No errors were found.
What in the crashed .sdb could be causing weewx to stall?
Thanks,
Derek
--
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/0076d944-4307-309a-8ce0-ec7e2e33668d%40gmail.com.
