Hello, I faced the same problem once or twice in the past, even with both
weewx and mysql on the same host. In all cases I could point to the culprit
on me. I had updated mysql or restarted altogether the host just at the
time weewx wanted to insert new records. In both cases I had to stop and
restart weewx, with no data lost.
Paul
On Wednesday, May 31, 2017 at 4:22:16 AM UTC+2, Louis De Lange wrote:
>
> While there seem to be great excitement for the new meteotemplate
> uploader, I previously wrote a service that updates my meteotemplate
> database directly without an intermediate php script. In the service i use
> a ."getSql("INSERT INTO" statement. This works really well and I even
> resolved the dayrain issue that is now being discussed on another thread.
>
> There is one annoying bug and I dont know how to solve it. My
> meteotemplate install is located on a different server than weewx. It can
> sometimes happen that the meteotemplate server is temporarily unavailable.
> To overcome this scenario I use a "try" statement when inserting SQL data,
> so that it will just skip the upload attempt if the MySQL server is not
> available. The bug is that the mysql insert command continue to fail after
> the meteotemplate server becomes available again, and the only way to
> correct it is to restart weewx.
>
> The fail message is "Error (2006, 'MySQL server has gone away')" and it
> continues to be displayed after the meteotemplate server is back on line.
>
> Any ideas how to resolve this will be appreciated.
>
> Louis
>
>
>
--
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].
For more options, visit https://groups.google.com/d/optout.
