Sporadically getting error Mysql::Error: Lost connection

rubyonrails-talk
1

Do you have the mysql-ruby bindings installed? I don’t know how you installed Rails and / or Ruby on your system. Some distros have this as a package.

You could also install it with gems

sudo gem install mysql

provided that you have everything set up right on your box (paths, compilers, etc),

I don’t know Centos at all, so I won’t be much more help than that. However, I’ve seen that error before whenever I had heavy dtabase access in my Rails apps and they were using the Mysql libraries that comes with Rails rather than the much faster C bindings I talked about here.

Hope that helps you some.

2

Thanks for the reply

I installed mysql via:

gem install mysql --with-mysql-config=/usr/bin/mysql_config

I figure if there was a problem with this then I would not be able to connect at all, right?

3

Not necessarily. Rails could still be using the native one.

If you do

gem list mysql

does it show up on the list? If it does then I have no idea what’s wrong. If it doesn’t show up then it didn’t install (that’s happened to me as well)

4

Here is what I get - seems about right, correct?

gem list mysql

*** LOCAL GEMS ***

mysql (2.7)     MySQL/Ruby provides the same functions for Ruby programs that the     MySQL C API provides for C programs.

I just enabled MySql logging and I see the query (an update query in this case) being executed and the rolled back.

5

Anyone have opinions on what payment processors are best? I am using Payflow right now wondering if I should change or keep using it. Plan on using ActiveMerchant so want something that it supports.

Any opinions or recommendations out there?

thanks.