Rails ActiveRecord/Postgres single query timeout?

Question

I have a logging query (a simple INSERT) that happens on every single request.

For this request only (the one that happens on every page load), I want to set the limit to 500ms in case the database is locked/slow/down it won't affect the site, where the site hangs while it waits to connect/write.

Is there a way I can specify a timeout somehow on a per-query basis that I can abort the LoggedRequest.create! if it's taking too long?

I don't want to set it in my config because I have many other queries that shouldn't have timeouts that low.

I'm using Postgres 11.7

I also don't know how I feel about setting a timeout for the entire session because I don't want that connection to be shared from the pool with other queries that can't have that timeout.

mansoor.khan · Accepted Answer · 2020-05-10 21:03:42Z

1

Rails 6 introduces event based triggers for notifications, logging etc that comes in very handy, provided you are using/can afford to migrate to Rails 6. Here'a useful post that demonstrates creating event based triggers for notifications/logging: https://pramodbshinde.wordpress.com/2020/03/20/custom-events-tracking-with-activesupportnotifications-and-audited/

If, for some reason, you cannot use Rails 6, perhaps this article might help you find some answers: https://evilmartians.com/chronicles/the-silence-of-the-ruby-exceptions-a-rails-postgresql-database-transaction-thriller

If I were you, I could also contemplate using AJAX with a fire-and-forget API request to server for logging/whatever that is not critical to normal functioning of the application.

answered May 10, 2020 at 21:03

mansoor.khan

2,66629 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tallboy Over a year ago

What technology does this use behind the scenes?

mansoor.khan Over a year ago

It's more or less a pub/sub model FWIU. I need to dig deep into it to understand the science behind it.

Collectives™ on Stack Overflow

Rails ActiveRecord/Postgres single query timeout?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related