Forum: Ruby on Rails fcgi,lighty mysql database problem

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Charlie B. (Guest)
on 2006-06-07 22:10
(Received via mailing list)
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 B.
http://www.recentrambles.com
Kian Wright (Guest)
on 2006-06-08 01:36
(Received via mailing list)
> 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.
Charlie B. (Guest)
on 2006-06-08 16:43
(Received via mailing list)
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.
This topic is locked and can not be replied to.