Hi, Quite possible there is nothing wrong with your database and rather you have corrupt station memory as a result of the power loss. The logs will give some clues. You could try the steps under Corrupt station memory <https://github.com/weewx/weewx/wiki/Troubleshooting-the-Davis-Vantage-station#corrupt-station-memory> in the Troubleshooting the Davis Vantage station <https://github.com/weewx/weewx/wiki/Troubleshooting-the-Davis-Vantage-station> wiki entry.
Gary On Saturday, 14 November 2020 at 06:03:13 UTC+10 Derek wrote: > 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/7def5c51-dc3f-4159-b18a-4d309f648a35n%40googlegroups.com.
