Mysql connection dropouts

[GoogleCodeExporter]

My data logger is connecting to a remote MySQL database.. Every few days the 
data logger crashes with the error message "MySQL gone away".

Any chance of putting some connection error handling so that it cleanly retries 
to connect to MySQL?

Cheers

Original issue reported on code.google.com by sloth...@gmail.com on 25 Jul 2012 at 5:26

[GoogleCodeExporter]

Me too ....  :)

I am working on it. Meanwhile you can try to increase the wait timeout setting 
from mysql in your my.cnf
wait_timeout= xxx

Try the ideal setting for your installation. Here you will found more 
informations:
https://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_wait
_timeout

The next version from the grabber will handle this and other problems and if 
possible it will send emails to warn if this is for a longer time.

Original comment by lalelu...@gmail.com on 27 Jul 2012 at 4:31

• Changed state: Started

[GoogleCodeExporter]

You can try out this new version from the grabber script that reconnect to the 
database and send you emails if the database is a longer time away

https://code.google.com/p/measureit/source/browse/trunk/measureit_system_files/p
ython/data-input.py

new folder
https://code.google.com/p/measureit/source/browse/trunk/measureit_system_files/p
ython/simplemail
https://code.google.com/p/measureit/source/browse/trunk/measureit_system_files/p
ython/simplemail/__init__.py

Please give me some feedback if this will help

Original comment by lalelu...@gmail.com on 30 Jul 2012 at 3:44

[GoogleCodeExporter]

Doesn't work for me.

TypeError: 'reconnect' is an invalid keyword argument for this function

Original comment by sloth...@gmail.com on 3 Aug 2012 at 12:44

[GoogleCodeExporter]

sorry, but after 30min of tests.. the new data-input.py do not recieve any 
datas :'( (i tested with debug=True)
i switched several time from the original script (112) to the trunk ... 

with the 112 :

<msg><src>CC128-v1.29</src><dsb>00534</dsb><time>01:51:28</time><tmpr>20.1</tmpr
><sensor>0</sensor><id>00077</id><type>1</type><ch1><watts>02473</watts></ch1></
msg>

<msg><src>CC128-v1.29</src><dsb>00534</dsb><time>01:51:35</time><tmpr>20.1</tmpr
><sensor>0</sensor><id>00077</id><type>1</type><ch1><watts>02535</watts></ch1></
msg>

<msg><src>CC128-v1.29</src><dsb>00534</dsb><time>01:51:41</time><tmpr>20.1</tmpr
><sensor>0</sensor><id>00077</id><type>1</type><ch1><watts>03846</watts></ch1></
msg>

<msg><src>CC128-v1.29</src><dsb>00534</dsb><time>01:52:07</time><tmpr>20.1</tmpr
><sensor>0</sensor><id>00077</id><type>1</type><ch1><watts>02453</watts></ch1></
msg>

with trunk:

nothing is displayed

Original comment by smaucourt on 29 Dec 2012 at 1:31

[GoogleCodeExporter]

i tried this script because after several hours (36hours last time), the datas 
are not updated. So I watch if the script is allready launched (the first time 
no, the last time yes). after a kill and a launch, everything is going good.
my mysql server is hosted on localhost.

Original comment by smaucourt on 29 Dec 2012 at 1:36

[GoogleCodeExporter]

Oops my mistake ttyUSB1 for me 

Original comment by smaucourt on 29 Dec 2012 at 9:24

[GoogleCodeExporter]

Mysql connection problems are solved in version 113 you will found in the 
downloads

Original comment by lalelu...@gmail.com on 17 Feb 2013 at 12:50

• Changed state: Done