Switch to Rails.application.executor

[reidmorrison]

RocketJob currently uses ::ActiveRecord::Base.clear_active_connections! to clear out database connections.
Rails has moved to Rails.application.executor, see https://guides.rubyonrails.org/threading_and_code_execution.html.

This should resolve the issue where a db connection is rendered unusable if for example a connection timeout or other connection failure occurs.

@sudheer-meka would you like to give it a try? Sounds like a promising solution to the db connection failure issues.

[sudheer-meka]

Sure Reid, Let me try this. Thank you 🙏

…

On Mon, Aug 14, 2023, 18:45 Reid Morrison ***@***.***> wrote: RocketJob currently uses ::ActiveRecord::Base.clear_active_connections! to clear out database connections. Rails has moved to Rails.application.executor, see https://guides.rubyonrails.org/threading_and_code_execution.html. This should resolve the issue where a db connection is rendered unusable if for example a connection timeout or other connection failure. @sudheer-meka <https://github.com/sudheer-meka> would you like to give it a try? Sounds like a promising solution to the db connection error issues. — Reply to this email directly, view it on GitHub <#35>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABUSHEHR4NL4HSYE7GNOWO3XVIQHPANCNFSM6AAAAAA3PVY7HE> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[reidmorrison]

Also found this database.yml config option that may work with C Ruby with Postgres:

reaping_frequency: 10

[sudheer-meka]

Yea, we have already added this. Which is giving us better results.

…

On Thu, Oct 19, 2023, 01:37 Reid Morrison ***@***.***> wrote: Also found this config option that may work with C Ruby: — Reply to this email directly, view it on GitHub <#35 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABUSHEH6YMB5U7KPC2WHX4TYAAZGVAVCNFSM6AAAAAA3PVY7HGVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM3TGMJZGYYTS> . You are receiving this because you were mentioned.Message ID: ***@***.***>