postgresql - Heroku + Rails + PG: ActiveRecord::StatementInvalid (PG::ConnectionBad: PQconsumeInput() SSL connection has been closed unexpectedly -

postgresql - Heroku + Rails + PG: ActiveRecord::StatementInvalid (PG::ConnectionBad: PQconsumeInput() SSL connection has been closed unexpectedly -

i receiving randomly , next error in logs:

nov 06 05:31:21 lmrapp app/web.2: [wbinternacional] [0f0965e3-e537-4aed-8f3e-311a222e8fa1] pg::connectionbad: pqconsumeinput() ssl connection has been closed unexpectedly nov 06 05:31:21 lmrapp app/web.2: [wbinternacional] [0f0965e3-e537-4aed-8f3e-311a222e8fa1] completed 500 internal server error in 23ms nov 06 05:31:21 lmrapp app/web.2: fatal: terminating connection due administrator command nov 06 05:31:21 lmrapp app/web.2: activerecord::statementinvalid (pg::connectionbad: pqconsumeinput() ssl connection has been closed unexpectedly

could due connection limit of pg plan on heroku (i have "hobby-basic" have 20 connections)?

thanks

i'm getting exact same error. on heroku hobby-basic db. raised ticket heroku, here response:

the "ssl connection has been closed unexpectedly" error (and few similar ones) client-side error indicating database connection has gone away. 1 of limitations of hobby tier databases unannounced maintenance. need close connections hobby tier databases, , when that, app see error one.

most apps maintain connection pool (like activerecord in rails) can open new connection database. however, in cases app won't able reconnect. if happens, can heroku restart dyno new process on new runtime.

running hobby tier databases in production isn't recommended. if you're going to, though, it's helpful configure app crash on repeated database connection errors—that way, start on new runtime new connection pool automatically.

it looks has been happening lot you, though; int case, i'd recommend pgbackups:transfer move database shared server. maintain in mind hobby tier rules apply $9 basic plan free database. allow me know if have farther questions. thanks!

to me means heroku doesn't care prepare error , wants upgrade $50 database. i'm running little site 4-5 users/day - there no way want switch production site of yet. getting same error mentioned @ to the lowest degree 5-6 times/day , still haven't figured out way prepare this. seek switching db shared server - not work me.

ruby-on-rails postgresql activerecord ssl heroku