New answers tagged locking
5
There are two type of timeouts.
One is when the client application (API) aborts the batch after a certain amount of time. Called "attention" in a SQL server trace. Default in many APIs is 30 seconds.
The other is when the client requests that SQL server abort the query with error 1222 after a certain time. SET LOCK_TIMEOUT. Default is indefinitely.
...
0
Those are not locks, those are wait event types. If you are searching for them specifically as lock types, that might prevent you from finding much. It would be nice to know what the actual wait events are, rather than just the general category. If POWA doesn't provide a way to drill down on that, you can inspect pg_stat_activity directly for the ...
1
Nobody is blocked by a lock.
The insert has finished long ago, but the application forgot to commit the transaction. That is an application error, and you should start investigating there.
Processing must be blocked somewhere in the client application, because it sure isn't blocked in the database.
I see some MultiXactOffsetControlLock in your ...
Top 50 recent answers are included
