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 < [email protected]> wrote: > 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 program on power restoral Had the local /var/www/html page was a > wrong date and the FTP'd page sent to my web site also had a corrupt > date/Time string and neither agreed nor were either at all real cuurent > time accurate. > > I shut down the PC with the intent of looking for a mySQL dB > troubleshooting/repair software application and attempting to correct > the corrupted data when I had time. About a week later I found time to > take a look at the problem and when I restated the PC , with the intent > of halting weewx to troubleshooting the dB. It all came back working > normally but with no back archived data available but it appears the > delay from it being down so long allowed it to restart and regenerate > the consistent web pages and messages. > > So although it is back working now, I would like to know if their is a > recommended dB software /data repair/maintenance package available that > is open source freeware either standalone program or possibly something > like a plug option/package to use with a browser similar to phpmyadmin. > > My 2nd takeaway is when urgent commercial power fails get to the weewx > PC and shut it down immediately in an orderly fashion before the 8-10 > min UPS backup support runs out. > > Any pointers are welcome, considering so many outside agancies use the > data (eg AWEKAS, CWOP/NOAA/aprs/ WeatherUnderground in addition to my on > local and www page. > > Thanks 73 > > Andy > > > -- > 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]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/31c1e793-4db7-672c-ffc0-01361e7aec82%40gmail.com > . > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEDqJCB-hn39gPTFqVUg%3DRmerrsqAFWqDLx6%2Bxxztq%3DYQg%40mail.gmail.com.
