Re: [weewx-user] weewx sql database repair tools

2022-06-28 Thread VE4PER Andy
Thanks Doug I will check into this further; I had always used APC UPS's but of late units don't come with acceess to detailed logging details wrt short surge type failures any more. I used to be able to get timing messages from that log that helped in troubleshooting. I have slowly changed to

Re: [weewx-user] weewx sql database repair tools

2022-06-28 Thread VE4PER Andy
I am not exactly sure what occurred which is why I was looking for a tool to inspect it deeper. Only thing I know for sure was that UPS backup was so run down and deteriorated that the commercial power slamming off and on in rapid succession was passed through to the PC and if it occurred

Re: [weewx-user] weewx sql database repair tools

2022-06-27 Thread Greg Troxel
Tom Keffer writes: > Not clear what you're asking, but I'd like to know more about the > corruption of the database. I spent a lot of time making sure that commits > were atomic. Did I miss something? Could you be more specific about what's > wrong with the database? I am assuming you mean

Re: [weewx-user] weewx sql database repair tools

2022-06-27 Thread Tom Keffer
Not clear what you're asking, but I'd like to know more about the corruption of the database. I spent a lot of time making sure that commits were atomic. Did I miss something? Could you be more specific about what's wrong with the database? On Mon, Jun 27, 2022 at 2:32 PM VE4PER Andy <

Re: [weewx-user] weewx sql database repair tools

2022-06-27 Thread Doug Jenkins
Andy: I use dbeaver (dbeaver.io) to manage all my databases. It is a client tool, but it connects to MariaDB, MySQL, and SQLite databases. You can manage the database here. For your power problem, I would suggest NUT (Network UPS Tool). This can run as a service on your linux server (Including

[weewx-user] weewx sql database repair tools

2022-06-27 Thread VE4PER Andy
I had a major commercial power failure about 10 days ago. In the process it ran the UPS down almost completely such that when the last few power surge/bumps/fails occured something in the date time pointer system , I believe in the SQL databse became disconnected and immediate restart of the