Technologies/PostgreSQL/postgresql.subscription.apply_error
PostgreSQLPostgreSQLMetric

postgresql.subscription.apply_error

Subscription apply errors
Dimensions:None
Available on:DatadogDatadog (1)Native (1)
Interface Metrics (2)
DatadogDatadog
Number of errors that occurred while applying changes. Extracted from pg_stat_subscription_stats. Only available on PostgreSQL 15 or higher. This metric is tagged with subscription_name.
Dimensions:None
Native
apply_error_count statistic from pg_stat_subscription_stats
Dimensions:None
Sources
postgresql.subscription.apply_errorgithub.com
apply_error_countgithub.com

Technical Annotations (18)

Configuration Parameters (2)
disable_on_error
Subscription option to automatically disable on errors before using pg_replication_origin_advance()
track_commit_timestamprecommended: enabled
Required to log origin and commit timestamp details of conflicting keys for better conflict resolution
Error Signatures (6)
duplicate key value violates unique constraintlog pattern
CONTEXT: processing remote data for replication originlog pattern
ERROR: conflict detected on relationlog pattern
conflict=insert_existslog pattern
conflict=update_existslog pattern
conflict=multiple_unique_conflictslog pattern
CLI Commands (3)
ALTER SUBSCRIPTION ... SKIPremediation
ALTER SUBSCRIPTION ... DISABLEremediation
pg_replication_origin_advance()remediation
Technical References (7)
pg_replication_origin_advance()componentpg_replication_origin_statuscomponentfinish LSNconceptreplication originconceptrow-level securitycomponentsubscription ownerconceptpg_stat_subscription_statscomponent
Related Insights (5)
Logical replication stops on constraint violations requiring manual resolutioncritical
▸
Row-level security on subscriber tables causes replication conflictswarning
▸
Permission failures on target tables halt logical replicationcritical
▸
Logical replication stops on unique constraint violation conflictscritical
▸
Permissions failures on subscriber cause replication conflictscritical
▸