Blocked Duration

Condition

Query is stuck in BLOCKED status. It is usually caused by other transactions holding locks on specific objects.

How to fix

• Consider re-writing ETL jobs to avoid locks

• Consider adding concurrency limit to run only one job instance in parallel.

Example

    BlockedDurationCondition(
        notice_duration=60 * 5,  # query was locked by another transaction for 5 minutes
    ),

Specific arguments

None. Only standard duration arguments are applied for this checker.