diagnose_stuck_subscription
Explains the cause of a wedged logical replication subscription, identifies the conflicting row from the subscriber log, and presents two fixes: resolve the conflict or skip the offending transaction.
Instructions
Explain why apply is wedged and lay out the two real fixes.
Judgment tool (the marquee one). Correlates subscription error state with the LSN apply is stuck at, explains the usual cause (a unique/primary-key conflict on the subscriber), and presents the two options: resolve the conflicting row, or skip the offending transaction. Points you at the subscriber server log for the exact conflicting row. Run this on the SUBSCRIBER.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||