返回首页

gbase数据、南大通用产品文档：GBase8s

更新日期：2024年09月11日

ALTER USER 语句（UNIX™ 、LINUX™）
........................................... 177

2017-06-01 09:28:07.457
[EXECTR][INFO ][S:125][Q:96]:=================================================
=
=
2017-06-01 09:28:07.482 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.173,
SQL:SET SELF SCN = 23.
2017-06-01 09:28:07.482 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.174,
SQL:SET SELF SCN = 23.
2017-06-01 09:28:07.482 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.174,
SQL:SET SELF SCN = 23.
2017-06-01 09:28:07.483 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.175,
SQL:SET SELF SCN = 23.
2017-06-01 09:28:07.483 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.175,
SQL:SET SELF SCN = 23.
2017-06-01 09:28:07.483 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.173,
SQL:SET SELF SCN = 23.
2017-06-01 09:28:07.483 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.173,
SQL:flush commit `test`.`td_s_n1` scn_number 23.
2017-06-01 09:28:07.483 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.174,
SQL:flush commit `test`.`td_s_n2` scn_number 23.
2017-06-01 09:28:07.483 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.174,
SQL:flush commit `test`.`td_s_n1` scn_number 23.
2017-06-01 09:28:07.484 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.173,
SQL:flush commit `test`.`td_s_n3` scn_number 23.
2017-06-01 09:28:07.484 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.175,
SQL:flush commit `test`.`td_s_n3` scn_number 23.
2017-06-01 09:28:07.484 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.175,
SQL:flush commit `test`.`td_s_n2` scn_number 23.
2017-06-01 09:28:07.519 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.173,
SQL:select scn from information_schema.tables where table_schema = 'test' and
table_name = 'td_s_n1'.
2017-06-01 09:28:07.519 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.174,

GBase 8a MPP Cluster 产品手册
6 附录
文档版本953（2022-09-15）
南大通用数据技术股份有限公司
1617
SQL:select scn from information_schema.tables where table_schema = 'test' and
table_name = 'td_s_n1'.
2017-06-01 09:28:07.519 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.174,
SQL:select scn from information_schema.tables where table_schema = 'test' and
table_name = 'td_s_n2'.
2017-06-01 09:28:07.519 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.175,
SQL:select scn from information_schema.tables where table_schema = 'test' and
table_name = 'td_s_n2'.
2017-06-01 09:28:07.519 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.175,
SQL:select scn from information_schema.tables where table_schema = 'test' and
table_name = 'td_s_n3'.
2017-06-01 09:28:07.519 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.173,
SQL:select scn from information_schema.tables where table_schema = 'test' and
table_name = 'td_s_n3'.
2017-06-01 09:28:07.522 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.173,
SQL:set autocommit=1.
2017-06-01 09:28:07.523 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.174,
SQL:set autocommit=1.
2017-06-01 09:28:07.523 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.174,
SQL:set autocommit=1.
2017-06-01 09:28:07.523 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.175,
SQL:set autocommit=1.
2017-06-01 09:28:07.523 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.175,
SQL:set autocommit=1.
2017-06-01 09:28:07.523 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.173,
SQL:set autocommit=1.
2017-06-01 09:28:07.534 [COMMIT][INFO ][S:125][Q:96]:commit table(test.td_s)
success for scn:23.
2017-06-01 09:28:07.534 [INSERT][INFO ][S:125][Q:96]:Success to execute execStep.
2017-06-01 09:28:07.534 [EXECTR][INFO ][S:125][Q:96]:Finish all steps of plan
[0x7fff3d583520].
2017-06-01 09:28:07.534 [EXECTR][INFO ][S:125][Q:96]:Passed tasks to async API,
good luck!
2017-06-01 09:28:07.535 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.173,
SQL:DROP TABLE IF EXISTS `gctmpdb`._tmp_rht_2902894784_125_t2_1_1496210470_s_n1.
2017-06-01 09:28:07.536 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.174,
SQL:DROP TABLE IF EXISTS `gctmpdb`._tmp_rht_2902894784_125_t2_1_1496210470_s_n2.
2017-06-01 09:28:07.537 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.175,
SQL:DROP TABLE IF EXISTS `gctmpdb`._tmp_rht_2902894784_125_t2_1_1496210470_s_n3.
2017-06-01 09:28:07.542 [EXECTR][INFO ][S:125][Q:96]:
-----------------+----Node Performance----+---------------
+-Type-+-------Node------+-Port-+---Elapsed---+--Status--+
| T | 192.168.6.175 | 5050 | 0 s | Finish |
| T | 192.168.6.174 | 5050 | 0 s | Finish |
| T | 192.168.6.173 | 5050 | 0 s | Finish |
+------+-----------------+------+-------------+----------+
2017-06-01 09:28:07.543 [INSERT][INFO ][S:125][Q:96]:DML INSERT END
2017-06-01 09:28:07.544 [LOCK][INFO ][S:125][Q:96]:unlocked: test
2017-06-01 09:28:07.545 [LOCK][INFO ][S:125][Q:96]:unlocked: test.td_s
2017-06-01 09:28:07.546 [LOCK][INFO ][S:125][Q:96]:unlocked:
test.td_s.09B5BEEC-1EF7-4FA6-9850-C4217A781E0F
2017-06-01 09:28:07.546 [LOCK][INFO ][S:125][Q:96]:unlocked: test.td_s.rsync
2017-06-01 09:28:07.547 [LOCK][INFO ][S:125][Q:96]:unlocked:

GBase 8a MPP Cluster 产品手册
6 附录
文档版本953（2022-09-15）
南大通用数据技术股份有限公司
1618
test.td_s580D5F90-B287-4199-B057-E6FBD44B5BFA

操作场景
gcadmin 命令是管理员对安装GBase UP 集群后运行状态进行的检查。
前提条件
gcadmin 命令在管理员用户（即安装时指定的dbaUser）下进行操作。
操作步骤
步骤1
GBase UP 的主要软件模块都运行在gbase 用户下。
每个节点的/opt 下会创建gcluster 子目录,每个data 节点的/opt 下会创建gnode 子目
录，GBase UP 的数据库用户，默认为root, 密码为空。
安装成功后，通过gcadmin 查看集群状况,如下：
$ gcadmin
CLUSTER STATE: ACTIVED
CLUSTER MODE: NORMAL

+==========================================================+
| GBASE COORDINATOR CLUSTER INFORMATION |
+==========================================================+
| NodeName | IpAddress |gcware |gcluster |DataState |
+--------------+---------------+-------+---------+----------+
| coordinator1 | 192.168.30.11 | OPEN | OPEN | 0 |
+--------------+--------------+-------+---------+----------+
| coordinator2 | 192.168.30.12 | OPEN | OPEN | 0 |
+--------------+--------------+-------+---------+----------+
| coordinator3 | 192.168.30.13 | OPEN | OPEN | 0 |
+--------------+---------------+-------+---------+----------+

GBase UP 产品手册 3 软件安装

文档版本04（2021-04-21） 南大通用数据技术股份有限公司 84
+======================================================+
| GBASE DATA CLUSTER INFORMATION |
+======================================================+
|NodeName | IpAddress |gnode |syncserver |DataState |
+---------+--------------+------+-----------+----------+
| node1 | 192.168.30.11 | OPEN | OPEN | 0 |
+---------+--------------+------+-----------+----------+
| node2 | 192.168.30.12 | OPEN | OPEN | 0 |
+---------+--------------+------+-----------+----------+
| node3 | 192.168.30.13 | OPEN | OPEN | 0 |
+--------+------------+------+---------+---------+

操作结果
检查结果各节点状态“OPEN”,后续可正常使用GBase UP。
说明
更多gcadmin 子命令请参考管理员手册中gcadmin 命令说明。



GBase UP 产品手册 3 软件安装

文档版本04（2021-04-21） 南大通用数据技术股份有限公司 85