Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [deadlock]

25 questions
1
vote
0 answers

MySQL Temporary table insert hangs and locks other queries

I have a MySQL 5.7.30 as storage for a Magento 2 shop. During the magento reindex process (a PHP process that transforms data into various tables for faster retrieval), some temporary tables are created and filled. These queries should be very fast,…
king_nak
  • 193
  • 1
  • 1
  • 6
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
  • 75
  • 2
  • 11
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
2 answers

Mysql transaction hung - persists after server restart

select * from INFORMATION_SCHEMA.INNODB_TRX\G; *************************** 1. row *************************** trx_id: 41844623 trx_state: RUNNING trx_started: 2016-11-23 15:40:42 …
user190084
  • 101
  • 2
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…
pvzkch
  • 11
  • 1
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
  • 285
  • 1
  • 7
  • 17
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…
Niveditha
  • 1
1
2