database-deadlocks Questions
1
Solved
I am working on a theory basis here, I want to make sure all my bases are covered.
I have read quite a bit into InnoDB with Java and how deadlocks can occur no matter what query you are running. A...
Kempe asked 31/5, 2013 at 9:3
2
Solved
I have an Oracle DB package that is routinely causing what I believe is an ITL (Interested Transaction List) deadlock. The relevant portion of a trace file is below.
Deadlock graph:
---------Bloc...
Saransarangi asked 24/5, 2010 at 17:59
2
Solved
I use PostgreSQL 9.2, and I do not use explicit locking anywhere, neither LOCK statement nor SELECT ... FOR UPDATE. However, recently I got ERROR: 40P01: deadlock detected. The query where deadlock...
Haro asked 16/4, 2013 at 17:6
2
I'm trying to understand a deadlock found by MySQL during concurrent clients processing on the same tables. This is the interesting part of the "SHOW InnoDB STATUS" command:
----------------------...
Retina asked 4/7, 2012 at 14:28
4
Solved
I have a MySQL table with about 5,000,000 rows that are being constantly updated in small ways by parallel Perl processes connecting via DBI. The table has about 10 columns and several indexes.
On...
Fortney asked 7/4, 2010 at 21:16
2
Solved
i have two hypothetical queries:
UPDATE BankAccounts SET HomePhone = '+1 252-555-0912'
WHERE AccountNumber = 14400000619
and
SELECT * FROM BankAccounts
WHERE HomePhone = '555-1212'
on a hyp...
Gaw asked 28/1, 2013 at 14:38
2
Solved
This is a follow up on my previous question (you can skip it as I explain in this post the issue):
MySQL InnoDB SELECT...LIMIT 1 FOR UPDATE Vs UPDATE ... LIMIT 1
Environment:
JSF 2.1 on Glassfis...
Jackscrew asked 27/12, 2012 at 9:5
3
Solved
We are having a problem inserting several entities with EF in parallel. A WCF operation is called by a lot of processes to generate an entity with a different distributed transaction in each call. ...
Selfevident asked 29/12, 2011 at 11:46
2
Suppose that two simultaneous transactions execute the following queries on a Postgresql DB:
Transaction A:
SELECT * FROM mytable WHERE id IN (1, 2, 3, 4) FOR UPDATE
Transaction B:
SELECT * FR...
Expressivity asked 10/10, 2012 at 18:10
1
Solved
I have diagnosed a deadlock problem in my sql server using the deadlock graph in SQL Server 2008.
The problem has to do with my indexes. I have two queries: a long running report with alot of join...
Mosul asked 3/8, 2012 at 17:49
3
If following situation a bug in mysql?.
Mysql Version: mysql.x86_64 5.0.77-4.el5_4.1
Kernel: Linux box2 2.6.18-128.el5 #1 SMP Wed Jan 21 10:41:14 EST 2009 x86_64 x86_64 x86_64 GNU/Linux
------...
Sarong asked 25/1, 2010 at 12:13
2
Solved
Here are the few lines of response of 'SHOW ENGINE INNODB STATUS;'
TRANSACTIONS
------------
Trx id counter 58EC54C6
Purge done for trx's n:o < 58EC54C3 undo n:o < 0
History list length 2...
Tinsel asked 28/6, 2012 at 11:29
1
Solved
In MySQL+InnoDB, suppose I have a single table, and two threads which both do "SELECT ... FOR UPDATE". Suppose that both of the SELECT statements end up selecting multiple rows, e.g. both...
Whitacre asked 13/6, 2012 at 3:40
4
Solved
Here's the scenario:
I've got a table called MarketDataCurrent (MDC) that has live updating stock prices.
I've got one process called 'LiveFeed' which reads prices streaming from the wire, qu...
Evangelineevangelism asked 11/6, 2010 at 13:1
3
Our application (which uses NHibernate and ASP.NET MVC), when put under stress tests throws a lot of NHibernate transaction errors. The major types are:
Transaction not connected, or was disconne...
Dint asked 3/8, 2010 at 7:34
1
Solved
Does oracle keeps any history about deadlocks?
e.g. Can i know which sqls were executed when the deadlock was detected, and oracle exception ORA-00060 (deadlock detected while waiting for resource...
Reisman asked 24/10, 2011 at 11:22
1
Solved
Can someone please help me to read/understand this deadlock graph?
I don't understand why process 75 is requesting a lock on an object that he has a lock on already?
Chuipek asked 1/9, 2011 at 8:43
3
Solved
I have these two exceptions generated when I try to get data from SQL database in C#:
System.Data.SqlClient.SqlException: Transaction (Process ID 97) was deadlocked on lock resources with anothe...
Maffick asked 30/11, 2010 at 10:18
1
Solved
How to do a safe "SELECT FOR UPDATE" with a WHERE condition over multiple tables on a DB2?
Problem
On a DB2 (version 9.5) the SQL statement
SELECT o.Id FROM Table1 o, Table2 x WHERE [...] FOR UPDATE WITH RR
gives me the error message SQLSTATE=42829 (The FOR UPDATE clause is not allow...
Sukkoth asked 7/10, 2010 at 13:11
1
Solved
Subquestioning SQL - when should you use “with (nolock)”
In one local financial institution I was rebuked by their programmers for expressing them my opinion that (their programmers' obsession wit...
Gael asked 1/10, 2010 at 1:53
3
Solved
I am receiving a lot of deadlocks in my big web application.
How to automatically re-run deadlocked transaction? (ASP.NET MVC/SQL Server)
Here I wanted to re-run deadlocked transactions, but I w...
Dilapidate asked 31/5, 2010 at 17:43
3
Solved
i have a stored procedure that performs a join of TableB to TableA:
SELECT <--- Nested <--- TableA
Loop <--
|
---TableB
At the same time, in a transaction, rows are inserted into Ta...
Catapult asked 4/3, 2010 at 20:13
5
Solved
I am looking for a good strategy of dealing with database deadlocks from within a Java 6 application; several parallel threads could, potentially, write into the same table at the same time. The da...
Disincentive asked 8/12, 2009 at 11:9
3
When running a stored procedure (from a .NET application) that does an INSERT and an UPDATE, I sometimes (but not that often, really) and randomly get this error:
ERROR [40001] [DataDirect][ODBC...
Selfseeker asked 10/7, 2009 at 0:48
4
We've got a web-based application. There are time-bound database operations (INSERTs and UPDATEs) in the application which take more time to complete, hence this particular flow has been changed in...
Flourishing asked 5/10, 2009 at 14:23
© 2022 - 2024 — McMap. All rights reserved.