I'm not a database nor a weewx expert. But I'd try using the wee_database utility trying first the --rebuild-daily option first (you could limit it to only today). If that fails, I'd then do a wee_database --drop-daily followed by a wee_database --rebuild-daily. See the Utlilities Guide on this: http://weewx.com/docs/utilities.htm#wee_database_utility. Make sure to stop weewx before using these commands and keep a backup of the database if my advice hoses it :-). phil
On Tuesday, December 11, 2018 at 7:03:48 PM UTC-5, Dave Harper wrote: > > Over the past year I've had numerous cases of a corrupted database. I > learned early on to have a good backup scheme in place and it has served me > well - up until today. After I noticed that the web page was no longer > updating I checked the /var/sys/logfile and found the message > "DatabaseError: database disk image is malformed". Shortly after that I > discovered my backups for the past month were not working, so I've been > faced with trying to repair the weewx.sdb file. I've found several posts > describing how to recover from problems like this and ended up using the > repairsdb.sh script that I found in one of them. That fixed the > "malformed" error and I am now able to load the database but when weewx > starts it now aborts with the error that "table archive_day_barometer > already exists". I had never used sqlite3 prior to weewx and am not really > familiar with what to try now. Anybody have any ideas I can try? > > Thanks > Dave > -- 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.
