Technologies/PostgreSQL/apply_error_count
PostgreSQLPostgreSQLMetric

apply_error_count

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 (13)

Configuration Parameters (2)
track_commit_timestamprecommended: enabled
Required to log origin and commit timestamp details of conflicting keys for better conflict resolution
disable_on_errorrecommended: true
Automatically disables subscription on error, preventing need for manual intervention before advancing replication origin
Error Signatures (4)
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 (4)
pg_stat_subscription_statscomponentpg_replication_origin_statuscomponentfinish LSNconceptreplication originconcept
Related Insights (1)
Logical replication stops on unique constraint violation conflictscritical
▸