Following deadlock is encountered while load testing a application. After going through MySQL documentation and other online resources what I figured out was that
1) Transaction (2) holds exclusive ...

I have a table of around 500k rows (not big data), that I need to query against itself and then delete some of the rows which don't match the filters.
At the moment my query looks like this:
DELETE ...

I am trying hard to figure out what may be going wrong for below shown deadlock graph:
I am receiving alerts for deadlocks similar to above for almost every 10 minutes, it's just the query changes, ...

We are using MYSQL database for an Analytics app. I have two table token and token-big (for overview of actual data) both have id(int) unix_starttime(int) unix_endtime(int) details(varchar 256)
A row ...

We get the next ID for our tables from a separate table with two columns, TABLE_NAME and NEXT_ID. We have a stored procedure which reads the NEXT_ID and then adds an increment to the NEXT_ID. The work ...

I know that PostgreSQL will detect and clear deadlock once it happen by cancelling one of the queries. How does PostgreSQL decide which one to cancel? Is this deterministic or there is some randomness ...

I have a few production SQL Server instances and I get around 100 deadlock alert emails a day (up to 100 for one server, 150 in total).
Is this a problem I should investigate? How many deadlocks are ...

Using MySQL 5.6.17. I have a table with an INSERT trigger that reads values from that table and 4 other tables, combines the results and writes that to a sixth table. Ever since I added this trigger, ...

I am having problems with frequent deadlocks on a subscription database.
I am considering enabling the snapshot isolation level for that database.
I am aware that there is an overhead on the tempDb ...

I see that I can view the latest deadlock in mysql/innodb, but is there a way to view past deadlocks? We have two deadlock issues, one being important and the other not. The less important deadlock ...

Can someone explain this deadlock to me? It seems as if there are 2 inserts happening within milliseconds of each other with the same Primary Key. I'm not sure how this can cause a deadlock. At most a ...

As was asked on stackoverflow but then for MySQL, I was wondering how this works in PostgreSQL. How many rows get locked when I do a "FOR UPDATE" in combination with a "LIMIT", a "ORDER BY" and some ...

I am trying to analyze randomly occurring deadlock problems on an SQL Server 2008 R2 database. The deadlocks occur in very rare cases when SSRS tries to access one of 5 different stored procedures.
...