express 日志记录express 引擎内部执行过程中的一些重要信息,包括异常等,用
于查错。
日志文件存储路径
$GCLUSTER_BASE/log/gcluster/express.log
$GBASE_BASE/log/gbase/express.log
日志内容说明
express 详细日志内容,可以在gcluster 配置文件中设置gcluster_log_level
GBase 8a MPP Cluster 产品手册
6 附录
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
1617
=7,也可以通过set [global] gcluster_log_level=7 的方式设置,设置完成后完
整的执行计划可输出到express.log 文件中。设置配置文件后,需要重启集
群服务,使上述配置文件的设置生效;
缺省情况下只有执行过程中出现的警告和错误才会输出到express.log 文
件。
示例
集群层log_level 调高后的输出内容示例:
2017-06-01 09:28:07.290 [LOCK][INFO ][S:125][Q:96]:acquired READ lock: test
2017-06-01 09:28:07.291 [LOCK][INFO ][S:125][Q:96]:acquired WRITE lock:
test.td_s580D5F90-B287-4199-B057-E6FBD44B5BFA
2017-06-01 09:28:07.292 [LOCK][INFO ][S:125][Q:96]:acquired READ lock:
test.td_s.09B5BEEC-1EF7-4FA6-9850-C4217A781E0F
2017-06-01 09:28:07.293 [LOCK][INFO ][S:125][Q:96]:acquired READ lock: test.td_s
2017-06-01 09:28:07.294 [LOCK][INFO ][S:125][Q:96]:unlocked:
test.td_s.09B5BEEC-1EF7-4FA6-9850-C4217A781E0F
2017-06-01 09:28:07.295 [LOCK][INFO ][S:125][Q:96]:acquired READ lock:
test.td_t.09B5BEEC-1EF7-4FA6-9850-C4217A781E0F
2017-06-01 09:28:07.296 [LOCK][INFO ][S:125][Q:96]:acquired READ lock: test.td_t
2017-06-01 09:28:07.296 [LOCK][INFO ][S:125][Q:96]:unlocked:
test.td_t.09B5BEEC-1EF7-4FA6-9850-C4217A781E0F
2017-06-01 09:28:07.299 [LOCK][INFO ][S:125][Q:96]:acquired READ lock:
test.td_s.rsync
2017-06-01 09:28:07.300 [INSERT][INFO ][S:125][Q:96]:DML INSERT BEGIN
2017-06-01 09:28:07.300 [INSERT][INFO ][S:125][Q:96]:hash col[a], idx[0]
2017-06-01 09:28:07.332 [INSERT][INFO ][S:125][Q:96]:sorted nodes:
2017-06-01 09:28:07.332 [INSERT][INFO ][S:125][Q:96]:<0>:GID[7197862080], SgID[1],
NodeID[2902894784], Node[192.168.6.173]
2017-06-01 09:28:07.332 [INSERT][INFO ][S:125][Q:96]:<1>:GID[11509606592],
SgID[2], NodeID[2919672000], Node[192.168.6.174]
2017-06-01 09:28:07.332 [INSERT][INFO ][S:125][Q:96]:<2>:GID[15821351104],
SgID[3], NodeID[2936449216], Node[192.168.6.175]
2017-06-01 09:28:07.345 [EXEC_P][INFO ][S:125][Q:96]:Original SQL:
insert into td_s select td_t.a,td_t.b,td_t.c from td_t inner join td_s on td_s.a= td_t.a
2017-06-01 09:28:07.345
[EXEC_P][INFO ][S:125][Q:96]:##############################
2017-06-01 09:28:07.345 [EXEC_P][INFO ][S:125][Q:96]:#### Main Query Begin ####
2017-06-01 09:28:07.345
[EXEC_P][INFO ][S:125][Q:96]:##############################
2017-06-01 09:28:07.345 [EXEC_P][INFO ][S:125][Q:96]:---Top plan is
[0x7fff3d583520]---
2017-06-01 09:28:07.345 [EXECTR][INFO ][S:125][Q:96]:Involved in 1 distribuitons
2017-06-01 09:28:07.346 [EXECTR][INFO ][S:125][Q:96]:===========Datacopymap Of
GBase 8a MPP Cluster 产品手册
6 附录
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
1618
Distribution 1===========
2017-06-01 09:28:07.346 [EXECTR][INFO ][S:125][Q:96]:|| n1 | 192.168.6.173,