I'll start with your suggestions for setting the timeout and see where that gets me. I'm guessing there's a corresponding timeout setting on the postgres side that I should also investigate and set as well, so I'll look for that as well.
Thanks, Michael On Fri, Nov 1, 2013 at 1:33 PM, Jeremy Evans <[email protected]> wrote: > 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. > -- http://cybrains.net -- 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.
