ruby-mysql2: MySQL server has gone away

Question

ruby

There is a daemon written in ruby ​​using the mysql2 gem, which sometimes receives a message from AMQP and writes to the database.

When idle for a long time, MySQL closes the connection by timeout and when you try to execute the query, the exception 'MySQL server has gone away' is thrown. Google issues a solution for ActiveRecord, nothing about mysql2. I did not find anything suitable in the methods of the Mysql2::Client class, the :reconnect => true option does not help.

How to check the connection before executing the request and if it is closed, then raise it again?

Answer 1

I don't know shit, but in mysql connectors you can usually check with the Ping function.

Answer 2

Catch the exception and do Client.new again.