Ruby on Rails Thursday, February 16, 2017
I'm trying to set-up a remote database for my Rails application (mysql-server running on separate VM). My host (Azure) has an idle-timeout setting of 4 minutes on all TCP connections. Because of that, if a Rails process is idle for more than 4 minutes, the connection hangs. The process holding the connection (Unicorn, Sidekiq) also hangs.
The backtrace shows that the process is stuck at ping -
activerecord-5.0.0/lib/active_record/connection_adapters/mysql2_adapter.rb:94:in `ping'activerecord-5.0.0/lib/active_record/connection_adapters/mysql2_adapter.rb:94:in `active?'activerecord-5.0.0/lib/active_record/connection_adapters/abstract_adapter.rb:400:in `verify!'activerecord-5.0.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:770:in `block in checkout_and_verify'
For now I have implemented a sort of heat-beat that keeps the Unicorns/Sidekiq connections alive, but I feel its fragile. I wonder if there is a way here to tell from the Rails side that the connection has gone? Or may be apply some kind of timeout on ping itself ?
Please share any ideas or suggestions this.
Thanks in advance,
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to email@example.com.
To post to this group, send email to firstname.lastname@example.org.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAC-WG37GSoq3z_Fgo96HHs%2BUQkD2hG%2Bj%2BgwveM0vWYtS6PwVbw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
Posted by Ruby on Rails at 12:13 AM