database-deadlocks Questions
3
Solved
I'm a little bit confused reading about PostgreSQL deadlocks.
A typical deadlock example is:
-- Transaction 1
UPDATE customer SET ... WHERE id = 1
UPDATE customer SET ... WHERE id = 2
-- Transac...
Duala asked 20/4, 2012 at 11:41
4
I have an error log which reports a deadlock:
Transaction (Process ID 55) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim....
Semasiology asked 25/9, 2013 at 4:19
7
Solved
What is the difference between wait-die and wound-wait algorithms?
It seems that both of these deadlock prevention techniques are doing the same thing: A Rollback of older process.
What is the diff...
Selfassured asked 26/9, 2015 at 5:58
1
Solved
Ok, I'm totally lost on deadlock issue. I just don't know how to solve this.
I have these three tables (I have removed not important columns):
CREATE TABLE [dbo].[ManageServicesRequest]
(
[Referen...
Frodi asked 16/12, 2021 at 10:53
3
I am seeing a deadlock with MySQL 5.6 because of what seems like trying to lock the same row/s twice.
From the snippet below, rows where id = (11, 12, 13, 14, 15) already have a lock. And when ano...
Odessa asked 26/7, 2013 at 22:45
5
Solved
What is a deadlock in SQL Server and when it arises?
What are the issues with deadlock and how to resolve it?
Commonality asked 5/5, 2010 at 16:12
2
Solved
Update: Potential solution below
I have a large corpus of configuration files consisting of key/value pairs that I'm trying to push into a database. A lot of the keys and values are repeated acros...
Bowerman asked 6/2, 2015 at 14:1
3
Solved
Is it appropriate for a server to return 503 ("Service Unavailable") when the requested operation resulted in a database deadlock?
Here is my reasoning:
Initially I tried avoiding database deadl...
Apocynthion asked 18/5, 2013 at 20:37
3
Solved
Why does dropping a table in PostgreSQL require ACCESS EXCLUSIVE locks on any referenced tables? How can I reduce this to an ACCESS SHARED lock or no lock at all? i.e. is there a way to drop a rela...
Gymnosperm asked 21/8, 2015 at 16:26
1
We had a weird issue in development and are looking for an explanation on a self-deadlock issue with a SELECT INTO on a temp table.
We have a routine to transform some fairly complicated JSON docum...
Vargas asked 17/9, 2020 at 13:59
2
Solved
I am seeing constant deadlocks in my app, even though it performs no select statements, no delete statements, and no update statements. It is only inserting completely new data.
TL;DR: It seems to ...
Rarotonga asked 8/8, 2020 at 9:55
6
Solved
I've implemented a generic repository and was wondering if there is a smart way to implement a retry logic in case of a deadlock exception?
The approach should be the same for all repository metho...
Touch asked 31/10, 2012 at 13:40
1
I'm getting deadlocks in my MySQL InnoDB tables. InnoDB log pinpoints two queries that resulted in deadlock (it's two exact same queries, both parts of exact same transactions, resulting from almos...
Ruyle asked 28/10, 2017 at 9:2
2
I'm having a deadlock and I'm trying to figure out the reasoning behind it.
The question can be reduced to this:
table:
create table testdl (id int auto_increment, c int, primary key (id), key i...
Missi asked 2/3, 2017 at 2:2
1
My original problem was that I was experiencing deadlocks often when updating my SQL database. Through a little bit of research, I found that I'm able to define a custom DbConfiguration and with it...
Cumbrous asked 10/4, 2018 at 11:54
2
Solved
WARNING!!! TL;DR
MySQL 5.6.39
mysql:mysql-connector-java:5.1.27
org.hibernate.common:hibernate-commons-annotations:4.0.5.Final
org.hibernate.javax.persistence:hibernate-jpa-2.1-api:1.0.0.Final
o...
Tman asked 18/3, 2019 at 5:6
2
I have a stored procedure with the following two transactions under Begin and Commit tran.
UPDATE mytable
SET UserID = @ToUserID
WHERE UserID = @UserID
DELETE FROM mytable
WHERE UserID = @UserID...
Ac asked 8/2, 2019 at 17:31
3
I'm running into a deadlock after I added a trigger. There is a UserBalanceHistory table which has one row for each transaction and an Amount column. A trigger was added to sum the Amount column an...
Steersman asked 8/6, 2011 at 17:4
4
I have a query locking tables in MySQL (using InnoDB):
UPDATE table SET status = 2 WHERE status = 3
This query caused a deadlock on the table and can't bypass it.
I tried to do:
show processli...
Bethany asked 10/4, 2013 at 17:1
2
Solved
I have a table on a PostgreSQL 9.1 server like this:
CREATE TABLE foo(id integer PRIMARY KEY);
In an interactive Python shell with psycopg2 (≥ 2.4.2), I might start a connection and cursor, and ...
Priggery asked 21/4, 2016 at 5:20
1
Solved
Assume some_table has two rows, with primary key 1 and 2. The following sequence of statements can cause a deadlock:
session 1: begin;
session 2: begin;
session 1: DELETE FROM my_table WHERE my_ke...
Mcclean asked 22/8, 2018 at 15:3
1
Solved
This question can be considered as a follow-up on my comment on Can two concurrent but identical DELETE statements cause a deadlock?.
I am wondering if the rows are locked in ascending my_status o...
Agogue asked 22/8, 2018 at 17:27
5
Solved
I am using Magento 1.7.0.2 Community Edition and I have encountered a big problem - deadlocks and "Lock wait timeout exceeded" errors. Problem exists while specific CRON tasks are executed
Impor...
Nahamas asked 9/11, 2012 at 13:50
3
I have a C# project which writes data to a TSQL database. There are two update statements which run within a loop, eg.:
for (int i = 0; i < customersProducts.Count; i++) {
CustomerProducts c ...
Bennion asked 26/2, 2018 at 1:54
2
Solved
The design for the Big Transaction..
START TRANSACTION;
/*
INERT for login detail
*/
/*
INSERT for personal information
*/
/*
INSERT for user's transaction account
*/
COMMIT;
and the d...
Tidy asked 30/7, 2015 at 4:16
1 Next >
© 2022 - 2024 — McMap. All rights reserved.