It's always good when 2 people come back with the same answer :) On Wed, 12 Dec 2018, 14:06 <[email protected] wrote:
> 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. > -- 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.
