GBase 8a通过load加载时，是由数据节点做最终的实质操作，如果出现错误数据，日志也是记录在数据节点。当节点数量很多时，不方便排查。通过gbase_loader_logs_collect参数，可以将错误数据自动收集到连接节点的gcluster大的log目录下。
目录导航
参数
gbase_loader_logs_collect
默认值
1
使用样例
默认打开的效果
[gbase@rh6-1 ~]$ gccli testdb
GBase client 8.6.2.43-R30.124361. Copyright (c) 2004-2020, GBase. All Rights Reserved.
gbase> set global gbase_loader_logs_collect=1;
Query OK, 0 rows affected (Elapsed: 00:00:00.02)
gbase> show variables like '%collect%';
+---------------------------+-------+
| Variable_name | Value |
+---------------------------+-------+
| gbase_loader_logs_collect | ON |
+---------------------------+-------+
1 row in set (Elapsed: 00:00:00.00)
gbase> load data infile 'sftp://gbase:gbase1234@10.0.2.201/home/gbase/1.txt' into table t1;
Query OK, 0 rows affected (Elapsed: 00:00:00.67)
Task 2686986 finished, Loaded 0 records, Skipped 11 records
gbase> ^CAborted
[gbase@rh6-1 ~]$ ll /opt/gcluster/log/gcluster/loader_logs/2686986/
total 12
-rw------- 1 gbase gbase 209 Dec 28 15:24 2686986_loader_result.log
-rw------- 1 gbase gbase 108 Dec 28 15:24 2686986_testdb_t1_n1_::ffff:10.0.2.202_20201228152453.err
-rw------- 1 gbase gbase 886 Dec 28 15:24 2686986_testdb_t1_n1_::ffff:10.0.2.202_20201228152453.trc
[gbase@rh6-1 ~]$
参数关掉后的效果
[gbase@rh6-1 ~]$ gccli testdb
GBase client 8.6.2.43-R30.124361. Copyright (c) 2004-2020, GBase. All Rights Reserved.
gbase> show variables like '%collect%';
+---------------------------+-------+
| Variable_name | Value |
+---------------------------+-------+
| gbase_loader_logs_collect | ON |
+---------------------------+-------+
1 row in set (Elapsed: 00:00:00.00)
gbase> set gbase_loader_logs_collect=0;
ERROR 1229 (HY000): Variable 'gbase_loader_logs_collect' is a GLOBAL variable and should be set with SET GLOBAL
gbase> set global gbase_loader_logs_collect=0;
Query OK, 0 rows affected (Elapsed: 00:00:00.01)
gbase>
gbase>
gbase>
gbase>
gbase> use testdb;
Query OK, 0 rows affected (Elapsed: 00:00:00.00)
gbase> desc t1;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
+-------+---------+------+-----+---------+-------+
1 row in set (Elapsed: 00:00:00.00)
gbase> load data infile 'sftp://gbase:gbase1234@10.0.2.201/home/gbase/1.txt' into table t1;
Query OK, 0 rows affected (Elapsed: 00:00:00.70)
Task 2686984 finished, Loaded 0 records, Skipped 11 records
gbase> ^CAborted
[gbase@rh6-1 ~]$ ll /opt/gnode/log/gbase/loader_logs/
total 8
-rw------- 1 gbase gbase 108 Dec 28 14:58 2686984_testdb_t1_n1_::ffff:10.0.2.201_20201228145807.err
-rw------- 1 gbase gbase 886 Dec 28 14:58 2686984_testdb_t1_n1_::ffff:10.0.2.201_20201228145807.trc
[gbase@rh6-1 ~]$ gncli