search

nguyenquanghai1993 / openhab

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

MySQL-Connection lost #422

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
The Issue takes places _sometimes_ when configurations are being reloaded, for 
instance when .items changed.

I have seen this Issue since #445(?), forgot to mention it. I use MySQL-Binding 
since #445(?), so it happened at all versions, currently 

openHAB-1.3.0-463, Debian Wheezy Linux (virtualized) with Oracle JRE 7u25 64bit

As a workaround, an automatic reconnection would be nice, instead of only 
writing an Error-Message ;-)

Original issue reported on code.google.com by udo1t...@gmail.com on 23 Aug 2013 at 2:16

GoogleCodeExporter commented 8 years ago 
I'm currently changing the SQL service to add the string support. I've also 
added a "reconnect counter". This counts up each time there's an error thrown, 
and is set to 0 each time there's a successful transaction. If the counter hits 
a set number, then the database disconnects, and will reconnect next time 
there's a transaction.

The level at which the reconnect occurs is set in the openhab.cfg file with 
reconnectCnt. It defaults to 0 (no reconnect).

I don't have a problem with disconnects, so I can't easily test this works, but 
the function is implemented (and it doesn't cause any problems)...

Original comment by ch...@cd-jackson.com on 15 Sep 2013 at 7:55

GoogleCodeExporter commented 8 years ago 
I was just wondering if this was improved at all with the latest binding?

Original comment by ch...@cd-jackson.com on 3 Oct 2013 at 1:07

GoogleCodeExporter commented 8 years ago

Original comment by teichsta on 5 Nov 2013 at 10:53

GoogleCodeExporter commented 8 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:08

GoogleCodeExporter commented 8 years ago 
see above!

Issue has been migrated to Github and should be discussed there.

Original comment by teichsta on 21 Nov 2013 at 1:51