deadlock Questions

4

Solved

I have a multithreaded application that tries to INSERT a record in a table in multiple batches. Each thread processing one batch. At times I get Deadlock error, following is the trace. The table ...
Formalism asked 10/9, 2015 at 9:48

7

I have a simple table CREATE TABLE test ( col INT, data TEXT, KEY (col) ); and a simple transaction START TRANSACTION; SELECT * FROM test WHERE col = 4 FOR UPDATE; -- If no results, genera...
Ladonnalady asked 2/3, 2017 at 5:38

9

Solved

Our client side code detects deadlocks, waits for an interval, then retries the request up to 5 times. The retry logic detects the deadlocks based on the error number 1205. My goal is to test both...
Sanitarian asked 19/7, 2012 at 21:59

0

When I run Program 1 with command go run main.go it terminates with error all goroutines are asleep - deadlock! while the Program 2 keep waiting and does not terminate. We are not calling che...
Transgression asked 27/4 at 15:40

18

Probably between 25 and 50% of the times I build my solution, I see this: "The operation you requested is taking longer than expected to complete. This dialog will close when the action completes....
Handlebar asked 25/9, 2013 at 21:13

2

I stumbled upon a problem with Virtual threads and ConcurrentHashMap. As the code below demonstrates, if you enter a lock within the computeIfAbsent, the VT may not awake, ever. It really depends h...
Dagda asked 22/1 at 16:55

6

Solved

I'm really uncertain about the requirements POSIX places on the safety of fork in the presence of threads and signals. fork is listed as one of the async-signal-safe functions, but if there is a po...
Denunciation asked 15/12, 2010 at 19:8

4

Solved

So as I understand it, SQL deadlocks happen when a SPID is busy processing another query and it can't be bothered to run another one because it's so busy right now. The SQL Server "randomly" picks ...
Admixture asked 21/7, 2011 at 19:10

2

Solved

Note: This question concerns C++11. The answer to the same question in C++17 (or later revisions) may have changed. For details: std::lock_guard or std::scoped_lock? When we want to lock mult...
Nailhead asked 14/6, 2013 at 16:56

2

My program appears to run in a deadlock sometimes when I hit Ctrl+C. I'm trying to catch the keyboard interrupt and gracefully stop all running threads, but I'm not quite there yet. I'm using a co...
Hammack asked 6/11, 2017 at 23:4

7

I have a C# application which is inserting data into SQL Server (2008) table using stored procedure. I am using multi-threading to do this. The stored procedure is being called from inside the thre...
Petrochemical asked 9/2, 2012 at 14:2

4

Solved

For one of my requirement I have to create N number of worker go routines, which will be monitored by one monitoring routine. monitoring routine has to end when all worker routines completes. My co...
Allow asked 10/11, 2013 at 17:29

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

18

Solved

When writing multi-threaded applications, one of the most common problems experienced are deadlocks. My questions to the community are: What is a deadlock? How do you detect them? Do you hand...
Efrainefram asked 29/8, 2008 at 15:56

1

I came across the following in an MSDN Article: clientoption1 and clientoption2. Set options on this client connection. This is a bitmask that includes information about options usually con...
Negligee asked 17/9, 2010 at 5:4

1

Solved

In his book, C++ Concurrency in Action, A. Williams introduces the concept of a lock hierarchy as a deadlock-avoidance mechanism. Below, I report a stripped down version of a HierarchicalMutex impl...
Nefen asked 23/10, 2022 at 14:28

4

I have a mobile application and server based on Symfony which gives API for the mobile app. I have a situation, where users can like Post. When users like Post I add an entry in ManyToMany table t...
Hamon asked 30/12, 2017 at 15:25

3

Solved

I see an error message related to transaction isolation levels. There are two tables involved, first one is updated frequently with transaction isolation level set to SERIALIZABLE, the second one h...
Marcelenemarcelia asked 24/2, 2011 at 9:0

4

Solved

I have usually heard that it is a good idea to unlock any locks before calling event listeners to avoid deadlock. However, since the lock {} block is reentrant by the same thread in C#, is it OK to...
Millikan asked 19/12, 2009 at 5:56

9

Solved

How could something equivalent to lock in C# be implemented in JavaScript? So, to explain what I'm thinking a simple use case is: User clicks button B. B raises an onclick event. If B is in even...
Hash asked 17/3, 2011 at 23:57

3

I have an application connected to a SQL Server 2014 database that combines several rows into one. There are no other connections to this database while the application is running. First, select a...
Thrasher asked 14/11, 2016 at 9:25

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

1

Solved

Will code like these ever produce a deadlock using a DashMap in Rust? // snippet_1 let a = DashMap::new(); let b = DashMap::new(); // thread1 for v in a.iter(){ xxx } for v in b.iter(){ xxx } /...
Helbonna asked 10/12, 2021 at 4:59

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

© 2022 - 2024 — McMap. All rights reserved.