返回首页

gbase数据、南大通用产品文档：GBase8ashowdmlstorageevent 命令

更新日期：2024年09月11日

功能
该命令用来显示当前集群中表的分片完整恢复信息。
注意
若系统中有DML storage event 时不能升级。
语法
gcadmin showdmlstorageevent [table_ID segname nodeip] | ]
[f] [vc vc_name]
表4- 29 参数说明
参数名称
说明
table_ID
表的编号。可以通过系统表information_schema.tables 表查
询获取。
segname
表分片的名字（通过showdistribution 查看分片名），例如
建立一张表名为t 的分布表，在第一个节点上的表分片名称
就是n1，在第二个节点上的表分片名称就是n2，…，命名
以此类推。
nodeip
节点机器的IP。
max_fevent_num
gcadmin 工具根据用户设定的最大条数返回
dmlstorageevent log 信息，如果设定的最大条数大于已有
的信息总量，则返回全部信息，否则返回指定数量的信息。

GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953（2022-04-10）
南大通用数据技术股份有限公司
196
参数名称
说明
如不指定最大条数，则默认返回16 条，后续
dmlstorageevent log 将不显示。
f
按照xml 格式显示集群节点信息。
vc vcname
指定要查看dmlstorageevent 信息的虚拟集群名字。
示例
$ 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

2017-06-01 09:28:07.346 [EXECTR][INFO ][S:125][Q:96]:--#--Begin a async API
mode--#--
2017-06-01 09:28:07.346 [EXECTR][INFO ][S:125][Q:96]:A plan Begin ...
2017-06-01 09:28:07.346 [EXECTR][INFO ][S:125][Q:96]:Current plan [0x7fff3d583520]
has 0 scalar subquery.
2017-06-01 09:28:07.346 [EXECTR][INFO ][S:125][Q:96]:Current plan [0x7fff3d583520]
has 0 from subquery.
2017-06-01 09:28:07.347 [EXECTR][INFO ][S:125][Q:96]:Current plan [0x7fff3d583520]
has 0 union subquery.

GBase 8a MPP Cluster 产品手册
6 附录
文档版本953（2022-04-10）
南大通用数据技术股份有限公司
1619
2017-06-01 09:28:07.347 [EXEC_P][INFO ][S:125][Q:96]:Current plan [0x7fff3d583520]
has 3 steps.
2017-06-01 09:28:07.347 [EXEC_P][INFO ][S:125][Q:96]:## STEP: 0 ...
2017-06-01 09:28:07.347 [EXECTR][INFO ][S:125][Q:96]:Current plan [0x7fff3d583520]
has 0 uncorrelated subquery.
2017-06-01 09:28:07.347 [EXECTR][INFO ][S:125][Q:96]:Distribution Info,
/[8a:P1C1]
2017-06-01 09:28:07.347 [EXECTR][INFO ][S:125][Q:96]:---Step detail: hash
redistribute the table in gbase.
2017-06-01 09:28:07.349 [EXECTR][INFO ][S:125][Q:96]:Create table by 'create as
select' mode
2017-06-01 09:28:07.349 [EXECTR][INFO ][S:125][Q:96]:Create table by 'create as
select' mode
2017-06-01 09:28:07.350 [EXECTR][INFO ][S:125][Q:96]:Create table by 'create as
select' mode
2017-06-01 09:28:07.350 [EXECTR][INFO ][S:125][Q:96]:Passed tasks to async API,
good luck!
2017-06-01 09:28:07.351 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.173,
SQL:CREATE TABLE `gctmpdb`._tmp_rht_2902894784_125_t2_1_1496210470_s_n1 AS SELECT
/*192.168.6.173_125_10_2017-06-01_09:28:07*/ /*+ TID('5') */ `test.td_t`.`a` AS
`a`, `test.td_t`.`b` AS `b`, `test.td_t`.`c` AS `c` FROM `test`.`td_t_n1`
`test.td_t` LIMIT 0 ; commit.
2017-06-01 09:28:07.355 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.174,
SQL:CREATE TABLE `gctmpdb`._tmp_rht_2902894784_125_t2_1_1496210470_s_n2 AS SELECT
/*192.168.6.173_125_10_2017-06-01_09:28:07*/ /*+ TID('5') */ `test.td_t`.`a` AS
`a`, `test.td_t`.`b` AS `b`, `test.td_t`.`c` AS `c` FROM `test`.`td_t_n2`
`test.td_t` LIMIT 0 ; commit.
2017-06-01 09:28:07.356 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.175,
SQL:CREATE TABLE `gctmpdb`._tmp_rht_2902894784_125_t2_1_1496210470_s_n3 AS SELECT
/*192.168.6.173_125_10_2017-06-01_09:28:07*/ /*+ TID('5') */ `test.td_t`.`a` AS
`a`, `test.td_t`.`b` AS `b`, `test.td_t`.`c` AS `c` FROM `test`.`td_t_n3`
`test.td_t` LIMIT 0 ; commit.
2017-06-01 09:28:07.361 [EXECTR][INFO ][S:125][Q:96]:
-----------------+----Node Performance----+---------------
+-Type-+-------Node------+-Port-+---Elapsed---+--Status--+
| T | 192.168.6.175 | 5050 | 0 s | Finish |

GBase 8a MPP Cluster 产品手册
6 附录
文档版本953（2022-04-10）
南大通用数据技术股份有限公司
1620
| T | 192.168.6.174 | 5050 | 0 s | Finish |
| T | 192.168.6.173 | 5050 | 0 s | Finish |
+------+-----------------+------+-------------+----------+
2017-06-01 09:28:07.362 [EXECTR][INFO ][S:125][Q:96]:Passed tasks to async API,
good luck!
2017-06-01 09:28:07.365 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.173,
SQL:SELECT /*192.168.6.173_125_10_2017-06-01_09:28:07*/ /*+ TID('5') */
`test.td_t`.`a` AS `a`, `test.td_t`.`b` AS `b`, `test.td_t`.`c` AS `c` FROM
`test`.`td_t_n1` `test.td_t` target into server (HOST
'192.168.6.173,192.168.6.174,192.168.6.175', PORT 5050, USER 'root', PASSWORD '',
DATABASE 'gctmpdb', TABLE
'_tmp_rht_2902894784_125_t2_1_1496210470_s_n1,_tmp_rht_2902894784_125_t2_1_1496
210470_s_n2,_tmp_rht_2902894784_125_t2_1_1496210470_s_n3', COMMENT 'group 0,
distribution 1, hash_map 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0
1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2
0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1
2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0
1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2
0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1
2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2
2017-06-01 09:28:07.374 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.174,
SQL:SELECT /*192.168.6.173_125_10_2017-06-01_09:28:07*/ /*+ TID('5') */
`test.td_t`.`a` AS `a`, `test.td_t`.`b` AS `b`, `test.td_t`.`c` AS `c` FROM
`test`.`td_t_n2` `test.td_t` target into server (HOST
'192.168.6.173,192.168.6.174,192.168.6.175', PORT 5050, USER 'root', PASSWORD '',
DATABASE 'gctmpdb', TABLE
'_tmp_rht_2902894784_125_t2_1_1496210470_s_n1,_tmp_rht_2902894784_125_t2_1_1496
210470_s_n2,_tmp_rht_2902894784_125_t2_1_1496210470_s_n3', COMMENT 'group 0,
distribution 1, hash_map 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0
1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2
0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1
2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0
1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2
0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1
2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2
2017-06-01 09:28:07.379 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.175,
SQL:SELECT /*192.168.6.173_125_10_2017-06-01_09:28:07*/ /*+ TID('5') */
`test.td_t`.`a` AS `a`, `test.td_t`.`b` AS `b`, `test.td_t`.`c` AS `c` FROM
`test`.`td_t_n3` `test.td_t` target into server (HOST
'192.168.6.173,192.168.6.174,192.168.6.175', PORT 5050, USER 'root', PASSWORD '',
DATABASE 'gctmpdb', TABLE
'_tmp_rht_2902894784_125_t2_1_1496210470_s_n1,_tmp_rht_2902894784_125_t2_1_1496
210470_s_n2,_tmp_rht_2902894784_125_t2_1_1496210470_s_n3', COMMENT 'group 0,

GBase 8a MPP Cluster 产品手册
6 附录
文档版本953（2022-04-10）
南大通用数据技术股份有限公司
1621
distribution 1, hash_map 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0
1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2
0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1
2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0
1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2
0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1
2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2
2017-06-01 09:28:07.394 [EXECTR][INFO ][S:125][Q:96]:
-----------------+----Node Performance----+---------------
+-Type-+-------Node------+-Port-+---Elapsed---+--Status--+
| T | 192.168.6.173 | 5050 | 0 s | Finish |
| T | 192.168.6.175 | 5050 | 0 s | Finish |
| T | 192.168.6.174 | 5050 | 0 s | Finish |
+------+-----------------+------+-------------+----------+
2017-06-01 09:28:07.394 [EXECTR][INFO ][S:125][Q:96]:Passed tasks to async API,
good luck!
2017-06-01 09:28:07.395 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.173,
SQL:flush temporary commit
`gctmpdb`._tmp_rht_2902894784_125_t2_1_1496210470_s_n1.
2017-06-01 09:28:07.399 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.174,
SQL:flush temporary commit
`gctmpdb`._tmp_rht_2902894784_125_t2_1_1496210470_s_n2.
2017-06-01 09:28:07.401 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.175,
SQL:flush temporary commit
`gctmpdb`._tmp_rht_2902894784_125_t2_1_1496210470_s_n3.
2017-06-01 09:28:07.407 [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.407 [EXEC_P][INFO ][S:125][Q:96]:## STEP: 1 ...
2017-06-01 09:28:07.407 [EXECTR][INFO ][S:125][Q:96]:Current plan [0x7fff3d583520]
has 0 uncorrelated subquery.
2017-06-01 09:28:07.407 [EXECTR][INFO ][S:125][Q:96]:Distribution Info, /[8a:P1]
2017-06-01 09:28:07.407 [EXECTR][INFO ][S:125][Q:96]:---Step detail: 8a to client,
query to all gnode
2017-06-01 09:28:07.408 [EXECTR][INFO ][S:125][Q:96]:Result redirected to insert
table ......
2017-06-01 09:28:07.408 [EXECTR][INFO ][S:125][Q:96]:Distribution of insert table:
1
2017-06-01 09:28:07.409 [EXECTR][INFO ][S:125][Q:96]:Passed tasks to async API,
good luck!
2017-06-01 09:28:07.411 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.173,
SQL:SET SELF SCN = 23;.
2017-06-01 09:28:07.413 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.174,
SQL:SET SELF SCN = 23;
2017-06-01 09:28:07.414 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.175,
SQL:SET SELF SCN = 23;.
2017-06-01 09:28:07.415 [EXECTR][INFO ][S:125][Q:96]:
-----------------+----Node Performance----+---------------
+-Type-+-------Node------+-Port-+---Elapsed---+--Status--+

GBase 8a MPP Cluster 产品手册
6 附录
文档版本953（2022-04-10）
南大通用数据技术股份有限公司
1622
| 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.415 [LOCK][INFO ][S:125][Q:96]:unlocked: test.td_t
2017-06-01 09:28:07.417 [LOCK][INFO ][S:125][Q:96]:acquired WRITE lock:
test.td_s.09B5BEEC-1EF7-4FA6-9850-C4217A781E0F
2017-06-01 09:28:07.429 [EXECTR][INFO ][S:125][Q:96]:Passed tasks to async API,
good luck!
2017-06-01 09:28:07.433 [EXECTR][INFO ][S:125][Q:96]:Set failover!
2017-06-01 09:28:07.433 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.173,
SQL:SELECT /*192.168.6.173_125_10_2017-06-01_09:28:07*/ /*+ TID('5') */
`_tmp_rht_2902894784_125_t2_1_1496210470_s_n1`.`a` AS `a`,
`_tmp_rht_2902894784_125_t2_1_1496210470_s_n1`.`b` AS `b`,
`_tmp_rht_2902894784_125_t2_1_1496210470_s_n1`.`c` AS `c` FROM
`gctmpdb`._tmp_rht_2902894784_125_t2_1_1496210470_s_n1 INNER JOIN
`test`.`td_s_n1` `test.td_s` ON (`test.td_s`.`a` =
`_tmp_rht_2902894784_125_t2_1_1496210470_s_n1`.`a`) target into server (HOST
'192.168.6.173,192.168.6.174', PORT 5050, USER 'root', PASSWORD '', DATABASE 'test',
TABLE 'td_s_n1', COMMENT 'table_host 0 0 1, scn 23, distribution 1' ).
2017-06-01 09:28:07.434 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.174,
SQL:SELECT /*192.168.6.173_125_10_2017-06-01_09:28:07*/ /*+ TID('5') */
`_tmp_rht_2902894784_125_t2_1_1496210470_s_n2`.`a` AS `a`,
`_tmp_rht_2902894784_125_t2_1_1496210470_s_n2`.`b` AS `b`,
`_tmp_rht_2902894784_125_t2_1_1496210470_s_n2`.`c` AS `c` FROM
`gctmpdb`._tmp_rht_2902894784_125_t2_1_1496210470_s_n2 INNER JOIN
`test`.`td_s_n2` `test.td_s` ON (`test.td_s`.`a` =
`_tmp_rht_2902894784_125_t2_1_1496210470_s_n2`.`a`) target into server (HOST
'192.168.6.174,192.168.6.175', PORT 5050, USER 'root', PASSWORD '', DATABASE 'test',
TABLE 'td_s_n2', COMMENT 'table_host 0 0 1, scn 23, distribution 1' ).
2017-06-01 09:28:07.434 [SQLDISP][INFO ][S:125][Q:96]:Target:192.168.6.175,
SQL:SELECT /*192.168.6.173_125_10_2017-06-01_09:28:07*/ /*+ TID('5') */
`_tmp_rht_2902894784_125_t2_1_1496210470_s_n3`.`a` AS `a`,
`_tmp_rht_2902894784_125_t2_1_1496210470_s_n3`.`b` AS `b`,
`_tmp_rht_2902894784_125_t2_1_1496210470_s_n3`.`c` AS `c` FROM
`gctmpdb`._tmp_rht_2902894784_125_t2_1_1496210470_s_n3 INNER JOIN
`test`.`td_s_n3` `test.td_s` ON (`test.td_s`.`a` =
`_tmp_rht_2902894784_125_t2_1_1496210470_s_n3`.`a`) target into server (HOST
'192.168.6.175,192.168.6.173', PORT 5050, USER 'root', PASSWORD '', DATABASE 'test',
TABLE 'td_s_n3', COMMENT 'table_host 0 0 1, scn 23, distribution 1' ).
2017-06-01 09:28:07.456 [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 |

GBase 8a MPP Cluster 产品手册
6 附录
文档版本953（2022-04-10）
南大通用数据技术股份有限公司
1623
+------+-----------------+------+-------------+----------+
2017-06-01 09:28:07.457 [EXEC_P][INFO ][S:125][Q:96]:## STEP: 2 ...
2017-06-01 09:28:07.457 [EXECTR][INFO ][S:125][Q:96]:Current plan [0x7fff3d583520]
has 0 uncorrelated subquery.
2017-06-01 09:28:07.457 [EXECTR][INFO ][S:125][Q:96]:---Enter Insert step...
2017-06-01 09:28:07.457 [EXECTR][INFO ][S:125][Q:96]:===========DML valid nodes
from query===========
2017-06-01 09:28:07.457 [EXECTR][INFO ][S:125][Q:96]:|| n1 | 192.168.6.173,

可选 GROUP BY 和 HAVING 子句向 SELECT 语句添加功能。可以在基本 SELECT 语
句中包括一个或全部两个子句来增大处理聚集的能力。
GROUP BY 子句组合类似的行，
针对 Projection 子句中列出的每个列，
为具有相同值的每
组行生成单一结果行。
HAVING 子句在构成组之后对那些组设置条件。
可以不带 HAVING
子句使用 GROUP BY 子句或不带 GROUP BY 子句使用 HAVING 子句。