similar to: ActiveRecord::StatementInvalid: Mysql::Error: Lock wait timeout exceeded

The move to memcached_client 1.6.5 in Rails 2.3 seems to have made the Rails cache about 10x slower. Since that''s the opposite effect I would expect, I was hoping somebody would explain where I''m misreading these numbers? I noticed my fragment caching was slow -- it shouldn''t take 2ms just to read a 2k string from a localhost memcached server: Cached fragment hit:

We''re seeing these errors intermittently: ### Mysql::Error: Lock wait timeout exceeded; try restarting transaction: UPDATE `chairs` SET `published_at` = NULL, `updated_at` = ''2008-07-30 15:31:05'' WHERE `id` = 2147 [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/ connection_adapters/abstract_adapter.rb:147:in `log'' ### The root issue is probably

Hello all I am using acts_as_ferret in user model. Error Message: -------------- ActiveRecord::StatementInvalid: Mysql::Error: Lock wait timeout exceeded; try restarting transaction: UPDATE `users` SET `updated_at` = ''2009-12-28 14:31:50'', `active_till` = ''2009-12-28 14:31:50'' WHERE `id` = 21 Where: ------ calls#audit

The method is here: https://github.com/rails/rails/blob/master/activerecord/lib/active_record/persistence.rb#L288. The method takes the in-memory attribute value and increments it by the specified amount. A safer approach (from an isolation standpoint) would be to let the database determine the value. Instead of telling the database what value to persist in the database, the SQL can written

Hi Is there any way to temporarily stop the updated_at field from being updated when a record is modified with ActiveRecord? I have a date field which is keeping track of when the record data was last checked by my application and my app manually updates it, of course when I do this the updated_at field is also touched making it fairly useless for finding out when the actual data was changed

Hey guys, This is the final list of the new maintainers of each plugin. We need two more things to do: First please the owners of the repos add the rest of the maintainers. Second I will add a note on each rails/plugin mentioning this repos updates. So from now on, if someone else is interested in helping/contributing please send a message to the appropriate repo owner. verification

Hello all, Ive got Mac OS X Leopard (10.5.8), ruby 1.8.6 (2009-06-08 patchlevel 369) [universal-darwin9.0] and mysql 5.0.67 installed and working fine with Rails 2.1.0. "which ruby" outputs /usr/bin/ruby. I can see the mysql symlink in / usr/local/mysql. I can also see the mysql-5.0.67-osx10.5-x86 folder in /usr/local . Im trying to upgrade my Rails apps to 2.3.5 but when i try to

Hi, im looking to build a page similar to a shopping cart page. When you change the ''price'' or ''quantity'' fields, the total is calculated and displayed. There are other fields in the form which have no relation to this action. So i guess observe_form is not required. Can someone tell me what the best practise is for this?

Hi all, I have a multi model form (Project with many tasks) and I want to prevent a task from being saved to the DB if it is empty ie. if there is no i/p for that task from the user. I tried the following class Task < ActiveRecord::Base before_save :check_if_empty ... def check_if_empty self.destroy if description.blank? end but i get this TypeError in ProjectsController#create

Hi, I have the following jQuery function on the head of my page. <script type="text/javascript"> jQuery.noConflict(); /* calling jNice on document ready */ jQuery(document).ready(function($) { $(''div.jNice'').jNice(); }); ..... </script> On page load, this gets called correctly. Now there''s a link on the page that lets me add more

Hi, I have a couple of daemons that im trying to setup to be run for my app. The environment load is as follows.. ENV["RAILS_ENV"] ||= "development" require File.join(File.dirname(__FILE__), "/../../config/environment") And the error I get is #<LoadError: no such file to load -- active_support> #<Gem::Exception: can''t activate activesupport (=

I have an error I don''t know how to debug. I am adding the login suport in Depot (the example in the RoR book) and LoginController#add_user throws ActiveRecord::StatementInvalid in an innocent /login/add_user GET request. The trace goes down to a call to SQLiteAdapter#table_structure, and the source code suggests what''s happening is that "PRAGMA

I intentionally deleted the attribute author from the table comments. When I used functional testing, I got the following message ActiveRecord::StatementInvalid: PGError: ERROR: column "author" of relation "comments" does not exist What should I need to do in order to avoid this error message!!! -- You received this message because you are subscribed to the Google Groups

I have this problem as well... After so many hours of inactivity, I get "statement invalid" and if I restart Apache or WEBrick, everything works fine again. What steps can I take to fix this? I don''t want to have to restart the server! -Brian -----Original Message----- From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org

Wht exactly does this mean? #<ActiveRecord::StatementInvalid: ThreadError: killed thread: That a thread was killed in the middle of a query? Thanks for your help. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this

Hi all, I just submitted a patch to 2-3-stable on lighthouse and wanted to bring it to folks general attention. https://rails.lighthouseapp.com/projects/8994-ruby-on-rails/tickets/896-be-a-little-more-discerning-about-which-exceptions-to-handle My explanation is a bit long-winded, but here''s the motivation for the patch, as explained in the lighthouse ticket: Perhaps I should open

Hi There, I''m gettings the following errors while accessing my application. Can someone please tell what is the possible cause and can it be resolved. " ActiveRecord::StatementInvalid in Site#showalladdress Showing site/showalladdress.rhtml where line #3 raised: Mysql::Error: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

I recently finished the first part of the "Agile Rails" book. But, the depot doesn''t completely work as it should. I still have 2 problems: I will explain them in 2 threads. The first one is: I can''t destroy products (I can only creat and update them). When I try to delete a product --> http://localhost:3001/admin/destroy/3 I get this error message:

I am having a problem. I am trying to work through the PDF of Dave Thomas''s book, but I keep getting this error after developing for five to ten minutes: WARNING: You have a nil object when you probably didn''t expect it! Odds are you want an instance of Array instead. Look in the callstack to see where you''re working with an object that could be nil. Investigate

Hi, I''m having a bit of a problem with a rails app and I wonder if anyone can help. It seems to run fine for a while, but if it''s left running too long (left running as a fastcgi or webrick process that is) it starts failing with an "ActiveRecord::StatementInvalid" error (i''ve included the full error from the log file below). I''m seeing this on both