database-deadlocks Questions
2
We have an application which reads from a data stream and upserts that information into a database. The data is changes which occur on Google Drive which means that many events which impact the sam...
Largehearted asked 22/9, 2017 at 13:45
2
Solved
I need to do a Postgres update on a collection of records & I'm trying to prevent a deadlock which appeared in the stress tests.
The typical resolution to this is to update records in a certa...
Kragh asked 20/6, 2017 at 18:17
1
I run multiple servers and each of them are running multi-update statements such as these
UPDATE user SET ... WHERE user_id = 2;
UPDATE user SET ... WHERE user_id = 1;
UPDATE user SET ... WHERE us...
Loupe asked 26/8, 2014 at 13:58
2
Example:
START TRANSACTION;
UPDATE books SET printedCount=1000 WHERE id=5;
How can I find which rows of table books are locked by opened transactions (or ids, primary keys of these rows)? I want...
Leastways asked 16/12, 2016 at 15:38
1
I recently encountered an issue on a live application.
I realized I had more and more concurrency exceptions and locks with a database.
Basically I start a transaction which requires a SELECT and ...
Kelula asked 26/1, 2016 at 14:48
1
Solved
I have a python script that executes multiple sql scripts (one after another) in Redshift. Some of the tables in these sql scripts can be queried multiple times. For ex. Table t1 can be SELECTed in...
Pickup asked 27/2, 2017 at 14:48
1
Solved
In postgres log:
2016-12-23 15:28:14 +07 [17281-351 trns: 4280939, vtrns: 3/20] postgres@deadlocks HINT: See server log for query details.
2016-12-23 15:28:14 +07 [17281-352 trns: 4280939, vtrns: ...
Acceptor asked 23/12, 2016 at 10:34
2
I have searched for quite some time now and can't found a solution to my problem. We are using SQLAlchemy in conjunction with MySQL for our project and we encounter several time the dreaded error: ...
Granulate asked 16/5, 2014 at 14:32
3
Solved
I keep getting this exception in my Tomcat log:
com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector run
WARNING: com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@7...
Toland asked 7/8, 2013 at 10:1
3
Solved
After executing this query on master db ,it is giving me all running process on all databases,
is there any query which will kill all process running on a database .
USE
Master
GO
SELECT
SPID,DBI...
Arpeggio asked 11/6, 2012 at 7:48
3
Solved
I have a Windows Azure role that consists of two instances. Once in a while a transaction will fail with an SqlException with the following text
Transaction (Process ID N) was deadlocked on lock...
Rosana asked 3/11, 2011 at 11:10
1
Solved
I believe that each SELECT statement in SQL Server will cause either a Shared or Key lock to be placed. But will it place that same type of lock when it is in a transaction? Will Shared or Key lock...
Burford asked 29/2, 2016 at 21:40
1
I have menus, categories and products tables. I am using mysql 5.5, All tables are innoDB and in all cases id is the primary key (int) with autoincrement.
menus table
id, name, status
categories ...
Sergiosergipe asked 3/2, 2016 at 16:53
2
Solved
Here is table ( simplified ):
Table "public.link"
Column | Type | Modifiers
---------------+-----------------------------+---------------------------------------------------
id | integer | no...
Pyrexia asked 12/10, 2012 at 9:35
1
Solved
I want to collect post-mortem debugging information about both the "winner" transaction and the "loser" transaction(s) in a PostgreSQL deadlock.
I found this wiki page which includes some good li...
Madore asked 9/4, 2015 at 7:13
1
Solved
I have a situation where inserting new records into a SQL Server database table from a C# ASP.NET Web API causes deadlocks when hit with multiple threads. This is caused by an initial SELECT taking...
Strainer asked 28/3, 2015 at 7:47
1
Solved
We have a single table which does not have references to any other tables.
┬────────────┬─────────────┬───────────────┬───────────────╮
│id_A(bigint)│id_B(bigint) │val_1(varchar) │val_2(varchar) ...
Chart asked 19/11, 2014 at 1:5
1
Solved
I have the complex query that creates a temporary table that can take 5 seconds to run or more. This seems to be causing a deadlock when running another transaction on similar tables at the same ti...
Pyrometer asked 20/5, 2014 at 19:37
1
Solved
I'm getting deadlock in my MySQL table. Only a single table is involved, and I can consistently reproduce it. It only happens when I have multiple threads running the code.
Here is the table:
CRE...
Giron asked 12/5, 2014 at 17:52
2
Solved
Let's first forget about Hibernate. Assume that I have two tables, A & B. Two transactions are updating same records in these two tables, but txn 1 update B and then A, while txn 2 update A the...
Fronnia asked 27/9, 2012 at 7:35
2
Solved
I am new for PostgreSQL. I want to simulate deadlock for this schedule:
How to simulate deadlock in PostgreSQL? Is it possible at all? How to lock particular column?
BEGIN;
UPDATE deadlock_demonst...
Yockey asked 1/4, 2014 at 1:21
3
Solved
Database: MSSQL server 2012;
Isolation level: READ_COMMITTED_SNAPSHOT
Now I have a table "COV_HOLES_PERIODDATE". It has a composite primary key which is also a clustered index. No other indexes o...
Fever asked 18/3, 2014 at 19:43
1
I'm getting deadlock intermittently in my application. My application has 1 table e.g EMPLOYEE (ID (PK), NAME, SAL) and there are 2 sessions.
Session 1:
SELECT ID, NAME, SAL FROM EMPLOYEE WHERE ...
Impassible asked 11/10, 2013 at 17:51
2
Solved
I would like to understand better a mechanism of locking in postgres.
Let's say that tree can have apples (via foreign key on apple table). It seems that when selecting a tree for update lock is o...
Vice asked 30/8, 2013 at 15:6
1
In all the SQL deadlock examples I've seen so far, a deadlock appeared while executing a SELECT / UPDATE etc.
If all my statements were executed successfully, is there any chance the deadlock appe...
Dauntless asked 11/8, 2013 at 12:11
© 2022 - 2024 — McMap. All rights reserved.