Delete StorageGroup

This is a NuoDB Manager command. See NuoDB Manager.

Description

This enables you to delete UNAVAILABLE storage groups from a database.

Deleting a storage group resolves all stranded transactions that have been waiting for a storage manager.

A storage group can only be deleted from the database if it was previously removed from all online SMs. See Remove StorageGroups.

When a storage group dies or an admin decides for any other reason that a dead storage group will never be restarted, it must be administratively deleted.

Syntax

DELETE storageGroup $name $database
    name storage_group_name
    database test     

Parameters

Interactive Example

First, you need to confirm unavailability following usage of the Remove StorageGroups command.

Now, use the show storageGroups command (see Show StorageGroups) to check what storage groups the database is currently servicing.

nuodb [domain] > show storageGroups
Database: test 
[id=10] SG1  Unavailable

Delete storage group SG1 from the SM running on 52.11.92.215:

nuodb [domain] > delete storageGroup
Storage group name: sg1
Database: test
Success

Scripting Example

In nuodbmgr, $ params are given keyword style, so to delete storage group sg1 from database test, you would issue this command as follows:

nuodbmgr --broker host --password password \
    --command "delete storageGroup name sg1 database test"

Notes

The storage group must be UNAVAILABLE (not actively served by any running storage manager). If the storage group is not in the UNAVAILABLE state you will receive an error message as follows:

nuodb [domain] > delete storageGroup
Storage group name: sg1
Database: test
Failure: Failed to delete storage group: The storage group cannot be deleted because an SM is serving it.

If you delete a storage group served by an SM that is currently not running, that storage group will remain deleted even if you restart that SM.