[weewx-user] Re: MySQL server has gone away
If someone has this 2006, MySQL server has gone away error after the second
archive update (so after 5 minutes), and their first insert after
connecting works. Or maybe if they have a bit of a flaky connection to
their remote server:
for me to solve this I had to set this session variable after connecting
(after setting the isolation level thing in the mysql.py):
self.connection.query("set session wait_timeout=3600")
It turned out that my webhost had this on global setting set to 60 seconds
(check it first), which is too low given my 5 minute archive interval. I
would set it to at least 360 seconds.
Maybe other users out there with the same problem can try and see if it
helps. It is a better solution than re-establishing the connection each
time in this case.
Tom
Op woensdag 31 mei 2017 04:22:16 UTC+2 schreef Louis De Lange:
>
> 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 weewx-user+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[weewx-user] Re: MySQL server has gone away
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 weewx-user+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[weewx-user] Re: MySQL server has gone away
This is not an answer to your question, but, if you have root access to the
database on the remote server, you can create one local to weewx and set up
replication, with the weewx machine db the master and the remote one the
slave.
Then you would just update the local one. The remote db will automatically
keep itself up to date. If it is offline for a while, it will catch up
when it gets back.
On Tuesday, May 30, 2017 at 10:22:16 PM UTC-4, 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 weewx-user+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
