MySQL server has gone away

[moneroexamples]

Mysql is dead after a while. Maybe timeing out?

# ERR: SQLException in /home/mwo/openmonero/src/MySqlAccounts.cpp(select) on line 680                                     │2017-03-08 15:17:12.899 [P2P0]  INFO    global  src/cryptonote_protocol/cryptonote_protocol_handler.inl:1090  SYNCHRONIZ
# ERR: MySQL server has gone away                                                                                         │ED OK
# ERR: SQLException in /home/mwo/openmonero/src/MySqlAccounts.cpp(insert) on line 752                                     │2017-03-08 21:14:46.504 [P2P8]  INFO    global  src/cryptonote_core/blockchain.cpp:1420 ----- BLOCK ADDED AS ALTERNATIVE
# ERR: MySQL server has gone away                                                                                         │ ON HEIGHT 1261975
Error getting address:                                                                                                    │id:     <b04acb0d2921c20a838810bf9dc772d54f7eb695a22b2a81eb3d6759ac517010>
Cant parse string address:                                                                                                │PoW:    <5fff4abfb03cdb28ff92f32743c602af67e5839dd88a53749c100b6900000000>
Faild created a search thread 

[moneroexamples]

Relevant section: 3.15. Dealing with Connection Timeouts

• https://tangentsoft.net/mysql++/doc/html/userman/tutorial.html#connopts

You cannot detect this condition by calling Connection::connected(). When that returns true, it just means that either the connect-on-create constructor or the connect() call succeeded and that we haven’t observed the connection to be down since then. When the database server closes an idle connection, you won’t know it until after you try to issue a query. This is simply due to the nature of network programming.

Added this in: d873e58 and will see how it goes.

[moneroexamples]

24h and mysql connection still stending. seems as pinging keeps connection life during idle time.