Dave, Good that it was fixed, given the database was somehow corrupted there was probably something in there to do with the daily summaries was upsetting weeWX. Fortunately --reconfigure did the trick otherwise it was going to get messy.
You are also fortunate that you have a station that logs records and allows downloading later, that helps prevent data loss. Of course having an effective database backup strategy in place is important and as you have just found out knowing that you can recover from your backups is equally as important. Not sure what approach you have taken, but some folks in the past have had some issues when they were copying their .sdb file whilst weeWX was still running. One of the strengths of SQLite is having everything in a single file, it makes backups very easy but that is also its Achilles heel; SQLite doesn't like sharing access to the file. You might want to do a bit of googling of the forums regards backups to see some of the approaches used. I used to take a precisely scheduled copy of the .sdb when weeWX was unlikely to be using it and never had a bad backup. I have since moved on to using MySQL/MariaDB and now just dump the database to file. Backups are really horses for courses. Gary On Wednesday, 12 December 2018 12:59:35 UTC+10, Dave Harper wrote: > > Gary - I am in your debt. The --reconfigure option seems to have done the > trick. It took a while to generate the new file but, once it was done, > weeWX was able to accept the database. It then spend another large chunk > of time rebuilding the daily summaries and, once that was done, it started > downloading the updates from my console. It has loaded almost 7 hours > worth and has about 3 more to go but everything seems to be going smoothly > and there is no reason to think it won't finish normally at this point. > I've been running on a dedicated Raspberry Pi and a while back, in > anticipation of this crash, I built another Pi that boots from a 250GB hard > drive and installed everything on that. Now that I have a working database > again, I will be switching over to that one tomorrow and implementing > another level of backups in addition to the NAS I have now. I really > appreciate the time you've spent helping me get up and going again. > > Regards, > 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 weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
