Outdated Version

You are viewing an older version of this section. View current production version.

CLEAR ORPHAN DATABASES

Info

SingleStore Managed Service does not support this command.

Removes orphaned partitions. Orphaned partitions are partition databases on leaf nodes that are no longer considered part of the cluster.

Syntax

CLEAR ORPHAN DATABASES;

Remarks

Alert

This command cannot be undone.

  • The master aggregator avoids dropping orphan partition databases if there is no corresponding master partition.

  • To detect orphan partitions, run SHOW CLUSTER STATUS and check for partitions with the role of Orphan.

  • Before running CLEAR ORPHAN DATABASES, run: EXPLAIN CLEAR ORPHAN DATABASES; to see which partitions will be dropped.

Related Topics