similar to: Mysql "lock wait timeout" tuning

Displaying 20 results from an estimated 400 matches similar to: "Mysql "lock wait timeout" tuning"

2005 Dec 18
5
restarting fastCGI process
Hi, I am very new to this so please go easy on me... I am trying to deploy my app on dreamhost and I seem to be having problems getting it working. One of the troubleshooting items on the wiki states: Rails apps in production mode do not reflect changes made after they start running. So, if you found a bug, fixed it and nothing appeared to happen--this is probably because you
2005 Dec 23
6
Save using Update
Hi, I want to update an existing row in table "items" where items.id == 10 I tried this: item = Item.new item.f1 = ... item.f2 = ... ... item.id = 10 item.save I got an error Duplicate entry ... for key 10 : INSERT INTO items ... How do I make item.save to use UPDATE instead of INSERT? -- Posted via http://www.ruby-forum.com/.
2002 Mar 19
3
plot with the axes at xlim and ylim
I'd like to make a plot with the axes drawn at the values of xlim and ylim. The default plot draws the axes slightly outside these values. I have been experimenting with the par(mgp) setting, but specifying par(mgp=c(2,0,-1)) gives me "invalid value specified for graphics parameter "mgp".". A more complicated mathod that almost seems to work is doing the plot with
2010 Mar 17
3
ActiveRecord::StatementInvalid: Mysql::Error: Lock wait timeout exceeded
Hi all, Ive been getting this error on one particular query repeatedly for the past few days. ActiveRecord::StatementInvalid: Mysql::Error: Lock wait timeout exceeded; try restarting transaction: UPDATE `posts` SET `updated_at` = ''2010-03-17 05:35:00'', `view_count` = 54 WHERE `id` = 158 Googling around, I found that this is basically because the transaction times out after
2011 Feb 18
1
Rails plugins new official maintainers
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
2006 Jul 24
7
[PATCH] Support for DB Clusters/Replication in ActiveRecord (RFC)
Skipped content of type multipart/alternative-------------- next part -------------- Index: connection_adapters/abstract/connection_specification.rb =================================================================== --- connection_adapters/abstract/connection_specification.rb (revision 4617) +++ connection_adapters/abstract/connection_specification.rb (working copy) @@ -1,10 +1,21 @@ require
2010 Apr 12
2
[PATCH] Access to more Arel predicate types from where condition hash
I could use some eyes on https://rails.lighthouseapp.com/projects/8994/tickets/4368 if anyone has the time. Summary of the change: Similar to PredicateBuilder''s existing support for ''table.column'' => ''value'', this patch enables ''column#method'' => ''value''. For instance,
2017 Dec 05
2
Rebooting cluster nodes - GFS3.8
I am running gluster ver 3.8 in a distributed replica 2 config. I need to reboot all my 8 cluster nodes to update my bios firmware. I would like to do a rolling update to my bios and keep up my cluster so my clients don't take an outage. Do I need to shutdown all gluster services on each node before I reboot? Or just issue the reboot. -------------- next part -------------- An HTML attachment
2017 Dec 05
0
Rebooting cluster nodes - GFS3.8
On my setup at least, just issuing the reboot command works without any issue. I've done a number of rolling reboots for software / kernel upgrades in the manner you've described this way. The one gotcha I've found is when the node comes back online. I manually check healing to ensure that everything is synced and back online before taking other nodes offline. --- Thanks,
2005 Dec 16
10
Associative arrays
I just started playing with rails this week and am working on porting our existing website to rails in our navigation we have a list that has the days of the week that link to the articles for those days. this seems to be working when I had it in the template it would give me the array I was looking for so I decided to move it to the helper so that I could use it on all my templates.
2012 Apr 17
6
ActiveRecord with different Date/Time format
I have an application where user sets his/her preferred date/time format. User is expected to enter datetime in his preferred format across the application. Now the problem is for few formats the datetime is parsed wrongly while create/update ActiveRecord. For example user has set date/time format in hh:mm dd/MM/yyyy. Now if user enters 17:00 04/05/2012 it parses it as 5 PM 5 Apr, 2012 where it
2010 Aug 05
3
how to ? Rails 3 ActiveRecord eager loading and AREL
Hello everyone, I would like to eager load scoped records to avoid queries executed in a loop (huge performance impact). The "scoped" part is what is giving me a hard time. I''m using Rails3 RC. Does anyone have any idea how I can do it? Here is a test case : we have an "Article" and a "Comment" Activerecord models, article has many comments comment
2006 Apr 20
5
acts_as_taggable patch 3866 needs some testing
DHH''s acts_as_taggable is now much more usable with this patch. http://dev.rubyonrails.org/ticket/3866 This patch adds scoped finders, documentation, and tests: # Get tags for all articles in a blog @blog.articles.tags # Get tags for articles in a blog published in the last year @blog.articles.tags :conditions => [''published_at > ?'', 1.year.ago] # Get related
2007 Nov 29
4
collection.build or collection.create gives "ArgumentError: wrong number of arguments (1 for 0)"
I have a Project that has_many Tasks. Tasks belongs to a Project. When I try the following: project = Project.new project.tasks.build I get: >> s = Project.new => #<Project:0x25f9e28 @attributes={"name"=>"", "end_at"=>nil, "updated_at"=>nil, "published_at"=>nil, "user_id"=>nil,
2009 Jul 28
1
Rails date conversion
The environment.rb file in a Rails 2.3.2 app says: > Set Time.zone default to the specified zone and make Active Record auto-convert to this zone. Auto-convert to this zone... when? Also, what are the differences between these two statements? config.time_zone = xxx config.active_record.default_timezone = xxx I ask these questions because I have a scenario whereby an AR-backed object, when
2006 Jun 17
8
Application Design
Hey, I have a system that I am trying to design, it contains news articles, events, etc... There is model representing articles, one representing events, etc... Articles or events can be active or inactive, so I can do a query to return all active articles, all articles or all inactive articles. The question that I have is what would be the best way to design this. Right now I have each
2007 Jul 19
3
Merb::Controller#url Usage
I have a question about the usage of Merb::Controller#url. When I have nested resources, requesting the new action works differently than I expected. I was wondering what the intended usage is. For example: Say I have r.resources :articles do |article| article.resources :article_attachments end irb(main):002:0> show_routes [:articles, "/articles"] [:article_attachments,
2011 Feb 05
3
ActiveModel::AttributeMethods limiting
In my attempt to add AM:Dirty to my model I realized that AM#AttributeMethods is a bit imperfect. It''s impossible to generate attribute methods step-by-step in DataMapper-like manner. class Model include ActiveModel::Dirty def self.property(name, klass = String) define_property_accessors(name, klass) # This method will be called once, because of
2007 Jul 29
7
Merb test harness
Ezra, * test harness in new generated merb apps with helpers for testing merb without starting a server. * pin down plugin arch Seems to me that these two tasks go together unless you want to have rspec built in Merb. Regarding the test harness, my understanding is that: - a developer should be able to easily write specs against a merb application. - a developer should not need to start a merb
2006 May 27
0
Typo 1055 created_at Vs. published_at
[Couldn''t post this to the Typo forum, hope it''s Ok here :-)] Before I go off and create a Typo ticket, I''d like to know if anyone else is experiencing this and what there thoughts might be on the subject? In Typo 1055, if you use the admin interface and change the published date for an article, you will get "post not found", when you click on the article