You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
286 lines
20 KiB
286 lines
20 KiB
nohup: ignoring input
|
|
Adding table: t_base_class
|
|
target schema is public
|
|
mysql_dbname is dsideal_db
|
|
[binlog_loader_main] load_batch 100 row load_batch_gap 10 second
|
|
[binlog_loader_main] begin binlog load from 0
|
|
[binlog_loader_main] applyid binlog from 0
|
|
NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'key' as the Greenplum Database data distribution key for this table.
|
|
HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
|
|
[loader] table t_base_class index column class_id
|
|
[loader] not have new task, last task id 0, wait for a while
|
|
[master] task 1 has been created, 1 rows from 0 to 1 ready to be load
|
|
[washer] task 1 is ready to be wash from 0 to 1
|
|
[washer] task 1 wash binlog complete from 0 to 1, update row 1, cost 129.691 ms
|
|
[loader] task 1 step 1 table public.t_base_class load t_base_class_old_key to remote 1 row complete, cost 21.980 ms
|
|
[loader] task 1 step 2 table delete public.t_base_class 0 row use oldkey complete, cost 97.388 ms
|
|
[loader] task 1 step 3 load new data to table public.t_base_class 1 row complete, cost 16.362 ms
|
|
[loader] task 1 table public.t_base_class merge and load data to remote from 0 to 1 complete, cost 227.227 ms
|
|
[loader] not have new task, last task id 1, wait for a while
|
|
[loader] not have new task, last task id 1, wait for a while
|
|
[loader] not have new task, last task id 1, wait for a while
|
|
[loader] not have new task, last task id 1, wait for a while
|
|
[master] task 2 has been created, 1 rows from 1 to 2 ready to be load
|
|
[washer] task 2 is ready to be wash from 1 to 2
|
|
[washer] task 2 wash binlog complete from 1 to 2, update row 1, cost 67.249 ms
|
|
[loader] task 2 step 1 table public.t_base_class load t_base_class_old_key to remote 1 row complete, cost 29.566 ms
|
|
[loader] task 2 step 2 table delete public.t_base_class 0 row use oldkey complete, cost 83.815 ms
|
|
[loader] task 2 step 3 load new data to table public.t_base_class 1 row complete, cost 16.326 ms
|
|
[loader] task 2 table public.t_base_class merge and load data to remote from 1 to 2 complete, cost 215.418 ms
|
|
[loader] not have new task, last task id 2, wait for a while
|
|
[loader] not have new task, last task id 2, wait for a while
|
|
[loader] not have new task, last task id 2, wait for a while
|
|
[loader] not have new task, last task id 2, wait for a while
|
|
[master] task 3 has been created, 1 rows from 2 to 3 ready to be load
|
|
[washer] task 3 is ready to be wash from 2 to 3
|
|
[washer] task 3 wash binlog complete from 2 to 3, update row 1, cost 71.489 ms
|
|
[loader] task 3 step 1 table public.t_base_class load t_base_class_old_key to remote 1 row complete, cost 20.626 ms
|
|
[loader] task 3 step 2 table delete public.t_base_class 0 row use oldkey complete, cost 88.180 ms
|
|
[loader] task 3 step 3 load new data to table public.t_base_class 1 row complete, cost 16.821 ms
|
|
[loader] task 3 table public.t_base_class merge and load data to remote from 2 to 3 complete, cost 211.362 ms
|
|
[loader] not have new task, last task id 3, wait for a while
|
|
[master] task 4 has been created, 1 rows from 3 to 4 ready to be load
|
|
[washer] task 4 is ready to be wash from 3 to 4
|
|
[washer] task 4 wash binlog complete from 3 to 4, update row 1, cost 67.200 ms
|
|
[loader] task 4 step 1 table public.t_base_class load t_base_class_old_key to remote 1 row complete, cost 17.284 ms
|
|
[loader] task 4 step 2 table delete public.t_base_class 0 row use oldkey complete, cost 66.220 ms
|
|
[loader] task 4 step 3 load new data to table public.t_base_class 1 row complete, cost 15.676 ms
|
|
[loader] task 4 table public.t_base_class merge and load data to remote from 3 to 4 complete, cost 162.536 ms
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[loader] not have new task, last task id 4, wait for a while
|
|
[master] task 5 has been created, 1 rows from 4 to 5 ready to be load
|
|
[washer] task 5 is ready to be wash from 4 to 5
|
|
[washer] task 5 wash binlog complete from 4 to 5, update row 1, cost 78.284 ms
|
|
[loader] task 5 step 1 table public.t_base_class load t_base_class_old_key to remote 1 row complete, cost 22.072 ms
|
|
[loader] task 5 step 2 table delete public.t_base_class 0 row use oldkey complete, cost 95.921 ms
|
|
[loader] task 5 step 3 load new data to table public.t_base_class 1 row complete, cost 16.729 ms
|
|
[loader] task 5 table public.t_base_class merge and load data to remote from 4 to 5 complete, cost 236.480 ms
|
|
[loader] not have new task, last task id 5, wait for a while
|
|
[loader] not have new task, last task id 5, wait for a while
|
|
[loader] not have new task, last task id 5, wait for a while
|
|
[loader] not have new task, last task id 5, wait for a while
|
|
[loader] not have new task, last task id 5, wait for a while
|
|
[master] task 6 has been created, 1 rows from 5 to 6 ready to be load
|
|
[washer] task 6 is ready to be wash from 5 to 6
|
|
[washer] task 6 wash binlog complete from 5 to 6, update row 1, cost 68.331 ms
|
|
[loader] task 6 step 1 table public.t_base_class load t_base_class_old_key to remote 1 row complete, cost 19.883 ms
|
|
[loader] task 6 step 2 table delete public.t_base_class 1 row use oldkey complete, cost 80.951 ms
|
|
[loader] task 6 step 3 load new data to table public.t_base_class 1 row complete, cost 16.315 ms
|
|
[loader] task 6 table public.t_base_class merge and load data to remote from 5 to 6 complete, cost 208.512 ms
|
|
[loader] not have new task, last task id 6, wait for a while
|
|
[loader] not have new task, last task id 6, wait for a while
|
|
[master] task 7 has been created, 1 rows from 6 to 7 ready to be load
|
|
[washer] task 7 is ready to be wash from 6 to 7
|
|
[washer] task 7 wash binlog complete from 6 to 7, update row 1, cost 67.841 ms
|
|
[loader] task 7 step 1 table public.t_base_class load t_base_class_old_key to remote 1 row complete, cost 22.531 ms
|
|
[loader] task 7 step 2 table delete public.t_base_class 1 row use oldkey complete, cost 105.772 ms
|
|
[loader] task 7 step 3 load new data to table public.t_base_class 1 row complete, cost 16.116 ms
|
|
[loader] task 7 table public.t_base_class merge and load data to remote from 6 to 7 complete, cost 230.531 ms
|
|
[loader] not have new task, last task id 7, wait for a while
|
|
[loader] not have new task, last task id 7, wait for a while
|
|
[master] task 8 has been created, 1 rows from 7 to 8 ready to be load
|
|
[washer] task 8 is ready to be wash from 7 to 8
|
|
[washer] task 8 wash binlog complete from 7 to 8, update row 1, cost 67.945 ms
|
|
[loader] task 8 step 1 table public.t_base_class load t_base_class_old_key to remote 1 row complete, cost 21.678 ms
|
|
[loader] task 8 step 2 table delete public.t_base_class 1 row use oldkey complete, cost 82.321 ms
|
|
[loader] task 8 step 3 load new data to table public.t_base_class 1 row complete, cost 16.987 ms
|
|
[loader] task 8 table public.t_base_class merge and load data to remote from 7 to 8 complete, cost 209.388 ms
|
|
[loader] not have new task, last task id 8, wait for a while
|
|
[loader] not have new task, last task id 8, wait for a while
|
|
[loader] not have new task, last task id 8, wait for a while
|
|
[loader] not have new task, last task id 8, wait for a while
|
|
[loader] not have new task, last task id 8, wait for a while
|
|
[loader] not have new task, last task id 8, wait for a while
|
|
[master] task 9 has been created, 1 rows from 8 to 9 ready to be load
|
|
[washer] task 9 is ready to be wash from 8 to 9
|
|
[washer] task 9 wash binlog complete from 8 to 9, update row 1, cost 69.066 ms
|
|
[loader] task 9 step 1 table public.t_base_class load t_base_class_old_key to remote 1 row complete, cost 21.787 ms
|
|
[loader] task 9 step 2 table delete public.t_base_class 0 row use oldkey complete, cost 87.434 ms
|
|
[loader] task 9 step 3 load new data to table public.t_base_class 1 row complete, cost 18.649 ms
|
|
[loader] task 9 table public.t_base_class merge and load data to remote from 8 to 9 complete, cost 227.634 ms
|
|
[loader] not have new task, last task id 9, wait for a while
|
|
[loader] not have new task, last task id 9, wait for a while
|
|
[loader] not have new task, last task id 9, wait for a while
|
|
[loader] not have new task, last task id 9, wait for a while
|
|
[loader] not have new task, last task id 9, wait for a while
|
|
[master] task 10 has been created, 1 rows from 9 to 10 ready to be load
|
|
[washer] task 10 is ready to be wash from 9 to 10
|
|
[washer] task 10 wash binlog complete from 9 to 10, update row 1, cost 65.214 ms
|
|
[loader] task 10 step 1 table public.t_base_class load t_base_class_old_key to remote 1 row complete, cost 20.612 ms
|
|
[loader] task 10 step 2 table delete public.t_base_class 1 row use oldkey complete, cost 81.348 ms
|
|
[loader] task 10 step 3 load new data to table public.t_base_class 1 row complete, cost 16.137 ms
|
|
[loader] task 10 table public.t_base_class merge and load data to remote from 9 to 10 complete, cost 201.446 ms
|
|
[loader] not have new task, last task id 10, wait for a while
|
|
[loader] not have new task, last task id 10, wait for a while
|
|
[master] task 11 has been created, 1 rows from 10 to 11 ready to be load
|
|
[washer] task 11 is ready to be wash from 10 to 11
|
|
[washer] task 11 wash binlog complete from 10 to 11, update row 1, cost 68.077 ms
|
|
[loader] task 11 step 1 table public.t_base_class load t_base_class_old_key to remote 1 row complete, cost 18.605 ms
|
|
[loader] task 11 step 2 table delete public.t_base_class 1 row use oldkey complete, cost 83.011 ms
|
|
[loader] task 11 step 3 load new data to table public.t_base_class 1 row complete, cost 15.669 ms
|
|
[loader] task 11 table public.t_base_class merge and load data to remote from 10 to 11 complete, cost 198.606 ms
|
|
[master] task 12 has been created, 1 rows from 11 to 12 ready to be load
|
|
[loader] not have new task, last task id 11, wait for a while
|
|
[washer] task 12 is ready to be wash from 11 to 12
|
|
[washer] task 12 wash binlog complete from 11 to 12, update row 1, cost 66.502 ms
|
|
[loader] task 12 step 1 table public.t_base_class load t_base_class_old_key to remote 1 row complete, cost 18.450 ms
|
|
[loader] task 12 step 2 table delete public.t_base_class 1 row use oldkey complete, cost 63.113 ms
|
|
[loader] task 12 step 3 load new data to table public.t_base_class 1 row complete, cost 15.942 ms
|
|
[loader] task 12 table public.t_base_class merge and load data to remote from 11 to 12 complete, cost 160.162 ms
|
|
[loader] not have new task, last task id 12, wait for a while
|
|
[loader] not have new task, last task id 12, wait for a while
|
|
[master] task 13 has been created, 1 rows from 12 to 13 ready to be load
|
|
[washer] task 13 is ready to be wash from 12 to 13
|
|
[washer] task 13 wash binlog complete from 12 to 13, update row 1, cost 64.632 ms
|
|
[loader] task 13 step 1 table public.t_base_class load t_base_class_old_key to remote 1 row complete, cost 21.123 ms
|
|
[loader] task 13 step 2 table delete public.t_base_class 0 row use oldkey complete, cost 85.227 ms
|
|
[loader] task 13 step 3 load new data to table public.t_base_class 1 row complete, cost 16.048 ms
|
|
[loader] task 13 table public.t_base_class merge and load data to remote from 12 to 13 complete, cost 206.395 ms
|
|
[loader] not have new task, last task id 13, wait for a while
|
|
[loader] not have new task, last task id 13, wait for a while
|
|
[loader] not have new task, last task id 13, wait for a while
|
|
[loader] not have new task, last task id 13, wait for a while
|
|
[loader] not have new task, last task id 13, wait for a while
|
|
[loader] not have new task, last task id 13, wait for a while
|
|
[loader] not have new task, last task id 13, wait for a while
|
|
[loader] not have new task, last task id 13, wait for a while
|
|
[master] task 14 has been created, 1 rows from 13 to 14 ready to be load
|
|
[washer] task 14 is ready to be wash from 13 to 14
|
|
[washer] task 14 wash binlog complete from 13 to 14, update row 1, cost 65.465 ms
|
|
[loader] task 14 step 1 table public.t_base_class load t_base_class_old_key to remote 1 row complete, cost 28.329 ms
|
|
[loader] task 14 step 2 table delete public.t_base_class 0 row use oldkey complete, cost 81.046 ms
|
|
[loader] task 14 step 3 load new data to table public.t_base_class 1 row complete, cost 16.308 ms
|
|
[loader] task 14 table public.t_base_class merge and load data to remote from 13 to 14 complete, cost 212.225 ms
|
|
[loader] not have new task, last task id 14, wait for a while
|
|
[master] task 15 has been created, 1 rows from 14 to 15 ready to be load
|
|
[washer] task 15 is ready to be wash from 14 to 15
|
|
[washer] task 15 wash binlog complete from 14 to 15, update row 1, cost 137.815 ms
|
|
[loader] task 15 step 1 table public.t_base_class load t_base_class_old_key to remote 1 row complete, cost 21.122 ms
|
|
[loader] task 15 step 2 table delete public.t_base_class 1 row use oldkey complete, cost 80.033 ms
|
|
[loader] task 15 step 3 load new data to table public.t_base_class 1 row complete, cost 17.903 ms
|
|
[loader] task 15 table public.t_base_class merge and load data to remote from 14 to 15 complete, cost 206.807 ms
|
|
[loader] not have new task, last task id 15, wait for a while
|
|
[loader] not have new task, last task id 15, wait for a while
|
|
[loader] not have new task, last task id 15, wait for a while
|
|
[loader] not have new task, last task id 15, wait for a while
|
|
[loader] not have new task, last task id 15, wait for a while
|
|
[loader] not have new task, last task id 15, wait for a while
|
|
[loader] not have new task, last task id 15, wait for a while
|
|
[loader] not have new task, last task id 15, wait for a while
|
|
[loader] not have new task, last task id 15, wait for a while
|
|
[loader] not have new task, last task id 15, wait for a while
|
|
[loader] not have new task, last task id 15, wait for a while
|
|
[loader] not have new task, last task id 15, wait for a while
|
|
[loader] not have new task, last task id 15, wait for a while
|
|
[loader] not have new task, last task id 15, wait for a while
|
|
[loader] not have new task, last task id 15, wait for a while
|
|
[loader] not have new task, last task id 15, wait for a while
|
|
[loader] not have new task, last task id 15, wait for a while
|
|
[loader] not have new task, last task id 15, wait for a while
|
|
[loader] not have new task, last task id 15, wait for a while
|