On Friday, November 1, 2013 9:03:03 AM UTC-7, Michael Lang wrote:
> I'm still having periodic errors with sending queries to Postgres...First
> thing I did was turn off SSL for Posgres, that simply changed the error
> from previously reported to this:
>
> ERROR - 01/Nov/2013 15:53:02 PG::UnableToSend: : SELECT * FROM "domains"
> WHERE ("uri" = 'sampledomain.com') LIMIT 1
> ERROR - 01/Nov/2013 15:53:02 PG::UnableToSend:
>
> I then activated the connection_validator extensions and have been
> watching the server for about 2 days now and still experiencing the problem
> where the query can't be sent to the server.
>
The default for the connection_validator extension is to only check
connections that have been idle for more than 1 hour. It's possible that
is too long for your environment, you can try:
DB.pool.connection_validation_timeout = -1
to validate connections on every checkout, or some other number of seconds.
However, if the problem is that PostgreSQL is dropping connections while
the connection is checked out, there is not really anything you can do in
Sequel to fix that, other than rescue the error and manually retry it.
That's not safe to do in a general way, you'll have to make sure you are
handling things correctly in each case where you use that approach.
Thanks,
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/groups/opt_out.
