thr3ads.net - Rails - Broken Pipe to Postgres [Sep 2007]

If this information is useful, please help other people find it:
Share via:

Mark Fendley

2007-Sep-18 11:33 UTC

Broken Pipe to Postgres

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:in
`query''
   
/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:in
`active?''
   
/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:in
`verify_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:in
`prepare_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:in
`process_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:in `each_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:in
`process!''
    /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?
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Jay Levitt

2007-Sep-18 15:23 UTC

head link

Re: Broken Pipe to Postgres

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 Levitt                |
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 


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Foreero Ivan

2008-Jun-22 18:10 UTC

head link

Re: Broken Pipe to Postgres

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:in
`query''
/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:in
`verify!''
/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:in
`each_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:in 
`process''
/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:in 
`process''
/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:in `each''
/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:in `run''
/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:in `new''
/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:in `initialize''
/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:in `run''
/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:in 
`each''
/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:in `run''
/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:in
`load''
/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:in
`new_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:in
`require''
/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:in
`require''
/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:in
`send!''
/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:in
`each''
/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:in
`run_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:in
`dispatch_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:in 
`gem_original_require''
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `require''
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in 
`gem_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:in
`query''
/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:in
`verify!''
/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:in
`each_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:in
`prepare_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:in
`run_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:in
`send!''
/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:in
`dispatch''
/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:in
`dispatch''
/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:in 
`synchronize''
/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:in 
`process_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:in 
`process_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:in `initialize''
/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:in `run''
/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:in `new''
/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:in 
`run''
/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:in 
`run''
/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: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:in
`load''
/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:in
`new_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
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in 
`gem_original_require''
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `require''
/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:in
`new_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:in 
`gem_original_require''
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `require''
script/server:3

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Rails - Sep 2007 - Broken Pipe to Postgres

Broken Pipe to Postgres

Re: Broken Pipe to Postgres

Re: Broken Pipe to Postgres