v.23.1Experimental Feature

Added SYSTEM DROP DATABASE REPLICA Command to Remove Dead Replicas

Added SYSTEM DROP DATABASE REPLICA that removes metadata of a dead replica of a Replicated database. Resolves #41794. #42807 (Alexander Tokmakov).
Introduced SYSTEM DROP DATABASE REPLICA command to remove metadata of dead replicas in Replicated databases.

Why it matters

This feature resolves issues with stale or dead replicas by allowing users to clean up their metadata, ensuring cluster stability and preventing conflicts caused by orphaned replica information.

How to use it

Use the command:

SYSTEM DROP DATABASE REPLICA 'replica_name'


to remove the metadata of a dead replica from a Replicated database.