Pg connection time out error

Rails
1

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

2

On Mon, Apr 8, 2013 at 11:42 AM, Loganathan S.
<[email protected]

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.

3

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