http://stackoverflow.com/questions/100631/mysql-server-has-gone-away-with-rails
http://www.ruby-forum.com/topic/123472
暂时采纳了答3,实践中。
【转载】
问:
After our rails app has run for a while, it starts throwing 500s with "Mysql server has gone away". Often this happens overnight. It's started doing this recently, with no obvious change in our server configuration.
引用
Mysql::Error: MySQL server has gone away: SELECT * FROM `widgets`
Restarting the mongrels (not the mysql server) fixes it.
Any hints?
答:
答1
This is probably caused by the persistent connections to mysql going away (time out is likely if its happening over night) and rails failing to restore the connection, which it should be doing by default:
In the file vendor/rails/actionpack/lib/action_controller/dispatcher.rb is the code:
if defined?(ActiveRecord)
before_dispatch { ActiveRecord::Base.verify_active_connections! }
to_prepare(:activerecord_instantiate_observers) {ActiveRecord::Base.instantiate_observers }
end
the method verify_active_connections! performs several actions, one of which is to recreate any expired connections.
The most likely cause of this error is that this is because a monkey patch has redefined the dispatcher to not call verify_active_connections!, or verify_active_connections! has been changed etc.
答2
As the other contributors to this thread have said, it is most likely that mysql server has closed the connection to your rails app because of inactivity. The default timeout is 28800 seconds, or 8 hours.
引用
set-variable = wait_timeout=86400
Adding this line to your /etc/my.cnf will raise the timeout to 24 hours
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#option_mysqld_wait_timeout
Although the documentation doesn't indicate it, a value of 0 may disable the timeout completely, but you would need to experiment as this is just speculation.
There are however three other situations that I know of that can generate that error. The first is the mysql server being restarted. This will obviously drop all the connections, but as the mysql client is passive, this won't be noticed till you do the next query.
The second condition is if someone kills your query from the mysql command line, this also drops the connection because it could leave the client in an undefined state.
The last is if your mysql server restarts itself due to a fatal internal error. That is, if you are doing a simple query against a table and instantly see 'mysql has gone away', I'd take a close look at your server's logs to check for hardware error, or database corruption.
答3
Rails 2.3 has a reconnect option for your database connection:
production:
# Your settings
reconnect: true
See:
http://guides.rubyonrails.org/2_3_release_notes.html#reconnecting-mysql-connections
http://groups.google.com/group/rubyonrails-core/browse_thread/thread/49d2a7e9c96cb9f4?pli=1
Good luck!
答4
The connection to the MySQL server is probably timing out.
You should be able to increase the timeout in MySQL, but for a proper fix, have your code check that the database connection is still alive, and re-connect if it's not.
答5
Do you monitor the number of open mysql connections or threads? What is your mysql.ini settings for max_connections?
引用
mysql> show status;
Look at Connections, Max_used_connections, Threads_connected, and Threads_created.
You may need to increase the limits in your mysql config, or perhaps rails is not closing the connection properly*.
Note: I've only used rails briefly..
Here is the mysql docs for server status.
[url]
http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html[/url]
---
分享到:
相关推荐
If you’re an experienced developer, this book will give you the comprehensive, insider information you need., Rails has evolved over the years, and this book has evolved along with it. We still ...
Agile Web Development with Rails 5 英文无水印原版pdf pdf所有页面使用FoxitReader、PDF-XChangeViewer、SumatraPDF和Firefox测试都可以打开 本资源转载自网络,如有侵权,请联系上传者或csdn删除 查看此书...
Agile Web Development with Rails
Agile Web Development with Rails (PDF)
Agile Web Development with Rails 3nd Edition beta
agile web development with rails 5(英文电子书).............................................................................................................................................................
Ruby.on.Rails.Tutorial,Learn.Web.Development.with.Rails,Third.Edition-中文版 文字版.pdf 个人收集电子书,仅用学习使用,不可用于商业用途,如有版权问题,请联系删除!
Pragmatic - Agile Web Development with Rails 2ndPragmatic - Agile Web Development with Rails 2ndPragmatic - Agile Web Development with Rails 2ndPragmatic - Agile Web Development with Rails 2...
支持rails2.0以上版本的配置说明,文档从我自己的博客中整理出来,不愿意用资源分的朋友可以去我的博客看: http://wudihamagong.spaces.live.com/ 或者 http://blog.csdn.net/abcdefg0 ^_^
Agile Web Development with Rails 1-14节_ppt(老师发的修正版)
博文链接:https://jbf034.iteye.com/blog/219935
这是Agile Web Development with Rails for Rails 3.2, 为3.2的版本修改过的
没什么好介绍的beta版,pdf 第四版,包括Rails 3的内容。