DB and TE connection

 

{question}

From client connection to the database, how can I check to which TE I am connected? 

{question}

 

{answer}

In case of a multiple TEs system, a connection to the database using nuosql process will choose the current available TE randomly.

To get the information for the currently connecting TE:

SQL> select * from system.nodes where localid=0;

ID LOCALID PORT ADDRESS HOSTNAME STATE TYPE CONNSTATE MSGQSIZE TRIPTIME GEOREGION PLATFORM_VER RELEASE_VER
--- -------- ----- ----------- ----------------------------------------- ------- ----------- ---------- --------- --------- -------------- ------------- -----------------

2 0 48006 10.16.0.202 ip-10-16-0-202.us-east-2.compute.internal Running Transaction Ready 0 0 DEFAULT_REGION 851968 3.0-11-9695a774cc

From this example, we are currently connected to NODEID=2.

 

More information can be found here

{answer}

 
Have more questions? Submit a request

Comments