Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with deadlock
Search options not deleted
user 47887
A situation caused by two or more processes being unable to proceed (and thus release their locks) because they are blocked by locks on resources held by the other process.
1
vote
1
answer
233
views
MySQL deadlock in simple table
I'm having a deadlock issue that I don't get. Possibly it's because of the composite index (idSite,timestamp). Maybe it's range locking on it? … This is the complete deadlock info:
------------------------
LATEST DETECTED DEADLOCK
------------------------
2015-08-05 09:11:38 2b6fcbf25700
*** (1) TRANSACTION:
TRANSACTION 516854792, ACTIVE 0 sec …
- 191
2
votes
Accepted
MySQL deadlock in simple table
As requested, my solution to an old question.
The write intention lock docs say (emphasis mine, and yes, MySQL 5.7, because 8.0 didn't exist at the time):
An insert intention lock is a type of gap lo …
- 191