Whoops. Someone who really knows crossposted at the same time I did. Happy to see my advice was good! phil
On Tuesday, December 11, 2018 at 8:04:57 PM UTC-5, [email protected] wrote: > > 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.
