Questions tagged [deadlock]

25 questions
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…
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
1
vote
1 answer

Codeignitor - under login / session load MySQL CPU spike and Fatal MySQL Deadlock

Originally posted on stackoverflow, and was recommended serverfault may be better place. I have a site using: AWS RDS (MySQL Aurora) - single t3.medium instance 4 x EC2s on a Load Balancer (fixed instances not elastic) CodeIgnitor 3 codebase…
rjbathgate
  • 185
  • 1
  • 2
  • 12
0
votes
1 answer

Apache is getting SUSPENDED in MSSQL by another process when doing more than 5-6 queries via PHP PDO resulting in timeout

I will try to be as detailed as possible. Up until now I was only using Stack Overflow and other sites like this but never posting. I was always able to find the answer to my question. But not this time. I have a Mu Online game server setup and…
anhimu
  • 1
  • 2
0
votes
2 answers

Table has no clustered index so what happens if i rebuild indexes?

We have a vendor app that has a SQL Server 2005 database. During data entry, app writes data to a table that has no clustered indexes on it. It has a number of indexes on the table, though. I used the Maintenance Plan wizard to rebuild the indexes…
Ra Osolage
  • 173
  • 2
  • 2
  • 10
0
votes
1 answer

Deadlock after transferring to another IIS Server

We transferred an old ASP application from Windows 2000 to Windows 2008 R2 to upgrade its performance. We only transfer the ASP application, the database is still the same. After successful transfer, the users of the web application encounters a…
0
votes
1 answer

Zombie connections on tomcat server while using mod_proxy_ajp

I'm using tomcat server 7 with apache mode_proxy_ajp module to serve a website. Here is my ajp connector config:
Ehsan Khodarahmi
  • 305
  • 1
  • 7
  • 18
0
votes
1 answer

JBoss 4.2 Deadlocking

Greetings, Not sure if this is one for here or stackoverflow but here goes: I have deployed a J2EE application on JBoss 4.2 with a MySQL backend. While stress testing the application I've discovered many: …
kobrien
  • 131
  • 10
0
votes
1 answer

Identifying thread deadlocks in WebSphere

In WebSphere 8.5.5.13 I have some out of memory errors and the database connections get maxed out. It seems to me this is due to thread starvation (I have some processes trying to do something with a timeout of 10 seconds and other tasks that…
Frabac
  • 3
  • 1
-2
votes
1 answer

TCP ports duplication

I need to communicate server1 to server2. Server1 should have to fetch some records from Server2 when we execute program.exe will make server1 to fetch server2 When I gave netstat -an | find "server2" I Could see that some of the TCP ports are…
1
2