Forum: Managing VoltDB

Post: How to programmatically check if a VoltDB instance is in admin mode?

How to programmatically check if a VoltDB instance is in admin mode?
cfogelberg
Oct 25, 2016
How do I check from the terminal if a VoltDB instance is in admin mode or not? (I'd rather not grep the log for "Starting in admin", "entering admin" and "exiting admin"...)

Thanks,
Christo
bballard
Oct 25, 2016
You can get this from @SystemInformation OVERVIEW, the CLUSTERSTATE property will be either RUNNING or PAUSED.

For example:
$ echo "exec @SystemInformation OVERVIEW;" | sqlcmd | grep CLUSTERSTATE
0 CLUSTERSTATE RUNNING
$ voltadmin pause
$ echo "exec @SystemInformation OVERVIEW;" | sqlcmd | grep CLUSTERSTATE
0 CLUSTERSTATE PAUSED
cfogelberg
Oct 25, 2016
Nice thanks - Christo