mysql - SIGTERM + Rails + mysql？

Question

我突然开始在应用程序中收到大量 SignalException:SIGTERM 异常，显然来自 mysql。堆栈跟踪如

vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:217
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:217:in `log'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:323:in `execute'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:608:in `select'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'

或

vendor/rails/activesupport/lib/active_support/buffered_logger.rb:63
vendor/rails/activesupport/lib/active_support/buffered_logger.rb:63:in `add'
vendor/rails/activesupport/lib/active_support/buffered_logger.rb:71:in `debug'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:196:in `log_info'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:218:in `log'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:323:in `execute'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:608:in `select'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'

我有点困惑。有什么想法从哪里开始挖掘吗？

Answer 1

您运行在什么平台上以及运行什么版本的 MySql？听起来 mysql 客户端库或 mysql 服务器可能坏了。另外，这是一个新的应用程序还是已经运行了一段时间没有问题的应用程序？

重新安装 MySql 可能是您最好的机会，但在此之前请尝试使用替代的 mysql 适配器:mysql2 和 ruby​​-mysql。您可能会有一点运气，这会节省大量时间和麻烦。