Fcgi,lighty mysql database problem


#1

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:inwrite’
/usr/lib/ruby/1.8/mysql.rb:462:in write' /usr/lib/ruby/1.8/mysql.rb:436:incommand’
/usr/lib/ruby/1.8/mysql.rb:307:in stat' /vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:147:inactive?’
/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:inverify_active_connections!’
/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:98:in
`verify_active_connections!’

Charlie B.
http://www.recentrambles.com


#2

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:inflush’
/usr/lib/ruby/1.8/mysql.rb:1042:in write' /usr/lib/ruby/1.8/mysql.rb:462:inwrite’
/usr/lib/ruby/1.8/mysql.rb:436:in command' /usr/lib/ruby/1.8/mysql.rb:307:instat’

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.


#3

On Wed, 2006-06-07 at 21:33 +0000, Kian Wright wrote:

/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
removed_email_address@domain.invalid
http://lists.rubyonrails.org/mailman/listinfo/rails

Charlie B.
Programmer
Castle Branch Inc.