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 right during a data update cycle from the sensors somehow
the whole transaction became so confused that the local page in the
/var/www/html folder did not have a correct date time string on it; and
a simmilar problem happened to the report generated for transfer via ftp
to my personal web page. and neither of these agreed with each other.
and neither was the actual time of the data update. Successive updates
or page reloads/refreshes displayed these same frozen data pages. Once
the system shut down for a week and restarted it began with no existing
archive data showing on any graphs but current display data from sensors
properly processed and updated properly every 5 mins approx.
On 2022-06-27 18:01, Tom Keffer wrote:
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]
<mailto:weewx-user%[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
<https://groups.google.com/d/msgid/weewx-user/CAPq0zEDqJCB-hn39gPTFqVUg%3DRmerrsqAFWqDLx6%2Bxxztq%3DYQg%40mail.gmail.com?utm_medium=email&utm_source=footer>.
--
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/d41ca5ad-25b7-86f2-6e77-c049bb0c34e6%40gmail.com.
