handle_diagnose_locks
Analyzes and resolves lock contention in Redshift clusters by identifying active locks, filtering by process ID, table name, or wait time, and providing detailed reports for troubleshooting.
Instructions
Identifies active lock contention in the cluster.
Fetches all current lock information and then filters it based on the
optional target PID, target table name, and minimum wait time.
Formats the results into a list of contention details and a summary.
Args:
ctx: The MCP context object.
target_pid: Optional: Filter results to show locks held by or waited
for by this specific process ID (PID).
target_table_name: Optional: Filter results for locks specifically on
this table name (schema qualification recommended
if ambiguous).
min_wait_seconds: Minimum seconds a lock must be in a waiting state
to be included. Defaults to 5.
Returns:
A list of dictionaries, where each dictionary represents a row
from the lock contention query result.
Raises:
DataApiError: If fetching the initial lock information fails.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| min_wait_seconds | No | ||
| target_pid | No | ||
| target_table_name | No |
Input Schema (JSON Schema)
{
"properties": {
"min_wait_seconds": {
"default": 5,
"title": "Min Wait Seconds",
"type": "integer"
},
"target_pid": {
"anyOf": [
{
"type": "integer"
},
{
"type": "null"
}
],
"default": null,
"title": "Target Pid"
},
"target_table_name": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Target Table Name"
}
},
"title": "handle_diagnose_locksArguments",
"type": "object"
}