Broken Pipe to Postgres

mfaine · September 18, 2007, 1:33pm

Hi all,

My app was running fine for months, then all of a sudden I keep getting
the following in my production.log, 3 times over the last week, which
kills the app dead until httpd is restarted (on Fedora Core):

Processing Base#index (for xxx.xx.xx.xxx at 2007-09-18 07:44:55) [GET]
Session ID: c37adab9fab32e2ac05d6ea83e74a42e
Parameters: {}

Errno::EPIPE (Broken pipe):
/usr/local/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/connection.rb:86:in
write' /usr/local/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/connection.rb:86:inquery’
/usr/local/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/postgres-compat.rb:33:in
query' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/postgresql_adapter.rb:65:inactive?’
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract_adapter.rb:85:in
verify!' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:99:inverify_active_connections!’
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:98:in
verify_active_connections!' /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/dispatcher.rb:70:inprepare_application’
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/dispatcher.rb:37:in
dispatch' /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/fcgi_handler.rb:150:inprocess_request’
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/fcgi_handler.rb:54:in
process!' /usr/local/lib/ruby/site_ruby/1.8/fcgi.rb:600:ineach_cgi’
/usr/local/lib/ruby/site_ruby/1.8/fcgi.rb:597:in each_cgi' /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/fcgi_handler.rb:53:inprocess!’
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/fcgi_handler.rb:23:in
`process!’
/var/www/vhosts/eco-motors.co.uk/rails/ecomotors/public/dispatch.fcgi:24

Any thoughts?

mfaine · September 18, 2007, 5:26pm

On Tue, 18 Sep 2007 13:33:41 +0200, Mark Fendley wrote:

My app was running fine for months, then all of a sudden I keep getting
the following in my production.log, 3 times over the last week, which
kills the app dead until httpd is restarted (on Fedora Core):

I don’t know the answer to your problem, but: is running edge an option?
There were a whole bunch of Postgres fixes checked in last month; it
might
be worth at least seeing if it solves the issue. (Of course, if it’s
that
intermittent, it’d be hard to know if it’s solved or not.)

–
Jay L. |
Boston, MA | My character doesn’t like it when they
Faster: jay at jay dot fm | cry or shout or hit.
http://www.jay.fm | - Kristoffer

mfaine · June 22, 2008, 8:10pm

HELLO , DID YOU SOLVE THIS PROBLEM ???

WHY THIS ERROR ?

IM WORKING WITH RAILS 2.0 AND POSTGRES 8.3

THIS IS THE RAILS LOG:

Errno::EPIPE

Broken pipe

RAILS_ROOT: /var/BackupIvan/pdf3
Application Trace | Framework Trace | Full Trace

/var/lib/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/connection.rb:86:in
write' /var/lib/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/connection.rb:86:in<<’
/var/lib/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/connection.rb:86:in
query' /var/lib/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/postgres-compat.rb:33:inquery’
/var/lib/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/postgresql_adapter.rb:246:in
active?' /var/lib/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract_adapter.rb:108:inverify!’
/var/lib/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:122:in
verify_active_connections!' /var/lib/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:121:ineach_value’
/var/lib/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:121:in
verify_active_connections!' /var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/rails.rb:76:inprocess’
/var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/rails.rb:74:in
synchronize' /var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/rails.rb:74:inprocess’
/var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:159:in
process_client' /var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:158:ineach’
/var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:158:in
process_client' /var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:285:inrun’
/var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:285:in initialize' /var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:285:innew’
/var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:285:in run' /var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:268:ininitialize’
/var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:268:in new' /var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:268:inrun’
/var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/configurator.rb:282:in
run' /var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/configurator.rb:281:ineach’
/var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/configurator.rb:281:in
run' /var/lib/gems/1.8/gems/mongrel-1.1.4/bin/mongrel_rails:128:inrun’
/var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/command.rb:212:in run' /var/lib/gems/1.8/gems/mongrel-1.1.4/bin/mongrel_rails:281 /var/lib/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:489:inload’
/var/lib/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:489:in
load' /var/lib/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:342:innew_constants_in’
/var/lib/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:489:in
load' /var/lib/gems/1.8/gems/rails-2.0.2/lib/commands/servers/mongrel.rb:64 /var/lib/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:496:inrequire’
/var/lib/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:342:in
new_constants_in' /var/lib/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:496:inrequire’
/var/lib/gems/1.8/gems/rails-2.0.2/lib/commands/server.rb:39

/var/lib/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:146:in
prepare_application' /var/lib/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:178:insend!’
/var/lib/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:178:in
run_callbacks' /var/lib/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:175:ineach’
/var/lib/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:175:in
send!' /var/lib/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:175:inrun_callbacks’
/var/lib/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:114:in
dispatch' /var/lib/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:126:indispatch_cgi’
/var/lib/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:9:in
dispatch' /usr/lib/ruby/1.8/rubygems/custom_require.rb:27:ingem_original_require’
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in require' /usr/lib/ruby/1.8/rubygems/custom_require.rb:27:ingem_original_require’
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `require’
script/server:3

/var/lib/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/connection.rb:86:in
write' /var/lib/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/connection.rb:86:in<<’
/var/lib/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/connection.rb:86:in
query' /var/lib/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/postgres-compat.rb:33:inquery’
/var/lib/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/postgresql_adapter.rb:246:in
active?' /var/lib/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract_adapter.rb:108:inverify!’
/var/lib/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:122:in
verify_active_connections!' /var/lib/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:121:ineach_value’
/var/lib/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:121:in
verify_active_connections!' /var/lib/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:146:inprepare_application’
/var/lib/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:178:in
send!' /var/lib/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:178:inrun_callbacks’
/var/lib/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:175:in
each' /var/lib/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:175:insend!’
/var/lib/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:175:in
run_callbacks' /var/lib/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:114:indispatch’
/var/lib/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:126:in
dispatch_cgi' /var/lib/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:9:indispatch’
/var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/rails.rb:76:in
process' /var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/rails.rb:74:insynchronize’
/var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/rails.rb:74:in
process' /var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:159:inprocess_client’
/var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:158:in each' /var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:158:inprocess_client’
/var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:285:in run' /var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:285:ininitialize’
/var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:285:in new' /var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:285:inrun’
/var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:268:in initialize' /var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:268:innew’
/var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel.rb:268:in run' /var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/configurator.rb:282:inrun’
/var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/configurator.rb:281:in
each' /var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/configurator.rb:281:inrun’
/var/lib/gems/1.8/gems/mongrel-1.1.4/bin/mongrel_rails:128:in run' /var/lib/gems/1.8/gems/mongrel-1.1.4/lib/mongrel/command.rb:212:inrun’
/var/lib/gems/1.8/gems/mongrel-1.1.4/bin/mongrel_rails:281
/var/lib/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:489:in
load' /var/lib/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:489:inload’
/var/lib/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:342:in
new_constants_in' /var/lib/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:489:inload’
/var/lib/gems/1.8/gems/rails-2.0.2/lib/commands/servers/mongrel.rb:64
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in
gem_original_require' /usr/lib/ruby/1.8/rubygems/custom_require.rb:27:inrequire’
/var/lib/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:496:in
require' /var/lib/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:342:innew_constants_in’
/var/lib/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:496:in
require' /var/lib/gems/1.8/gems/rails-2.0.2/lib/commands/server.rb:39 /usr/lib/ruby/1.8/rubygems/custom_require.rb:27:ingem_original_require’
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `require’
script/server:3