search for: query_cache

...;'ve been using find_in_batches to reduce memory usage, and recently noticed one of our more intensive background processes had a huge memory footprint (600mb+) and was getting killed by our memory monitor. We were unable to reproduce this in development, and after investigation, the culprit is query_cache. Wrapping the task in ActiveRecord::Base#uncached kept the task stable (~200mb), and it''s not hard to imagine why. Looping over thousands of items while eager loading many more likely grows the cache to huge amounts, which seems counter to the use case for find_in_batches. So first of all...

.../external/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:66:in `perform_action_without_rescue'' /home/andy/stringsDB/external/vendor/rails/actionpack/lib/action_controller/rescue.rb:83:in `perform_action_without_caching'' /home/andy/stringsDB/external/vendor/plugins/query_cache/lib/query_cache.rb:133:in `perform_action'' /home/andy/stringsDB/external/vendor/plugins/query_cache/lib/query_cache.rb:106:in `cache'' /home/andy/stringsDB/external/vendor/plugins/query_cache/lib/query_cache.rb:132:in `perform_action'' /home/andy/stringsDB/external/vendo...

...#39; /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/ dispatcher.rb:121:in `_call'' /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/ dispatcher.rb:130:in `build_middleware_stack'' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ query_cache.rb:29:in `call'' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ query_cache.rb:29:in `call'' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/abstract/query_cache.rb:34:in `cache'' /usr/lib/ruby/gems/1.8/gems/activereco...

...39;' C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.3.2/lib/action_controller/ dispatcher.rb:111:in `_call'' C:/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.3.2/lib/action_controller/ dispatcher.rb:82:in `initialize'' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/ query_cache.rb:29:in `call'' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/ query_cache.rb:29:in `call'' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/ connection_adapters/abstract/query_cache.rb:34:in `cache'' C:/Ruby/lib/ruby/gems/1.8/gems/a...

...`dispatch'' /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.2/lib/action_controller/dispatcher.rb:111:in `_call'' /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.2/lib/action_controller/dispatcher.rb:82:in `initialize'' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/query_cache.rb:29:in `call'' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/query_cache.rb:29:in `call'' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'' /usr/lib/ruby/gems/1.8/gems/activerecord...

I love the query cache from rails edge, but I didn''t want to put our production app on edge just yet. (went down that route in the 1.1.x days, and the edge cut me a few times). So I think I have it ported into a plugin we can use on 1.2.x http://query-cache.googlecode.com/svn/query_cache/ Basically it''s just a copy and paste job of the latest query_cache.rb, the part that loads it from caching.rb, and its unit tests. Any thoughts on this? Seems like it works perfectly, the query cache unit tests run fine, and my app''s running fine (i.e. tests are green). If an...

...#39; /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/ dispatcher.rb:121:in `_call'' /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/ dispatcher.rb:130:in `build_middleware_stack'' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ query_cache.rb:29:in `call'' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ query_cache.rb:29:in `call'' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/abstract/query_cache.rb:34:in `cache'' /usr/lib/ruby/gems/1.8/gems/activereco...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Anyone know what''s going on with ActiveRecord Edge and 1.2RC1 unit tests. I get 13 failures from the "async_exec" method call. ie: test_callback_rollback_in_save(ConcurrentTransactionTest): ActiveRecord::StatementInvalid: NoMethodError: undefined method `async_exec'' for #<PGconn:0xb75a8754>: SET

...gems/1.8/gems/actionpack-2.3.5/lib/action_controller/dispatcher.rb:121:in `_call'' C:/Instant/ruby/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/dispatcher.rb:130:in `build_middleware_stack'' C:/Instant/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/query_cache.rb:29:in `call'' C:/Instant/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/query_cache.rb:29:in `call'' C:/Instant/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'' C:/Instant/ruby/li...

...'' /var/lib/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/dispatcher.rb:121:in `_call'' /var/lib/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/dispatcher.rb:130:in `build_middleware_stack'' /var/lib/gems/1.8/gems/activerecord-2.3.5/lib/active_record/query_cache.rb:29:in `call'' /var/lib/gems/1.8/gems/activerecord-2.3.5/lib/active_record/query_cache.rb:29:in `call'' /var/lib/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'' /var/lib/gems/1.8/gems/activerecord-2....

...npack (3.0.7) lib/action_dispatch/middleware/flash.rb:182:in `call'' actionpack (3.0.7) lib/action_dispatch/middleware/session/ abstract_store.rb:149:in `call'' actionpack (3.0.7) lib/action_dispatch/middleware/cookies.rb:302:in `call'' activerecord (3.0.7) lib/active_record/query_cache.rb:32:in `call'' activerecord (3.0.7) lib/active_record/connection_adapters/abstract/ query_cache.rb:28:in `cache'' activerecord (3.0.7) lib/active_record/query_cache.rb:12:in `cache'' activerecord (3.0.7) lib/active_record/query_cache.rb:31:in `call'' activerecord (...

...npack (3.0.0) lib/action_dispatch/middleware/flash.rb:182:in `call'' actionpack (3.0.0) lib/action_dispatch/middleware/session/ abstract_store.rb:149:in `call'' actionpack (3.0.0) lib/action_dispatch/middleware/cookies.rb:287:in `call'' activerecord (3.0.0) lib/active_record/query_cache.rb:32:in `block in call'' activerecord (3.0.0) lib/active_record/query_cache.rb:10:in `cache'' activerecord (3.0.0) lib/active_record/query_cache.rb:31:in `call'' activerecord (3.0.0) lib/active_record/connection_adapters/abstract/ connection_pool.rb:355:in `call'' a...

I''m walking through an example in the "Head First Rails" book, but, instead doing the examples using Rails3.0.0.rc. But, I''m getting this error when browsing for example: http://localhost:3000/advs/1 undefined method `eq'' for nil:NilClass Provided that my advs_controller.rb is as follows: http://pastie.org/private/cd9zntg2ite57ept288kfa Any ideas why

...ispatch'' /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.3/lib/action_controller/ dispatcher.rb:111:in `_call'' /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.3/lib/action_controller/ dispatcher.rb:82:in `initialize'' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.3/lib/active_record/ query_cache.rb:29:in `call'' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.3/lib/active_record/ query_cache.rb:29:in `call'' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.3/lib/active_record/ connection_adapters/abstract/query_cache.rb:34:in `cache'' /usr/lib/ruby/gems/1.8/gems/activereco...

Hi, When I upgraded my rails application to rails 2.3.2 I am getting error ''can''t modify frozen hash'' on using @something.update_attribute(params[:something]). Can anyone help me who is familiarize with this bug? Thanks,

...ib/ action_controller/rescue.rb:199:in `perform_action_without_caching'' /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/ action_controller/caching.rb:678:in `perform_action'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/ connection_adapters/abstract/query_cache.rb:33:in `cache'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/ query_cache.rb:8:in `cache'' /usr/local/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/ action_controller/caching.rb:677:in `perform_action'' /usr/local/lib/ruby/gems/1.8/gems/actionpack-2...

Hi, while generating the PDF file , i am getting following error.. please help for me. RuntimeError (JPEG marker not found!): C:/Ruby/lib/ruby/gems/1.8/gems/pdf-writer-1.1.8/lib/pdf/writer/ graphics/imageinfo.rb:176:in ` measure_JPEG'' C:/Ruby/lib/ruby/gems/1.8/gems/pdf-writer-1.1.8/lib/pdf/writer/ graphics/imageinfo.rb:174:in ` loop''

Have been developing on 3.0.0beta4 and just updated to 3.0.0.rc. When I try to link_to() a User object that previously had worked, I get the following: ActionView::Template::Error (No route matches {:action=>"destroy", :controller=>"games", :id=>#<User ..... > Yet I have in my routes.rb file has resources :users and my "rake routes" shows:

...execute'' from /Library/Ruby/Gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/sqlite_adapter.rb:256:in `select'' from /Library/Ruby/Gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'' from /Library/Ruby/Gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/query_cache.rb:55:in `select_all'' from /Library/Ruby/Gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:532:in `find_by_sql'' from /Library/Ruby/Gems/1.8/gems/act...

...ib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/dispatcher.rb:121:in `_call'' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/dispatcher.rb:130:in `build_middleware_stack'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/query_cache.rb:29:in `call'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/query_cache.rb:29:in `call'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'' c:/ruby/lib/ruby/gems/...