Is the DB Keepalive configurable?

[Jesse]

I found this article :

Database connection keep alive

Symptom I often see error message such as Communications link failure for saved questions. However after refresh the page, everything went back to normal. If I check the page again after a while (e.g. an hour), the error is back again. A reasonable assumption is that I have a Metabase instance connecting to MySQL via a proxy, which drops idle connections. Proposal Perhaps we can use a connection pool and/or some kind of keep alive query for unstable connections?

.. is the timeout described here configurable? I need to lower mine to 60 seconds if at all possible.

[sameer]

Not at the moment. Are your connections being dropped by a proxy or the DB itself?

[Jesse]

The DB.

[Jesse]

Ah, the beauty of open source. I just finished recompiling it w/ the value changed.

[sameer]

Glad you got it sorted.

I’m doing a bit of reading, and trying to figure out a sane value for this. Noted some thoughts in https://github.com/metabase/metabase/issues/4077 . Feel free to comment there as well =)

[andrea]

I think I have the same issue, but connection is being dropped by haproxy. Any hint on sane timeout config settings for haproxy with Metabase?