Z49NeQt2

1#=========================================
2# 2017-10-03
3# cl02:xxxx_sup_log-login_month_aggr
4#=========================================
52017-10-04 05:08:36.778 +0900: Embulk v0.7.10
62017-10-04 05:08:40.947 +0900 [INFO] (transaction): Loaded plugin embulk-input-mysql (0.6.1)
72017-10-04 05:08:41.012 +0900 [INFO] (transaction): Loaded plugin embulk-output-redshift (0.4.3)
82017-10-04 05:08:41.103 +0900 [INFO] (transaction): Fetch size is 10000. Using server-side prepared statement.
92017-10-04 05:08:41.681 +0900 [INFO] (transaction): Connecting to jdbc:postgresql://xxxx.yyyyy.zzzzzzz.redshift.amazonaws.com:5439/xxxx options {user=embulk_om_cl02, tcpKeepAlive=true, loginTimeout=300, socketTimeout=1800}
102017-10-04 05:08:41.751 +0900 [INFO] (transaction): SQL: SET search_path TO "xxxx_sup_log"
112017-10-04 05:08:41.756 +0900 [INFO] (transaction): > 0.00 seconds
122017-10-04 05:08:41.756 +0900 [INFO] (transaction): Using insert mode
132017-10-04 05:08:41.828 +0900 [INFO] (transaction): SQL: DROP TABLE IF EXISTS "login_month_329ab640_bl_tmp000"
142017-10-04 05:08:41.832 +0900 [INFO] (transaction): > 0.00 seconds
152017-10-04 05:08:42.082 +0900 [INFO] (transaction): SQL: CREATE TABLE IF NOT EXISTS "login_month_329ab640_bl_tmp000" ("target_date" INT8, "platform_type" INT8, "month_active_users" INT8)
162017-10-04 05:08:42.146 +0900 [INFO] (transaction): > 0.06 seconds
172017-10-04 05:08:42.347 +0900 [INFO] (transaction): {done:  0 / 1, running: 0}
182017-10-04 05:08:42.381 +0900 [INFO] (task-0000): Connecting to jdbc:postgresql://xxxx.yyyyy.zzzzzzz.redshift.amazonaws.com:5439/xxxx options {user=embulk_om_cl02, tcpKeepAlive=true, loginTimeout=300, socketTimeout=1800}
192017-10-04 05:08:42.702 +0900 [INFO] (task-0000): SQL: SET search_path TO "xxxx_sup_log"
202017-10-04 05:08:42.705 +0900 [INFO] (task-0000): > 0.00 seconds
212017-10-04 05:08:42.705 +0900 [INFO] (task-0000): Copy SQL: COPY "login_month_329ab640_bl_tmp000" ("target_date", "platform_type", "month_active_users") ? GZIP DELIMITER '\t' NULL '\\N' ESCAPE TRUNCATECOLUMNS ACCEPTINVCHARS STATUPDATE OFF COMPUPDATE OFF
222017-10-04 05:08:42.744 +0900 [INFO] (task-0000): Fetch size is 10000. Using server-side prepared statement.
232017-10-04 05:08:42.821 +0900 [INFO] (task-0000): SQL: SELECT * FROM `login_month_aggr` WHERE target_date >= UNIX_TIMESTAMP('2017-10-03 04:00:00') AND target_date <= UNIX_TIMESTAMP('2017-10-03 03:59:59' + interval 1 day)
242017-10-04 05:08:42.840 +0900 [INFO] (task-0000): > 0.01 seconds
252017-10-04 05:08:42.852 +0900 [INFO] (task-0000): Uploading file id embulk/OM/prd/xxxx_sup_log/login_month_aggr/dt=2017-10-03/cl02/xxxx_sup_log/2017-10-04_04:00:00/465f03e1-d606-4631-b3b3-ed2d721b04fa to S3 (20 bytes 0 rows)
262017-10-04 05:08:43.134 +0900 [INFO] (task-0000): SQL: SET search_path TO "xxxx_sup_log"
272017-10-04 05:08:43.137 +0900 [INFO] (task-0000): > 0.00 seconds
282017-10-04 05:08:43.137 +0900 [INFO] (task-0000): Running COPY from file embulk/OM/prd/xxxx_sup_log/login_month_aggr/dt=2017-10-03/cl02/xxxx_sup_log/2017-10-04_04:00:00/465f03e1-d606-4631-b3b3-ed2d721b04fa
292017-10-04 05:08:44.507 +0900 [INFO] (task-0000): Loaded file embulk/OM/prd/xxxx_sup_log/login_month_aggr/dt=2017-10-03/cl02/xxxx_sup_log/2017-10-04_04:00:00/465f03e1-d606-4631-b3b3-ed2d721b04fa (0.39 seconds for COPY)
302017-10-04 05:08:44.508 +0900 [INFO] (task-0000): Loaded 1 files.
312017-10-04 05:08:44.510 +0900 [INFO] (transaction): {done:  1 / 1, running: 0}
322017-10-04 05:08:44.511 +0900 [INFO] (transaction): Connecting to jdbc:postgresql://xxxx.yyyyy.zzzzzzz.redshift.amazonaws.com:5439/xxxx options {user=embulk_om_cl02, tcpKeepAlive=true, loginTimeout=300, socketTimeout=28800}
332017-10-04 05:08:44.516 +0900 [INFO] (transaction): SQL: SET search_path TO "xxxx_sup_log"
342017-10-04 05:08:44.518 +0900 [INFO] (transaction): > 0.00 seconds
352017-10-04 05:08:44.518 +0900 [INFO] (transaction): SQL: INSERT INTO "login_month_aggr" ("target_date", "platform_type", "month_active_users") SELECT "target_date", "platform_type", "month_active_users" FROM "login_month_329ab640_bl_tmp000"
362017-10-04 05:08:44.535 +0900 [INFO] (transaction): > 0.02 seconds
372017-10-04 05:08:44.659 +0900 [INFO] (transaction): Connecting to jdbc:postgresql://xxxx.yyyyy.zzzzzzz.redshift.amazonaws.com:5439/xxxx options {user=embulk_om_cl02, tcpKeepAlive=true, loginTimeout=300, socketTimeout=1800}
382017-10-04 05:08:44.664 +0900 [INFO] (transaction): SQL: SET search_path TO "xxxx_sup_log"
392017-10-04 05:08:44.666 +0900 [INFO] (transaction): > 0.00 seconds
402017-10-04 05:08:44.667 +0900 [INFO] (transaction): SQL: DROP TABLE IF EXISTS "login_month_329ab640_bl_tmp000"
412017-10-04 05:08:44.836 +0900 [INFO] (transaction): > 0.17 seconds
422017-10-04 05:08:44.840 +0900 [INFO] (main): Committed.
432017-10-04 05:08:44.840 +0900 [INFO] (main): Next config diff: {"in":{},"out":{}}
44Build step 'Console output (build log) parsing' changed build result to UNSTABLE
45Performing Post build task...