I''ve been trying to get fast cgi working for nearly a month now. Yes,
an entire month! The application starts perfect, but it will die
randomly after several hours. I have traced the problem back
to /usr/lib/ruby/1.8/mysql.rb:1042:in `flush'' This happens when the
app
trys to query the database driver to see if it still has a connnection.
This causes the app to crash. Here is my error dump. Can anyone help?
Errno::EPIPE (Broken pipe):
/usr/lib/ruby/1.8/mysql.rb:1042:in `flush''
/usr/lib/ruby/1.8/mysql.rb:1042:in `write''
/usr/lib/ruby/1.8/mysql.rb:462:in `write''
/usr/lib/ruby/1.8/mysql.rb:436:in `command''
/usr/lib/ruby/1.8/mysql.rb:307:in `stat''
/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:147:in
`active?''
/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:85:in
`verify!''
/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:99:in
`verify_active_connections!''
/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:98:in
`verify_active_connections!''
Charlie Bowman
http://www.recentrambles.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://wrath.rubyonrails.org/pipermail/rails/attachments/20060607/6cab3f3d/attachment.html
> I''ve been trying to get fast cgi working for nearly a month now. Yes, anentire month! The application starts perfect, but it will die randomly after several hours. I have traced the problem back to /usr/lib/ruby/1.8/mysql.rb:1042:in `flush'' This happens when the app trys to query the database driver to see if it still has a connnection. This causes the app to crash. Here is my error dump. Can anyone help?> Errno::EPIPE (Broken pipe): > /usr/lib/ruby/1.8/mysql.rb:1042:in `flush'' > /usr/lib/ruby/1.8/mysql.rb:1042:in `write'' > /usr/lib/ruby/1.8/mysql.rb:462:in `write'' > /usr/lib/ruby/1.8/mysql.rb:436:in `command'' > /usr/lib/ruby/1.8/mysql.rb:307:in `stat''I know you probably don''t want to hear this, but my recommendation is to switch to PostgreSQL! It looks like MySQL is dropping the connection somehow. We had lots of problems with MySQL & Lighttpd, then switched to PG 8.1, and it''s been solid as a rock since January.
On Wed, 2006-06-07 at 21:33 +0000, Kian Wright wrote:> > I''ve been trying to get fast cgi working for nearly a month now. Yes, an > entire month! The application starts perfect, but it will die randomly after > several hours. I have traced the problem back to > /usr/lib/ruby/1.8/mysql.rb:1042:in `flush'' This happens when the app trys to > query the database driver to see if it still has a connnection. This causes the > app to crash. Here is my error dump. Can anyone help? > > Errno::EPIPE (Broken pipe): > > /usr/lib/ruby/1.8/mysql.rb:1042:in `flush'' > > /usr/lib/ruby/1.8/mysql.rb:1042:in `write'' > > /usr/lib/ruby/1.8/mysql.rb:462:in `write'' > > /usr/lib/ruby/1.8/mysql.rb:436:in `command'' > > /usr/lib/ruby/1.8/mysql.rb:307:in `stat'' > > I know you probably don''t want to hear this, but my recommendation is to switch > to PostgreSQL! It looks like MySQL is dropping the connection somehow. We had > lots of problems with MySQL & Lighttpd, then switched to PG 8.1, and it''s been > solid as a rock since January. >I am unable to switch from lighty or mysql.> _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >Charlie Bowman Programmer Castle Branch Inc. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060608/2b3f53c1/attachment-0001.html