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