google-code-export / openhab

Automatically exported from code.google.com/p/openhab
GNU General Public License v3.0
0 stars 0 forks source link

MySQL Connection Timeout? #514

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
I use openHAB version 1.4.0 on a Raspberry Pi. (since a few days)
Mysql.persist send Item.States to the MySQL Database on my Webspace Hoster.
If the interval in mysql.persist is  less than 2 minutes everything works fine.
The Item state is visible in the Database Table "Item2".
But if the interval is more than 2 minutes the Error Message:
mySQL: Could not store item 'LeistungMittel' in database with statement 'INSERT 
INTO Item2 (TIME, VALUE) VALUES(NOW(),'1112');': Communications link failure

I think there is a timeout / reconnection problem. A look at the MySQL 
variables  "wait timeout" shows 120.

Original issue reported on code.google.com by lummi.4b...@gmail.com on 13 Nov 2013 at 8:51

GoogleCodeExporter commented 9 years ago

Original comment by teichsta on 17 Nov 2013 at 6:43

GoogleCodeExporter commented 9 years ago
This issue has been migrated to Github. If this issue id is greater than103 its 
id has been preserved on Github. You can open your issue by calling the URL 
https://github.com/openhab/openhab/issues/<issueid>. Issues with ids less or 
equal 103 new ids were created.

Original comment by teichsta on 17 Nov 2013 at 8:09

GoogleCodeExporter commented 9 years ago
Set status to "invalid" to show that these issues are not tracked here anymore 
- please refer to GitHub instead!

Original comment by kai.openhab on 2 Dec 2013 at 7:12