Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What's the cause of "PGError: FATAL: terminating connection due to administrator command" on heroku?

I have a rails app on heroku that users log in to. I periodically get this exception:

UserSessionsController# (ActiveRecord::StatementInvalid) "PGError: FATAL: terminating connection due to administrator command\nserver closed the connection unexpectedly\n\tThis probably means the server terminated abnormally\n\tbef...

URL

POST http://secure.huckberry.com/user_sessions 

What's a likely cause of this? I'd appreciate any help.

like image 560
James Avatar asked Apr 26 '11 07:04

James


2 Answers

Assuming you saw this recently, this is due to a recent bit of high-priority maintenance work to enable continuous backups on shared databases -- involving a server restart. You shouldn't worry about this error, provided it does not reproduce. I don't think that's very likely, so happy hacking!

like image 154
fdr Avatar answered Oct 13 '22 07:10

fdr


I had this error happen to me. My Application server had an open connection to the database. In my SSH terminal I added an ipaddress to the ph_hba.conf file and restarted the postgreSQL server.

That is when this error showed up. I refreshed my web page one time and the error was gone.

like image 41
Randy Johnson Avatar answered Oct 13 '22 07:10

Randy Johnson