{question}
How do I check whether an SM is Running or Syncing from the database?
{question}
{answer}
The table system.nodes gather all the information for each node (Storage [SM], Transaction [TE]).
SQL> select * from system.nodes;
ID LOCALID PORT ADDRESS HOSTNAME STATE TYPE CONNSTATE MSGQSIZE TRIPTIME GEOREGION PLATFORM_VER RELEASE_VER
--- -------- ----- ----------- ------------------------ ------- ----------- ---------- --------- --------- -------------- ------------- ------------------
1 2 41219 10.9.38.229 support.hurley.nuodb.com Running Storage Ready 1 203 DEFAULT_REGION 589824 2.5.5-3-932b3382b5
2 1 41362 10.9.38.229 support.hurley.nuodb.com Running Transaction Ready 2 330 DEFAULT_REGION 589824 2.5.5-3-932b3382b5
3 3 33736 10.9.38.229 support.hurley.nuodb.com Running Storage Ready 2 337 DEFAULT_REGION 589824 2.5.5-3-932b3382b5
4 0 43158 10.9.38.229 support.hurley.nuodb.com Running Transaction Ready 0 0 DEFAULT_REGION 589824 2.5.5-3-932b3382b5
You may find more information on this topic by clicking here.
If you have any questions, please reach out by clicking here.
{answer}
Comments