2022-06-20 11:15:14 INFO i.a.w.w.WorkerRun(call):49 - Executing worker wrapper. Airbyte version: 0.36.4-alpha 2022-06-20 11:15:14 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/853/0/logs.log 2022-06-20 11:15:14 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.36.4-alpha 2022-06-20 11:15:14 INFO i.a.w.DefaultReplicationWorker(run):104 - start sync worker. job id: 853 attempt id: 0 2022-06-20 11:15:14 INFO i.a.w.DefaultReplicationWorker(run):116 - configured sync modes: {null.ticket_metrics=full_refresh - overwrite} 2022-06-20 11:15:14 INFO i.a.w.p.a.DefaultAirbyteDestination(start):69 - Running destination... 2022-06-20 11:15:14 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/destination-redshift:0.3.37 exists... 2022-06-20 11:15:14 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/destination-redshift:0.3.37 was found locally. 2022-06-20 11:15:14 INFO i.a.w.p.DockerProcessFactory(create):106 - Creating docker job ID: 853 2022-06-20 11:15:14 INFO i.a.w.p.DockerProcessFactory(create):158 - Preparing command: docker run --rm --init -i -w /data/853/0 --log-driver none --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/destination-redshift:0.3.37 -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_VERSION=0.36.4-alpha -e WORKER_JOB_ID=853 airbyte/destination-redshift:0.3.37 write --config destination_config.json --catalog destination_catalog.json 2022-06-20 11:15:14 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/source-zendesk-support:0.2.10 exists... 2022-06-20 11:15:14 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/source-zendesk-support:0.2.10 was found locally. 2022-06-20 11:15:14 INFO i.a.w.p.DockerProcessFactory(create):106 - Creating docker job ID: 853 2022-06-20 11:15:14 INFO i.a.w.p.DockerProcessFactory(create):158 - Preparing command: docker run --rm --init -i -w /data/853/0 --log-driver none --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e WORKER_JOB_ATTEMPT=0 -e WORKER_CONNECTOR_IMAGE=airbyte/source-zendesk-support:0.2.10 -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_VERSION=0.36.4-alpha -e WORKER_JOB_ID=853 airbyte/source-zendesk-support:0.2.10 read --config source_config.json --catalog source_catalog.json --state input_state.json 2022-06-20 11:15:14 INFO i.a.w.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$6):339 - Destination output thread started. 2022-06-20 11:15:14 INFO i.a.w.DefaultReplicationWorker(run):158 - Waiting for source and destination threads to complete. 2022-06-20 11:15:14 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):279 - Replication thread started. 2022-06-20 11:15:15 destination > SLF4J: Class path contains multiple SLF4J bindings. 2022-06-20 11:15:15 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-06-20 11:15:15 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-06-20 11:15:15 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-06-20 11:15:15 destination > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2022-06-20 11:15:16 destination > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] 2022-06-20 11:15:16 source > Starting syncing SourceZendeskSupport 2022-06-20 11:15:16 source > Syncing stream: ticket_metrics 2022-06-20 11:15:17 destination > 2022-06-20 11:15:17 INFO i.a.i.d.r.RedshiftDestination(main):69 - starting destination: class io.airbyte.integrations.destination.redshift.RedshiftDestination 2022-06-20 11:15:17 destination > 2022-06-20 11:15:17 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {catalog=destination_catalog.json, write=null, config=destination_config.json} 2022-06-20 11:15:17 destination > 2022-06-20 11:15:17 INFO i.a.i.b.IntegrationRunner(runInternal):123 - Running integration: io.airbyte.integrations.destination.redshift.RedshiftDestination 2022-06-20 11:15:17 destination > 2022-06-20 11:15:17 INFO i.a.i.b.IntegrationRunner(runInternal):124 - Command: WRITE 2022-06-20 11:15:17 destination > 2022-06-20 11:15:17 INFO i.a.i.b.IntegrationRunner(runInternal):125 - Integration config: IntegrationConfig{command=WRITE, configPath='destination_config.json', catalogPath='destination_catalog.json', statePath='null'} 2022-06-20 11:15:17 destination > 2022-06-20 11:15:17 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword examples - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-06-20 11:15:17 destination > 2022-06-20 11:15:17 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword airbyte_secret - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-06-20 11:15:17 destination > 2022-06-20 11:15:17 WARN i.a.i.d.r.RedshiftDestination(determineUploadMode):55 - The "standard" upload mode is not performant, and is not recommended for production. Please use the Amazon S3 upload mode if you are syncing a large amount of data. 2022-06-20 11:15:17 destination > 2022-06-20 11:15:17 INFO i.a.i.d.j.c.SwitchingDestination(getConsumer):65 - Using destination type: STANDARD 2022-06-20 11:15:17 destination > 2022-06-20 11:15:17 INFO c.z.h.HikariDataSource():80 - HikariPool-1 - Starting... 2022-06-20 11:15:17 destination > 2022-06-20 11:15:17 INFO c.z.h.HikariDataSource():82 - HikariPool-1 - Start completed. 2022-06-20 11:15:17 destination > 2022-06-20 11:15:17 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):98 - Write config: WriteConfig{streamName=imported_v6_ticket_metrics, namespace=null, outputSchemaName=cc, tmpTableName=_airbyte_tmp_mtc_imported_v6_ticket_metrics, outputTableName=_airbyte_raw_imported_v6_ticket_metrics, syncMode=overwrite} 2022-06-20 11:15:17 destination > 2022-06-20 11:15:17 INFO i.a.i.d.b.BufferedStreamConsumer(startTracked):116 - class io.airbyte.integrations.destination.buffered_stream_consumer.BufferedStreamConsumer started. 2022-06-20 11:15:17 destination > 2022-06-20 11:15:17 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):123 - Preparing tmp tables in destination started for 1 streams 2022-06-20 11:15:17 destination > 2022-06-20 11:15:17 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):127 - Preparing tmp table in destination started for stream imported_v6_ticket_metrics. schema: cc, tmp table name: _airbyte_tmp_mtc_imported_v6_ticket_metrics 2022-06-20 11:15:18 destination > 2022-06-20 11:15:18 INFO c.z.h.p.PoolBase(getAndSetNetworkTimeout):536 - HikariPool-1 - Driver does not support get/set network timeout for connections. ([Amazon][JDBC](10220) Driver does not support this optional feature.) 2022-06-20 11:15:19 destination > 2022-06-20 11:15:19 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):133 - Preparing tables in destination completed. 2022-06-20 11:15:20 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 1000 (878 KB) 2022-06-20 11:15:23 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 2000 (1 MB) 2022-06-20 11:15:27 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 3000 (2 MB) 2022-06-20 11:15:29 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 4000 (3 MB) 2022-06-20 11:15:33 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 5000 (4 MB) 2022-06-20 11:15:35 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 6000 (5 MB) 2022-06-20 11:15:38 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 7000 (6 MB) 2022-06-20 11:15:39 destination > 2022-06-20 11:15:39 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):84 - Flushing imported_v6_ticket_metrics: 7193 records (24 MB) 2022-06-20 11:15:39 destination > 2022-06-20 11:15:39 INFO i.a.i.d.r.o.RedshiftSqlOperations(insertRecordsInternal):83 - actual size of batch: 7193 2022-06-20 11:15:44 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 8000 (6 MB) 2022-06-20 11:15:45 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 9000 (7 MB) 2022-06-20 11:15:48 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 10000 (8 MB) 2022-06-20 11:15:51 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 11000 (9 MB) 2022-06-20 11:15:54 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 12000 (10 MB) 2022-06-20 11:15:57 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 13000 (11 MB) 2022-06-20 11:15:59 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 14000 (12 MB) 2022-06-20 11:16:00 destination > 2022-06-20 11:16:00 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):84 - Flushing imported_v6_ticket_metrics: 7162 records (24 MB) 2022-06-20 11:16:00 destination > 2022-06-20 11:16:00 INFO i.a.i.d.r.o.RedshiftSqlOperations(insertRecordsInternal):83 - actual size of batch: 7162 2022-06-20 11:16:04 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 15000 (13 MB) 2022-06-20 11:16:05 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 16000 (13 MB) 2022-06-20 11:16:08 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 17000 (14 MB) 2022-06-20 11:16:11 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 18000 (15 MB) 2022-06-20 11:16:14 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 19000 (16 MB) 2022-06-20 11:16:17 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 20000 (17 MB) 2022-06-20 11:16:20 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 21000 (18 MB) 2022-06-20 11:16:22 destination > 2022-06-20 11:16:22 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):84 - Flushing imported_v6_ticket_metrics: 7169 records (24 MB) 2022-06-20 11:16:22 destination > 2022-06-20 11:16:22 INFO i.a.i.d.r.o.RedshiftSqlOperations(insertRecordsInternal):83 - actual size of batch: 7169 2022-06-20 11:16:26 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 22000 (19 MB) 2022-06-20 11:16:26 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 23000 (20 MB) 2022-06-20 11:16:29 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 24000 (20 MB) 2022-06-20 11:16:32 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 25000 (21 MB) 2022-06-20 11:16:35 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 26000 (22 MB) 2022-06-20 11:16:38 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 27000 (23 MB) 2022-06-20 11:16:41 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 28000 (24 MB) 2022-06-20 11:16:43 destination > 2022-06-20 11:16:43 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):84 - Flushing imported_v6_ticket_metrics: 7162 records (24 MB) 2022-06-20 11:16:43 destination > 2022-06-20 11:16:43 INFO i.a.i.d.r.o.RedshiftSqlOperations(insertRecordsInternal):83 - actual size of batch: 7162 2022-06-20 11:16:44 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 29000 (25 MB) 2022-06-20 11:16:47 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 30000 (26 MB) 2022-06-20 11:16:49 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 31000 (27 MB) 2022-06-20 11:16:52 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 32000 (27 MB) 2022-06-20 11:16:55 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 33000 (28 MB) 2022-06-20 11:16:58 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 34000 (29 MB) 2022-06-20 11:17:01 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 35000 (30 MB) 2022-06-20 11:17:04 destination > 2022-06-20 11:17:04 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):84 - Flushing imported_v6_ticket_metrics: 7157 records (24 MB) 2022-06-20 11:17:04 destination > 2022-06-20 11:17:04 INFO i.a.i.d.r.o.RedshiftSqlOperations(insertRecordsInternal):83 - actual size of batch: 7157 2022-06-20 11:17:04 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 36000 (31 MB) 2022-06-20 11:17:08 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 37000 (32 MB) 2022-06-20 11:17:10 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 38000 (33 MB) 2022-06-20 11:17:13 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 39000 (34 MB) 2022-06-20 11:17:16 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 40000 (34 MB) 2022-06-20 11:17:19 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 41000 (35 MB) 2022-06-20 11:17:22 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 42000 (36 MB) 2022-06-20 11:17:25 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 43000 (37 MB) 2022-06-20 11:17:25 destination > 2022-06-20 11:17:25 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):84 - Flushing imported_v6_ticket_metrics: 7164 records (24 MB) 2022-06-20 11:17:25 destination > 2022-06-20 11:17:25 INFO i.a.i.d.r.o.RedshiftSqlOperations(insertRecordsInternal):83 - actual size of batch: 7164 2022-06-20 11:17:30 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 44000 (38 MB) 2022-06-20 11:17:31 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 45000 (39 MB) 2022-06-20 11:17:34 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 46000 (40 MB) 2022-06-20 11:17:37 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 47000 (41 MB) 2022-06-20 11:17:40 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 48000 (41 MB) 2022-06-20 11:17:43 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 49000 (42 MB) 2022-06-20 11:17:45 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 50000 (43 MB) 2022-06-20 11:17:46 destination > 2022-06-20 11:17:46 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):84 - Flushing imported_v6_ticket_metrics: 7162 records (24 MB) 2022-06-20 11:17:46 destination > 2022-06-20 11:17:46 INFO i.a.i.d.r.o.RedshiftSqlOperations(insertRecordsInternal):83 - actual size of batch: 7162 2022-06-20 11:17:50 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 51000 (44 MB) 2022-06-20 11:17:52 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 52000 (45 MB) 2022-06-20 11:17:55 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 53000 (46 MB) 2022-06-20 11:17:57 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 54000 (47 MB) 2022-06-20 11:18:00 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 55000 (47 MB) 2022-06-20 11:18:03 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 56000 (48 MB) 2022-06-20 11:18:06 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 57000 (49 MB) 2022-06-20 11:18:07 destination > 2022-06-20 11:18:07 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):84 - Flushing imported_v6_ticket_metrics: 7159 records (24 MB) 2022-06-20 11:18:07 destination > 2022-06-20 11:18:07 INFO i.a.i.d.r.o.RedshiftSqlOperations(insertRecordsInternal):83 - actual size of batch: 7159 2022-06-20 11:18:11 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 58000 (50 MB) 2022-06-20 11:18:12 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 59000 (51 MB) 2022-06-20 11:18:15 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 60000 (52 MB) 2022-06-20 11:18:18 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 61000 (53 MB) 2022-06-20 11:18:21 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 62000 (54 MB) 2022-06-20 11:18:24 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 63000 (54 MB) 2022-06-20 11:18:27 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 64000 (55 MB) 2022-06-20 11:18:28 destination > 2022-06-20 11:18:28 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):84 - Flushing imported_v6_ticket_metrics: 7168 records (24 MB) 2022-06-20 11:18:28 destination > 2022-06-20 11:18:28 INFO i.a.i.d.r.o.RedshiftSqlOperations(insertRecordsInternal):83 - actual size of batch: 7168 2022-06-20 11:18:32 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 65000 (56 MB) 2022-06-20 11:18:33 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 66000 (57 MB) 2022-06-20 11:18:36 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 67000 (58 MB) 2022-06-20 11:18:39 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 68000 (59 MB) 2022-06-20 11:18:41 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 69000 (60 MB) 2022-06-20 11:18:44 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 70000 (61 MB) 2022-06-20 11:18:48 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 71000 (61 MB) 2022-06-20 11:18:49 destination > 2022-06-20 11:18:49 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):84 - Flushing imported_v6_ticket_metrics: 7168 records (24 MB) 2022-06-20 11:18:49 destination > 2022-06-20 11:18:49 INFO i.a.i.d.r.o.RedshiftSqlOperations(insertRecordsInternal):83 - actual size of batch: 7168 2022-06-20 11:18:51 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 72000 (62 MB) 2022-06-20 11:18:54 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 73000 (63 MB) 2022-06-20 11:18:57 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 74000 (64 MB) 2022-06-20 11:19:00 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 75000 (65 MB) 2022-06-20 11:19:03 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 76000 (66 MB) 2022-06-20 11:19:06 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 77000 (67 MB) 2022-06-20 11:19:09 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 78000 (68 MB) 2022-06-20 11:19:12 destination > 2022-06-20 11:19:12 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):84 - Flushing imported_v6_ticket_metrics: 7146 records (24 MB) 2022-06-20 11:19:12 destination > 2022-06-20 11:19:12 INFO i.a.i.d.r.o.RedshiftSqlOperations(insertRecordsInternal):83 - actual size of batch: 7146 2022-06-20 11:19:12 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 79000 (68 MB) 2022-06-20 11:19:20 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 80000 (69 MB) 2022-06-20 11:19:21 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 81000 (70 MB) 2022-06-20 11:19:24 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 82000 (71 MB) 2022-06-20 11:19:26 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 83000 (72 MB) 2022-06-20 11:19:30 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 84000 (73 MB) 2022-06-20 11:19:32 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 85000 (74 MB) 2022-06-20 11:19:35 destination > 2022-06-20 11:19:35 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):84 - Flushing imported_v6_ticket_metrics: 7156 records (24 MB) 2022-06-20 11:19:35 destination > 2022-06-20 11:19:35 INFO i.a.i.d.r.o.RedshiftSqlOperations(insertRecordsInternal):83 - actual size of batch: 7156 2022-06-20 11:19:35 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 86000 (75 MB) 2022-06-20 11:19:41 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 87000 (75 MB) 2022-06-20 11:19:42 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 88000 (76 MB) 2022-06-20 11:19:45 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 89000 (77 MB) 2022-06-20 11:19:48 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 90000 (78 MB) 2022-06-20 11:19:51 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 91000 (79 MB) 2022-06-20 11:19:54 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 92000 (80 MB) 2022-06-20 11:19:57 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 93000 (81 MB) 2022-06-20 11:19:58 destination > 2022-06-20 11:19:58 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):84 - Flushing imported_v6_ticket_metrics: 7144 records (24 MB) 2022-06-20 11:19:58 destination > 2022-06-20 11:19:58 INFO i.a.i.d.r.o.RedshiftSqlOperations(insertRecordsInternal):83 - actual size of batch: 7144 2022-06-20 11:20:03 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 94000 (82 MB) 2022-06-20 11:20:04 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 95000 (82 MB) 2022-06-20 11:20:05 source > Read 95317 records from ticket_metrics stream 2022-06-20 11:20:05 source > Finished syncing ticket_metrics 2022-06-20 11:20:05 source > SourceZendeskSupport runtimes: Syncing stream ticket_metrics 0:04:48.238379 2022-06-20 11:20:05 source > Finished syncing SourceZendeskSupport 2022-06-20 11:20:05 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):305 - Total records read: 95317 (83 MB) 2022-06-20 11:20:05 INFO i.a.w.DefaultReplicationWorker(run):163 - One of source or destination thread complete. Waiting on the other. 2022-06-20 11:20:05 destination > 2022-06-20 11:20:05 INFO i.a.i.b.FailureTrackingAirbyteMessageConsumer(close):65 - Airbyte message consumer: succeeded. 2022-06-20 11:20:05 destination > 2022-06-20 11:20:05 INFO i.a.i.d.b.BufferedStreamConsumer(close):170 - executing on success close procedure. 2022-06-20 11:20:05 destination > 2022-06-20 11:20:05 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):84 - Flushing imported_v6_ticket_metrics: 2207 records (7 MB) 2022-06-20 11:20:05 destination > 2022-06-20 11:20:05 INFO i.a.i.d.r.o.RedshiftSqlOperations(insertRecordsInternal):83 - actual size of batch: 2207 2022-06-20 11:20:11 destination > 2022-06-20 11:20:11 INFO i.a.i.d.r.o.RedshiftSqlOperations(onDestinationCloseOperations):133 - Executing operations for Redshift Destination DB engine... 2022-06-20 11:20:11 destination > 2022-06-20 11:20:11 INFO i.a.i.d.r.o.RedshiftSqlOperations(discoverNotSuperTables):152 - Discovering NOT SUPER table types... 2022-06-20 11:20:11 destination > 2022-06-20 11:20:11 INFO i.a.i.d.r.o.RedshiftSqlOperations(onDestinationCloseOperations):141 - Executing operations for Redshift Destination DB engine completed. 2022-06-20 11:20:11 destination > 2022-06-20 11:20:11 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):163 - Finalizing tables in destination started for 1 streams 2022-06-20 11:20:11 destination > 2022-06-20 11:20:11 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):168 - Finalizing stream imported_v6_ticket_metrics. schema cc, tmp table _airbyte_tmp_mtc_imported_v6_ticket_metrics, final table _airbyte_raw_imported_v6_ticket_metrics 2022-06-20 11:20:11 destination > 2022-06-20 11:20:11 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):181 - Executing finalization of tables. 2022-06-20 11:20:12 destination > 2022-06-20 11:20:12 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):183 - Finalizing tables in destination completed. 2022-06-20 11:20:12 destination > 2022-06-20 11:20:12 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):186 - Cleaning tmp tables in destination started for 1 streams 2022-06-20 11:20:12 destination > 2022-06-20 11:20:12 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):190 - Cleaning tmp table in destination started for stream imported_v6_ticket_metrics. schema cc, tmp table name: _airbyte_tmp_mtc_imported_v6_ticket_metrics 2022-06-20 11:20:14 destination > 2022-06-20 11:20:14 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):195 - Cleaning tmp tables in destination completed. 2022-06-20 11:20:14 destination > 2022-06-20 11:20:14 INFO i.a.i.b.IntegrationRunner(runInternal):171 - Completed integration: io.airbyte.integrations.destination.redshift.RedshiftDestination 2022-06-20 11:20:14 destination > 2022-06-20 11:20:14 INFO i.a.i.d.r.RedshiftDestination(main):71 - completed destination: class io.airbyte.integrations.destination.redshift.RedshiftDestination 2022-06-20 11:20:14 INFO i.a.w.DefaultReplicationWorker(run):165 - Source and destination threads complete. 2022-06-20 11:20:14 INFO i.a.w.DefaultReplicationWorker(run):228 - sync summary: io.airbyte.config.ReplicationAttemptSummary@2ea323a5[status=completed,recordsSynced=95317,bytesSynced=87272164,startTime=1655723714765,endTime=1655724014789,totalStats=io.airbyte.config.SyncStats@290b04b4[recordsEmitted=95317,bytesEmitted=87272164,stateMessagesEmitted=0,recordsCommitted=95317],streamStats=[io.airbyte.config.StreamSyncStats@4605dbf1[streamName=imported_v6_ticket_metrics,stats=io.airbyte.config.SyncStats@5baef118[recordsEmitted=95317,bytesEmitted=87272164,stateMessagesEmitted=,recordsCommitted=95317]]]] 2022-06-20 11:20:14 INFO i.a.w.DefaultReplicationWorker(run):250 - Source did not output any state messages 2022-06-20 11:20:14 WARN i.a.w.DefaultReplicationWorker(run):258 - State capture: No new state, falling back on input state: io.airbyte.config.State@6ca75fc3[state={}] 2022-06-20 11:20:14 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-06-20 11:20:14 INFO i.a.w.t.s.ReplicationActivityImpl(lambda$replicate$3):155 - sync summary: io.airbyte.config.StandardSyncOutput@916440b[standardSyncSummary=io.airbyte.config.StandardSyncSummary@4c14db4d[status=completed,recordsSynced=95317,bytesSynced=87272164,startTime=1655723714765,endTime=1655724014789,totalStats=io.airbyte.config.SyncStats@290b04b4[recordsEmitted=95317,bytesEmitted=87272164,stateMessagesEmitted=0,recordsCommitted=95317],streamStats=[io.airbyte.config.StreamSyncStats@4605dbf1[streamName=imported_v6_ticket_metrics,stats=io.airbyte.config.SyncStats@5baef118[recordsEmitted=95317,bytesEmitted=87272164,stateMessagesEmitted=,recordsCommitted=95317]]]],normalizationSummary=,state=io.airbyte.config.State@6ca75fc3[state={}],outputCatalog=io.airbyte.protocol.models.ConfiguredAirbyteCatalog@3ef3a043[streams=[io.airbyte.protocol.models.ConfiguredAirbyteStream@7d92748a[stream=io.airbyte.protocol.models.AirbyteStream@469f512f[name=imported_v6_ticket_metrics,jsonSchema={"type":["null","object"],"properties":{"id":{"type":["null","integer"]},"url":{"type":["null","string"]},"time":{"type":["null","string"]},"type":{"type":["null","string"]},"metric":{"type":["null","string"]},"status":{"type":["null","object"],"properties":{"business":{"type":["null","integer"]},"calendar":{"type":["null","integer"]}}},"reopens":{"type":["null","integer"]},"replies":{"type":["null","integer"]},"solved_at":{"type":["null","string"],"format":"date-time"},"ticket_id":{"type":["null","integer"]},"created_at":{"type":["null","string"],"format":"date-time"},"updated_at":{"type":["null","string"],"format":"date-time"},"assigned_at":{"type":["null","string"],"format":"date-time"},"instance_id":{"type":["null","integer"]},"group_stations":{"type":["null","integer"]},"assignee_stations":{"type":["null","integer"]},"status_updated_at":{"type":["null","string"],"format":"date-time"},"assignee_updated_at":{"type":["null","string"],"format":"date-time"},"requester_updated_at":{"type":["null","string"],"format":"date-time"},"initially_assigned_at":{"type":["null","string"],"format":"date-time"},"reply_time_in_minutes":{"type":["null","object"],"properties":{"business":{"type":["null","integer"]},"calendar":{"type":["null","integer"]}}},"latest_comment_added_at":{"type":["null","string"],"format":"date-time"},"on_hold_time_in_minutes":{"type":["null","object"],"properties":{"business":{"type":["null","integer"]},"calendar":{"type":["null","integer"]}}},"agent_wait_time_in_minutes":{"type":["null","object"],"properties":{"business":{"type":["null","integer"]},"calendar":{"type":["null","integer"]}}},"requester_wait_time_in_minutes":{"type":["null","object"],"properties":{"business":{"type":["null","integer"]},"calendar":{"type":["null","integer"]}}},"full_resolution_time_in_minutes":{"type":["null","object"],"properties":{"business":{"type":["null","integer"]},"calendar":{"type":["null","integer"]}}},"first_resolution_time_in_minutes":{"type":["null","object"],"properties":{"business":{"type":["null","integer"]},"calendar":{"type":["null","integer"]}}}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=true,defaultCursorField=[updated_at],sourceDefinedPrimaryKey=[[id]],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[updated_at],destinationSyncMode=overwrite,primaryKey=[[id]],additionalProperties={}]],additionalProperties={}],failures=[]] 2022-06-20 11:20:14 INFO i.a.w.t.TemporalUtils(withBackgroundHeartbeat):236 - Stopping temporal heartbeating... 2022-06-20 11:20:14 INFO i.a.c.p.ConfigRepository(updateConnectionState):774 - Updating connection 456ff07c-59ea-4170-80a9-8c319274d870 state: io.airbyte.config.State@61317b2d[state={}] 2022-06-20 11:20:14 INFO i.a.n.SlackNotificationClient(notify):131 - Successful notification (200): ok 2022-06-20 11:20:15 INFO i.a.v.j.JsonSchemaValidator(test):56 - JSON schema validation failed. errors: $.access_token: is missing but it is required, $.credentials: must be a constant value oauth2.0