由于 Sunspot-Solr 重新索引问题，服务器超时

发布于 2024-11-27 06:49:10 字数 1229 浏览 0 评论 0原文

不太确定如何调试这个。任何提示将非常感激。

基本上，我刚刚做了一个大的提交，现在我的服务器由于 Sunspot-solr 问题而无法启动。

当我尝试手动重新索引时我注意到了这一点。

这是返回：

Processing MainController#index (for 69.114.195.64 at 2011-08-02 06:47:21) [GET]
  Parameters: {"action"=>"index", "controller"=>"main"}
  HomepageBackground Load (0.2ms)   SELECT * FROM `homepage_backgrounds` 
  HomepageBackground Columns (23.4ms)   SHOW FIELDS FROM `homepage_backgrounds`
  HomepageBackground Load (0.8ms)   SELECT * FROM `homepage_backgrounds` ORDER BY RAND() LIMIT 1
  SQL (30.2ms)   SHOW TABLES
  Organization Columns (1.8ms)   SHOW FIELDS FROM `organizations`
  Solr Select (Error)   {:q=>"*:*", :start=>0, :fq=>["type:Organization", "published_b:true", "updated_at_d:[2010\\-08\\-02T13\\:47\\:21Z TO *]"], :rows=>1000000}

Timeout::Error (execution expired):
  /usr/lib/ruby/1.8/timeout.rb:64:in `rbuf_fill'
  vendor/gems/right_http_connection-1.2.4/lib/net_fix.rb:51:in `rbuf_fill'
  /usr/lib/ruby/1.8/net/protocol.rb:116:in `readuntil'

更新

好的，所以我恢复并重新基于最后一次工作提交。我仍然遇到同样的错误。然后我 ps aux | grep solr，发现有 5 个 solr 实例正在运行。奇怪，我想，然后把他们一个个都杀了。 Blam 服务器已恢复并运行良好。所以现在我再次尝试我的新提交，但我的注意力集中在这些野生的太阳黑子实例上。

原文

Not too sure how to debug this. Any tips would be greatly appreciated.

Basically, I just did a large commit, and now my server can't boot up because of a Sunspot-solr issue.

I notice it when I try to manually reindex.

This is the return :

Processing MainController#index (for 69.114.195.64 at 2011-08-02 06:47:21) [GET]
  Parameters: {"action"=>"index", "controller"=>"main"}
  HomepageBackground Load (0.2ms)   SELECT * FROM `homepage_backgrounds` 
  HomepageBackground Columns (23.4ms)   SHOW FIELDS FROM `homepage_backgrounds`
  HomepageBackground Load (0.8ms)   SELECT * FROM `homepage_backgrounds` ORDER BY RAND() LIMIT 1
  SQL (30.2ms)   SHOW TABLES
  Organization Columns (1.8ms)   SHOW FIELDS FROM `organizations`
  Solr Select (Error)   {:q=>"*:*", :start=>0, :fq=>["type:Organization", "published_b:true", "updated_at_d:[2010\\-08\\-02T13\\:47\\:21Z TO *]"], :rows=>1000000}

Timeout::Error (execution expired):
  /usr/lib/ruby/1.8/timeout.rb:64:in `rbuf_fill'
  vendor/gems/right_http_connection-1.2.4/lib/net_fix.rb:51:in `rbuf_fill'
  /usr/lib/ruby/1.8/net/protocol.rb:116:in `readuntil'

UPDATE

Ok so I reverted and rebased to the last working commit. And I still got the same error. So then I ps aux | grep solr, and found five instances of solr running. Strange, I thought, and killed every single one of them. Blam server was back up and running strong. So now I'm trying my new commits again, but with my eye on these feral sunspot instances.

分享到QQ

分享到微博