showdmlstorageevent 命令
语法:
gcadmin showdmlstorageevent [table ID segname nodeip] |<max_fevent_num>]
注:该命令格式与 8.5.1.2 的 showdmlstorageevent 命令相同,但fevent 信息格式有变化,系统中有 DML storage event 时不能对集群进行升级。
功能:
该命令用来显示当前集群有表的元数据和数据文件损坏信息;
示例:
$ gcadmin showdmlstorageevent
Event count:2
Event ID: 5
ObjectName: test.t1
TableID: 26
Fail Data Copy:
------------------------------------------------------
SegName: n2 NodeIP: 192.168.153.129 FAILURE
Event ID: 6
ObjectName: test.t2
TableID: 32
Fail Data Copy:
------------------------------------------------------
SegName: n2 NodeIP: 192.168.153.129 FAILURE
showcluster 命令
语法:
gcadmin showcluster [c | d | f]
参数说明:
c: 仅显示集群 coordinator 节点信息;
d: 仅显示集群 data 节点信息;
f: 按照 xml 格式显示集群节点信息。
功能:
显示集群节点信息,若不输入参数 c 或 d 则显示集群所有节点信息。
示例:
显示所有节点信息,示例如下:
$ gcadmin showcluster
CLUSTER STATE: ACTIVE
CLUSTER MODE: NORMAL
===============================================================
| GBASE COORDINATOR CLUSTER INFORMATION |
===============================================================
| NodeName | IpAddress |gcware |gcluster |DataState |
---------------------------------------------------------------
| coordinator1 | 192.168.153.129 | OPEN | OPEN | 0 |
---------------------------------------------------------------
===========================================================
| GBASE DATA CLUSTER INFORMATION |
===========================================================
|NodeName | IpAddress |gnode |syncserver |DataState |
-----------------------------------------------------------
| node1 | 192.168.153.126 | OPEN | OPEN | 0 |
-----------------------------------------------------------
| node2 | 192.168.153.129 | OPEN | OPEN | 0 |
-----------------------------------------------------------
| node3 | 192.168.153.125 | OPEN | OPEN | 0 |
-----------------------------------------------------------
showcluster 命令显示所有节点
仅显示 coordinator 节点信息,示例如下:
$ gcadmin showcluster c CLUSTER STATE: ACTIVE CLUSTER MODE: NORMAL =============================================================== | GBASE COORDINATOR CLUSTER INFORMATION | =============================================================== | NodeName | IpAddress |gcware |gcluster |DataState |
--------------------------------------------------------------- | coordinator1 | 192.168.153.129 | OPEN | OPEN | 0 | ---------------------------------------------------------------
showcluster 命令仅显示 coordinator 节点
仅显示 data 节点信息,示例如下:
$ gcadmin showcluster d
CLUSTER STATE: ACTIVE
CLUSTER MODE: NORMAL
===========================================================
| GBASE DATA CLUSTER INFORMATION |
===========================================================
|NodeName | IpAddress |gnode |syncserver |DataState |
-----------------------------------------------------------
| node1 | 192.168.153.126 | OPEN | OPEN | 0 |
-----------------------------------------------------------
| node2 | 192.168.153.129 | OPEN | OPEN | 0 |
-----------------------------------------------------------
| node3 | 192.168.153.125 | OPEN | OPEN | 0 |
showcluster 命令仅显示 data 节点
按照 xml 格式显示 data 节点信息,示例如下:
$ gcadmin showcluster d f
<?xml version='1.0' encoding="utf-8"?> <ClusterInfo> <ClusterState>ACTIVED</ClusterState> <ClusterMode>NORMAL</ClusterMode> <DataserverNodes> <DataServerNode> <NodeName>node1</NodeName> <IpAddress>192.168.153.126</IpAddress> <gnode>OPEN</gnode> <syncserver>OPEN</syncserver>
<DataState>0</DataState> </DataServerNode> <DataServerNode> <NodeName>node4</NodeName> <IpAddress>192.168.153.129</IpAddress> <gnode>OPEN</gnode> <syncserver>OPEN</syncserver> <DataState>0</DataState> </DataServerNode> <DataServerNode> <NodeName>node5</NodeName> <IpAddress>192.168.153.125</IpAddress> <gnode>OPEN</gnode> <syncserver>OPEN</syncserver> <DataState>0</DataState> </DataServerNode> </DataserverNodes> </ClusterInfo>
xml 格式显示 data 节点信息
集群中节点较多时,查询异常节点信息时可使用 grep 命令:
gcadmin showcluster | grep -iE "close|offline|unavailable|replace|1 ”
示例如下:
$ gcadmin showcluster | grep -iE "close|offline|unavailable|replace| 1"
| coordinator1 | 192.168.92.129 | OFFLINE | OPEN | 0 |
| coordinator2 | 192.168.92.130 | OPEN | CLOSE | 1 |
| node1 | 192.168.92.129 | OFFLINE | OPEN | 0 |
| node2 | 192.168.92.130 | OPEN | OPEN | 1 |
复制