Displaying 20 results from an estimated 40000 matches similar to: "My sql error: Lock wait timeout"
2009 Dec 28
3
Mysql::Error: Lock wait timeout exceeded; try restarting transaction
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
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
2008 Jul 30
2
Mysql "lock wait timeout" tuning
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
2013 Apr 30
3
[LLVMdev] Improving the usability of LNT
Hi Daniel,
I made some changes to the LNT perf reporting tool to make it more user friendly by adding some features:
1. Make the sidebar and the navigation bar stationary, so that it is easy to navigate the site
2. Have the pop-down menu for the items in the navigation bar, activate upon hovering the mouse, rather than clicking the item
3. Add a nav-link in the sidebar for the
2012 Jan 23
1
Extracting data from SQL Server based on R parameters
Hi,
Can you extract data from a SQL server table based on parameters already in
R? For example I have a list of unique patient IDs with latest
hospitalisation date which I've processed in R. I need to join this data to
other tables in SQL server. The tables in SQL server are too large to import
without reducing the number of records. I do not have write access to the
SQL server.
2013 May 02
0
[LLVMdev] Improving the usability of LNT
Wow, that sounds great! Thanks for working on this, and yes, please, send
the patches!
--renato
On 30 April 2013 16:23, Murali, Sriram <sriram.murali at intel.com> wrote:
> Hi Daniel,****
>
> I made some changes to the LNT perf reporting tool to make it more user
> friendly by adding some features:****
>
> **1. **Make the sidebar and the navigation bar stationary,
2013 Jan 29
4
[LLVMdev] [Patch][Review Requested][Compilation Time] Avoid frequent copy of elements in LoopStrengthReduce
Hello,
This patch aims to improve compile time performance by increasing the SCEV vector size in LoopStrengthReduce. It is observed that the BaseRegs vector size is 4 in most cases, and elements are frequently copied when it is initialized as SmallVector<const SCEV *, 2> BaseRegs.
Our benchmark results show that the compilation time performance improved by ~0.5%.
Patch by Wan Xiaofei.
2013 Sep 27
2
[LLVMdev] Trip count and Loop Vectorizer
Hi,
I am trying to get a small loop to *not vectorize* for cases where it doesn't make sense. For instance, this loop:
void foo(int a[4][8], int n)
{
int b[4][8];
for(int i = 0; i < 4; i++) {
for(int j = 0; j < n; j++) {
a[i][j] = b[i][j];
}
}
}
* Has maximum of 8ints copy. LLVM tries to use Memcpy for the inner loop. It is not helpful to perform
2012 Apr 04
4
[LLVMdev] Disabling x87 instructions for a sub-target
Hello there,
I recently started working on the LLVM backend for a target that doesn't support x87 instructions.
Currently, I am in the process of completely disabling some x87 instructions such as fcomi, fcompi,... for a specific sub-target. I also do not have SSE enabled for my sub-target, and llvm resorts to fcomi* instructions for FP compare instructions.
Is there a way to bypass the
2013 Sep 27
2
[LLVMdev] Trip count and Loop Vectorizer
Hi Nadav,
Thanks for the response. I forgot to mention that there is an upper limit of 16 for the Trip Count check,
TinyTripCountVectorThreshold = 16;
if (TC > 0u && TC < TinyTripCountVectorThreshold). So right now, any loop with Trip Count as 0, or with value >=16, LV with unroll. With the change to the lower bound, it will also include the loop with 0 trip count.
SCEV returns 0
2007 Sep 05
1
Timeout while waiting for lock for transaction log file
I have a user that gets client timeout errors when he tries to
delete/clean up his massive "Spam" folder (many thousands of mail messages).
He uses Thunderbird and has it configured to use "Move to Trash" when
he deletes messages.
I find the following in Dovecot's log file when it happens:
Aug 28 10:38:22 ifm.liu.se dovecot: [ID 107833 mail.error] IMAP(bpn):
Timeout
2013 Sep 27
0
[LLVMdev] Trip count and Loop Vectorizer
Hi Sriram,
Thanks for performing this analysis. The problem here, both for memcpy and the vectorizer, is that we can’t predict the size of “n”, even though the only use of ’n’ is for the loop bound for the alloca [4 x [8 x i32]]. If you change the unroll condition to TC >= 0 then you will disable loop unrolling for all loops because getSmallConstantTripCount returns an unsigned number. You
2011 Dec 07
5
Find_by_sql help?
How to make it work with paginator (kaminari)?
MySQL and full text search: Words (id, word)
@words = Word.find_by_sql(["SELECT id, word, MATCH (word) AGAINST (?) AS
Score FROM words WHERE MATCH (word) AGAINST (?) ORDER BY Score Desc,
word!=?", params[:search],params[:search],params[:search]])
I can''t add .page(params[:page]).per(5) to the end of "find_by_sql()" so
2007 Mar 08
5
Skipping hardlinks in a copy
Hi folks, I've been googling around for awhile but I can't seem to find
an answer to my question.
I have a number of filesystems that contain thousands of hard links due
to some bad organization of data. Rsync, cpio and various other
utilities fail to copy this data because I think there might be some
cycles in it. (you know you have troubles if cpio can't copy it!)
What I thought
2004 Feb 12
3
Ocfs mount issues
I am trying to mount the ocfs partitions using the following command
Mount -t ocfs -o uid=oracle,gid=dba /dev/sda /ocfs01 as user oracle and
group dba.
However it mounts the volume as root.
But if I use the ocfstool for the first and mount it as oracle:dba, the
subsequent mounts using the above command line mounts the volume as
oracle:dba.
Is there something that I am missing or I will have
2013 Sep 27
2
[LLVMdev] Trip count and Loop Vectorizer
On Sep 27, 2013, at 12:47 PM, Arnold Schwaighofer <aschwaighofer at apple.com> wrote:
> so you could infer that n must be smaller than 8 (because you know the range of the other dimension). The question is how often does such an example occur, where this is possible, to make such an effort justifiable?
smaller equal, of course ;)
2009 Jan 21
2
CDR 0.00 duration
Hi
I am using Trixbox 2.4 and PRI lines..on the CDR i see many calls that have duration of 0 seconds, but they are still shown as ANSWERED . how come its possible when duration is 0.00 ? Are the callers billed for such calls ?
Rgds
Sriram
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
2008 Nov 05
3
Rails 2.1.2, complex find involving complex include, bug?
So I''m upgrading my app from Rails 1.2.6 to Rails 2.1.2.
I have a complex find statement that worked in 1.2.6 and isn''t working
in 2.1.2. I think maybe this is a bug, although maybe there''s something
else I could be doing to work-around it?
My find statement involves:
* Models in a module for namespace purposes
* a join clause with raw SQL
* an includes clause with
2006 Feb 09
3
acts_as_taggable Produces Bad SQL - Find Fails
I am using acts_as_taggable in my application and on the tagging side of
things, no problem at all. Running edge Rails and PostgreSQL 8.1.
I am then trying to find all my AR objects with a certain tag. The tag is:
lasvegas and I know that there are at least 3 records with that tag.
So, I''m doing this:
@lists = List.find_tagged_with :any => @search_string, :separator =>
2013 Jan 29
0
[LLVMdev] [Patch][Review Requested][Compilation Time] Avoid frequent copy of elements in LoopStrengthReduce
On Tue, Jan 29, 2013 at 3:59 PM, Murali, Sriram <sriram.murali at intel.com> wrote:
> Our benchmark results show that the compilation time performance improved by
> ~0.5%.
That's fairly small; what was the standard deviation, confidence interval, etc?
-- Sean Silva