The Connected Website - Task 306

A ActionView::TemplateError occurred in posts#featured:

Mysql::Error: Incorrect information in file: './republic/posts.frm': SELECT * FROM `posts` WHERE (featured_at IS NOT NULL) ORDER BY featured_at DESC LIMIT 6
On line #8 of app/views/featured.rss.builder

5: xml.description "#{APP_NAME} (Featured Posts)"
6: xml.link featured_posts_url
7:
8: render_posts(xml, @posts)
9: end
10: end
11:

vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:176:in `log'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:309:in `execute'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:563:in `select'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:74:in `select_all'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:95:in `cache_sql'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:74:in `select_all'
vendor/rails/activerecord/lib/active_record/base.rb:609:in `find_by_sql'
vendor/rails/activerecord/lib/active_record/base.rb:1433:in `find_every'
vendor/rails/activerecord/lib/active_record/base.rb:563:in `find'
vendor/rails/activerecord/lib/active_record/named_scope.rb:171:in `send'
vendor/rails/activerecord/lib/active_record/named_scope.rb:171:in `method_missing'
vendor/rails/activerecord/lib/active_record/base.rb:1927:in `with_scope'
(__DELEGATION__):2:in `__send__'
(__DELEGATION__):2:in `with_scope'
vendor/rails/activerecord/lib/active_record/named_scope.rb:169:in `method_missing'
vendor/rails/activerecord/lib/active_record/named_scope.rb:171:in `send'
vendor/rails/activerecord/lib/active_record/named_scope.rb:171:in `method_missing'
vendor/rails/activerecord/lib/active_record/base.rb:1927:in `with_scope'
(__DELEGATION__):2:in `__send__'
(__DELEGATION__):2:in `with_scope'
(__DELEGATION__):2:in `__send__'
(__DELEGATION__):2:in `with_scope'
vendor/rails/activerecord/lib/active_record/named_scope.rb:169:in `method_missing'
vendor/rails/activerecord/lib/active_record/named_scope.rb:177:in `load_found'
vendor/rails/activerecord/lib/active_record/named_scope.rb:161:in `proxy_found'
(__DELEGATION__):2:in `each'
app/helpers/posts_helper.rb:9:in `render_posts'
app/views/posts/featured.rss.builder:8
/usr/lib/ruby/gems/1.8/gems/builder-2.1.2/lib/builder/xmlbase.rb:134:in `call'
/usr/lib/ruby/gems/1.8/gems/builder-2.1.2/lib/builder/xmlbase.rb:134:in `_nested_structures'
/usr/lib/ruby/gems/1.8/gems/builder-2.1.2/lib/builder/xmlbase.rb:58:in `method_missing'
app/views/posts/featured.rss.builder:3
/usr/lib/ruby/gems/1.8/gems/builder-2.1.2/lib/builder/xmlbase.rb:134:in `call'
/usr/lib/ruby/gems/1.8/gems/builder-2.1.2/lib/builder/xmlbase.rb:134:in `_nested_structures'
/usr/lib/ruby/gems/1.8/gems/builder-2.1.2/lib/builder/xmlbase.rb:58:in `method_missing'
app/views/posts/featured.rss.builder:2
vendor/rails/actionpack/lib/action_view/renderable.rb:34:in `send'
vendor/rails/actionpack/lib/action_view/renderable.rb:34:in `render'
vendor/rails/actionpack/lib/action_view/template.rb:68:in `render_template'
vendor/rails/actionpack/lib/action_view/base.rb:266:in `render'
vendor/rails/actionpack/lib/action_controller/base.rb:1122:in `render_for_file'
vendor/rails/actionpack/lib/action_controller/base.rb:925:in `render_without_benchmark'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:51:in `render'
vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:8:in `realtime'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:51:in `render'
app/controllers/posts_controller.rb:83:in `featured'
vendor/rails/actionpack/lib/action_controller/mime_responds.rb:135:in `call'
vendor/rails/actionpack/lib/action_controller/mime_responds.rb:135:in `custom'
vendor/rails/actionpack/lib/action_controller/mime_responds.rb:164:in `call'
vendor/rails/actionpack/lib/action_controller/mime_responds.rb:164:in `respond'
vendor/rails/actionpack/lib/action_controller/mime_responds.rb:158:in `each'
vendor/rails/actionpack/lib/action_controller/mime_responds.rb:158:in `respond'
vendor/rails/actionpack/lib/action_controller/mime_responds.rb:107:in `respond_to'
app/controllers/posts_controller.rb:79:in `featured'
vendor/rails/actionpack/lib/action_controller/base.rb:1179:in `send'
vendor/rails/actionpack/lib/action_controller/base.rb:1179:in `perform_action_without_filters'
vendor/rails/actionpack/lib/action_controller/filters.rb:617:in `call_filters'
vendor/rails/actionpack/lib/action_controller/filters.rb:610:in `perform_action_without_benchmark'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
vendor/rails/actionpack/lib/action_controller/rescue.rb:202:in `perform_action_without_caching'
vendor/rails/actionpack/lib/action_controller/caching/sql_cache.rb:13:in `perform_action'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:48:in `cache'
vendor/rails/activerecord/lib/active_record/query_cache.rb:8:in `cache'
vendor/rails/actionpack/lib/action_controller/caching/sql_cache.rb:12:in `perform_action'
vendor/rails/actionpack/lib/action_controller/base.rb:539:in `send'
vendor/rails/actionpack/lib/action_controller/base.rb:539:in `process_without_filters'
/usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
vendor/rails/actionpack/lib/action_controller/base.rb:539:in `process_without_filters'
vendor/rails/actionpack/lib/action_controller/filters.rb:606:in `process_without_session_management_support'
vendor/rails/actionpack/lib/action_controller/session_management.rb:134:in `process'
vendor/rails/actionpack/lib/action_controller/base.rb:403:in `process'
vendor/rails/actionpack/lib/action_controller/dispatcher.rb:151:in `handle_request'
vendor/rails/actionpack/lib/action_controller/dispatcher.rb:104:in `dispatch'
vendor/rails/actionpack/lib/action_controller/dispatcher.rb:116:in `dispatch_cgi'
vendor/rails/actionpack/lib/action_controller/dispatcher.rb:33:in `dispatch'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel/rails.rb:76:in `process'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel/rails.rb:74:in `synchronize'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel/rails.rb:74:in `process'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:159:in `process_client'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:158:in `each'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:158:in `process_client'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:285:in `run'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:285:in `initialize'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:285:in `new'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:285:in `run'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:268:in `initialize'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:268:in `new'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel.rb:268:in `run'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel/configurator.rb:282:in `run'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel/configurator.rb:281:in `each'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel/configurator.rb:281:in `run'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/mongrel_rails:128:in `run'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/lib/mongrel/command.rb:212:in `run'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/mongrel_rails:281
/usr/bin/mongrel_rails:19:in `load'
/usr/bin/mongrel_rails:19

-------------------------------
Request:
-------------------------------

* URL : http://theconnectedrepublic.org/posts/featured.rss
* IP address: 64.78.155.100
* Parameters: {"format"=>"rss", "action"=>"featured", "controller"=>"posts"}
* Rails root: /var/www/apps/republic/releases/20081021125802

-------------------------------
Session:
-------------------------------

* session id: "3cfad3ee4a7169a82a3e35db50396d4e"
* data: {"flash"=>{}}

-------------------------------
Environment:
-------------------------------

* GATEWAY_INTERFACE : CGI/1.2
* HTTP_ACCEPT_ENCODING: gzip
* HTTP_CONNECTION : close
* HTTP_HOST : theconnectedrepublic.org
* HTTP_IF_NONE_MATCH : "70d3db93638517d0734b990baf6dacd1"
* HTTP_USER_AGENT : NewsGatorOnline/2.0 (http://www.newsgator.com; 1 subscribers)
* HTTP_VERSION : HTTP/1.0
* HTTP_X_FORWARDED_FOR: 64.78.155.100
* HTTP_X_REAL_IP : 64.78.155.100
* PATH_INFO : /posts/featured.rss
* REMOTE_ADDR : 127.0.0.1
* REQUEST_METHOD : GET
* REQUEST_PATH : /posts/featured.rss
* REQUEST_URI : /posts/featured.rss
* SCRIPT_NAME : /
* SERVER_NAME : theconnectedrepublic.org
* SERVER_PORT : 80
* SERVER_PROTOCOL : HTTP/1.1
* SERVER_SOFTWARE : Mongrel 1.1.5

* Process: 4000
* Server : connectedrepublic

-------------------------------
Backtrace:
-------------------------------

On line #8 of app/views/featured.rss.builder

5: xml.description "#{APP_NAME} (Featured Posts)"
6: xml.link featured_posts_url
7:
8: render_posts(xml, @posts)
9: end
10: end
11:

Task 306

You need to login to add comments.
No account yet? Signup is quick and easy.

mikehale added a comment over 3 years ago

I'll do some more testing this evening to see if I can find out what the root issue is.
duff added a comment over 3 years ago

It does seem like we only got this after the server was restarted.
duff added a comment over 3 years ago

From Michael:

Duff, I saw similar error messages in the server log after restarting
the box this evening. I think I figured out what the issue was, though
I am not sure exactly why it happened. Basically after restarting the
box 2 mysql process were running and it was causing issues accessing
the tables.
duff created a task for mikehale over 3 years ago.

Tags: