Hi All, I am frequently getting Pg Connection timeout error in my application. I tried to fix it by upgrading the system memory, also updated the pg gem but the issue is still occurring. Anybody''s help will be really appreciated. *(ActiveRecord::StatementInvalid) "PGError: server closed the connection unexpectedly\n\tThis probably means the server terminated abnormally\n\tbefore or while processing the request.\n: BEGIN"* regards, Loganathan Mob: +91 7760780741 | +91 9944414388 Skype: loganathan.sellappa ViewMe <http://vizualize.me/loganathan> -- 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 rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
On Mon, Apr 8, 2013 at 11:42 AM, Loganathan Sellapa <loganathan.ms-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> I am frequently getting Pg Connection timeout error in my application. I > tried to fix it by upgrading the system memory, also updated the pg gem but > the issue is still occurring. Anybody''s help will be really appreciated. > > *(ActiveRecord::StatementInvalid) "PGError: server closed the connection > unexpectedly\n\tThis probably means the server terminated > abnormally\n\tbefore or while processing the request.\n: BEGIN"* >This is a problem with your PostgreSQL server. You either have abnormally high latency that your PG server is unforgiving of or somebody misconfigured it, I would contact whoever manages your databases. -- 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 rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
Hi Jordon, Yes, I already contacted my DBA and he also did something by upgrading the PG server version from 8.x to 9.x and increased the VM''s memory but no luck. regards, Loganathan Mob: +91 7760780741 | +91 9944414388 Skype: loganathan.sellappa ViewMe <http://vizualize.me/loganathan> On Mon, Apr 8, 2013 at 10:19 PM, Jordon Bedwell <envygeeks-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> On Mon, Apr 8, 2013 at 11:42 AM, Loganathan Sellapa < > loganathan.ms-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > >> I am frequently getting Pg Connection timeout error in my application. I >> tried to fix it by upgrading the system memory, also updated the pg gem but >> the issue is still occurring. Anybody''s help will be really appreciated. >> >> *(ActiveRecord::StatementInvalid) "PGError: server closed the connection >> unexpectedly\n\tThis probably means the server terminated >> abnormally\n\tbefore or while processing the request.\n: BEGIN"* >> > > This is a problem with your PostgreSQL server. You either have abnormally > high latency that your PG server is unforgiving of or somebody > misconfigured it, I would contact whoever manages your databases. > > -- > 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 rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > For more options, visit https://groups.google.com/groups/opt_out. > > >-- 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 rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.