Questions tagged [deadlock]
25 questions
5
votes
1 answer
how can I diagnose a "frozen" linux software raid device?
I have a server running Linux 3.2.12 32-bit i686 with 13 drives: 1 boot drive, and 3 raid5 devices of 4 drives each.
/proc/mdstat shows
Personalities : [raid1] [raid10] [raid6] [raid5] [raid4]
md2 : active raid5 sdd1[3] sdc1[2] sdb1[1] sda1[0]
…
dataless
- 833
- 7
- 11
3
votes
3 answers
Why are my deadlocks not shown by SHOW ENGINE INNODB STATUS;?
I have a MariaDB (5.5.41) cluster made of 2 nodes configured as master-slave. All reads and writes are sent to the same node.
I have been investigating some deadlock issues for a few weeks.
On a regular basis, my PHP application returns Message:…
liquidity
- 408
- 1
- 7
- 22
2
votes
1 answer
Deadlock trigger on MariaDB Galera cluster
I can trigger a deadlock on our (test) Galera cluster when updating a row with the same data.
INSERT INTO test (id, val) VALUES (1, 42), (2, 47);
-- Query OK, 2 rows affected (0.01 sec)
-- Records: 2 Duplicates: 0 Warnings: 0
Updating a value to…
Gert
- 198
- 3
- 12
2
votes
3 answers
Nexenta/OpenSolaris filer kernel panic/crash
I've an x4540 Sun storage server running NexentaStor Enterprise. It's serving NFS over 10GbE CX4 for several VMWare vSphere hosts. There are 30 virtual machines running.
For the past few weeks, I've had random crashes spaced 10-14 days apart. This…
ewwhite
- 194,921
- 91
- 434
- 799
1
vote
0 answers
NGinX + PHP-FPM Microservices deadlock
I have a number of small services that are running spread across two servers:
Server A) manages high security services: User accounts and personal messaging.
Server B) manages low security services: Image uploads and public stuff.
Here comes the…
César
- 111
- 2
1
vote
3 answers
Oracle DB Deadlocks
We have a situation where a db is "slowing down". DB operations that normally take a second or two are taking ten times as long. There appear to be a large number of locks in the DB when this is happening. Could a large number of deadlocks be…
jeffspost
- 139
- 3
- 5
- 14
1
vote
0 answers
ddrescue a failing hard drive; getting a kernel module deadlock
I'm in the process of recovering a dying hard-drive with ddrescue. The utility works very well in the parts of the drive that have not problems but in the parts of the drive with problems it goes very slow and seems to be causing a deadlock in some…
u8sand
- 111
- 1
1
vote
2 answers
When to change SQL 2005 max worker threads on 64-bit server
Server Environment:
Windows 2003 Standard R2 x64 SP2
SQL 2005 Enterprise 64-bit SP2
HP ProLiant BL460c G1, Xeon E5440 2.83 Ghz processors (Quad-core)
8 GB RAM
EDIT: I should also note that max_workers_count is currently at the default 512 for a 4…
squillman
- 37,618
- 10
- 90
- 145
1
vote
2 answers
SQL 2005 Deadlocks: Running Traces & Examining Logs
We have a 3rd party commercial application which we believe is causing deadlocks to occur on our SQL Server 2005 (64bit) machine. Coming away from a 1 & 1/2 day training with the software vendor last week to help us better administer the software,…
David W
- 3,405
- 5
- 34
- 61
1
vote
4 answers
sql deadlocking and timing out almost constantly
Looks like today is going to be another rubbish one.
We have recently updated our sql box with a complete monster, with loads of cores and ram, however we are stuck with our old DB schema which is crapola.
Our old sql box had problems but nothing…
nat
- 163
- 2
- 7
1
vote
2 answers
Mysql Logging all deadlocks
I have a MySql DB that is encountering some deadlocks.
I want the log all deadlocks, any thoughts of how to do this?
Ran
- 123
- 9
1
vote
1 answer
Help, SQL 2008 table locked after large update!
I had a large update statement run over the weekend that took approximately 6.5 hours to complete. That was 2 days ago (friday evening, today is monday morning).
The table has 77million records in it, and about 10 fields were updated.
Monday…
EWizard
- 11
- 2
1
vote
1 answer
MySQLdump deadlock on a myisam table?
Today I woke up with our production server down. Not happy.
We pinpointed the problem to a daily cronjob, that does a full mysqldump from the production database, to a remote server.
The SQL command were simply
mysqldump -u myuser -pmypassword…
Silver Dragon
- 223
- 1
- 2
- 7
1
vote
2 answers
What's the best way to monitor SQL Server Concurrency issues?
What's the best way to monitor SQL Server Conccurency issues?
Specifically my goal is to reduce or prevent deadlocks and blocking and to catch potential concerns before they become a problem.
For example if I were to monitor windows performance…
Michael J Swart
- 185
- 1
- 7
1
vote
2 answers
IIS mystery: "Deadlock detected" periodically makes site unavailable
A few times a day, our vb.net (IIS 6.0) website is randomly throwing the following error and becomes completely unavailable for 5-15 minutes at a time while the application is recycled:
ISAPI…
jskunkle
- 121
- 1
- 4