Re: [weewx-user] howto fix weewx sqlite database

done and working thx tke...@gmail.com schrieb am Sonntag, 24. Juli 2022 um 13:18:53 UTC+2: > See the wiki article Cleaning up old "bad" data > , in > particular, the section *Deleting unwanted records >

Re: [weewx-user] howto fix weewx sqlite database

See the wiki article Cleaning up old "bad" data , in particular, the section *Deleting unwanted records * . On Sun, Jul 24, 2022 at 1:53 AM

Re: [weewx-user] howto fix weewx sqlite database

great, it worked. my linux-computer was working for hours for only 60MB of data, but database is readable by weewx. a single gap is now that the NOAA-files are created from up 1988 and, of course, empty. The station has started in 2019. Is there a way to fix it? regards Oscar schrieb am

Re: [weewx-user] howto fix weewx sqlite database

The database is corrupt. Could be caused by a bad SD card, losing power during a write, a number of reasons. I've been able to use this process to recover most of a corrupt data base. With 5 years of data, the recreate process will take a long time (days(?)) on a pi. I recommend coping the

Re: [weewx-user] howto fix weewx sqlite database

It is very unlikely that the size of the database is a problem. Like Graham, I have over 15 years of data on mine without a problem. You did not say what kind of storage you are using, but if it is an old SD card, it is much more likely that the card is corrupt. You may be able to recover the

Re: [weewx-user] howto fix weewx sqlite database

here it is: Sun Jul 10 19:25:39 2022 user.debug weewx[2812] DEBUG weewx.restx: Shut down StationRegistry thread. Sun Jul 10 19:25:39 2022 user.crit weewx[2812] CRITICAL __main__: Caught unrecoverable exception: Sun Jul 10 19:25:39 2022 user.crit weewx[2812] CRITICAL __main__: database

Re: [weewx-user] howto fix weewx sqlite database

What error messages are you getting? On Sun, Jul 10, 2022 at 8:00 AM Graham Eddy wrote: > 15 years of data, running happily on RPi 4B: > > *graham@paperbark*:*/home/weewx/archive $* ls -l weewx.sdb > -rw-r--r-- 1 weewx weewx 175935488 Jul 11 00:55 weewx.sdb > > > On 11 Jul 2022, at 12:43 am,

Re: [weewx-user] howto fix weewx sqlite database

15 years of data, running happily on RPi 4B: graham@paperbark:/home/weewx/archive $ ls -l weewx.sdb -rw-r--r-- 1 weewx weewx 175935488 Jul 11 00:55 weewx.sdb > On 11 Jul 2022, at 12:43 am, Fische Namenlos wrote: > > my station is using sqlite database (weewx.sdb) for nearly 5 years, and now -

[weewx-user] howto fix weewx sqlite database

Dear, my station is using sqlite database (weewx.sdb) for nearly 5 years, and now - I suppose - is getting to big for my Raspi-server, it stops working/writting. Howto fix or customize in weewx 4.8.0 to split this database, maybe yearly and howto "tell" weewx howto search historical data in