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