2022-10-11 10:44:19 INFO i.a.a.LoggingTrackingClient(track):43 - track. version: null, userId: null, action: Connector Jobs, metadata: {job_type=sync, namespace_definition=destination, config.source.auth_type=oauth2.0, config.source.aws_access_key._secret=set, config.destination.tunnel_method.tunnel_method=NO_TUNNEL, config.source.replication_start_date=set, config.source.period_in_days=set, frequency=manual, connector_source_definition_id=e55879a8-0ef8-4557-abcf-ab34c53ec460, config.destination.port=set, workspace_id=75163712-cfa4-4f06-88be-82fab7cb88db, config.destination.database=set, attempt_stage=STARTED, config.destination.password._secret=set, attempt_id=1, connector_destination=MySQL, connector_destination_docker_repository=airbyte/destination-mysql, config.source.lwa_client_secret._secret=set, table_prefix=false, workspace_name=75163712-cfa4-4f06-88be-82fab7cb88db, config.source.region=DE, config.source.lwa_app_id=set, number_of_streams=1, connector_source=Amazon Seller Partner, config.source.app_id._secret=set, config.destination.host=set, connector_source_docker_repository=airbyte/source-amazon-seller-partner, config.source.max_wait_seconds=set, config.destination.username=set, catalog.sync_mode.full_refresh=set, connection_id=b2a5833d-a68e-4dca-9297-f8983fa0dc97, job_id=167, connector_source_version=0.2.27, catalog.destination_sync_mode.append=set, connector_destination_version=0.1.20, config.source.aws_environment=PRODUCTION, operation.normalization=1, config.destination.ssl=false, operation_count=1, config.source.refresh_token._secret=set, connector_destination_definition_id=ca81ee7c-3163-4246-af40-094cc31e5e42, config.source.aws_secret_key._secret=set, config.source.role_arn._secret=set} 2022-10-11 10:44:19 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/167/0/logs.log 2022-10-11 10:44:19 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.40.12 2022-10-11 10:44:19 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:44:19 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START CHECK ----- 2022-10-11 10:44:19 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:44:19 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/source-amazon-seller-partner:0.2.27 exists... 2022-10-11 10:44:19 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/source-amazon-seller-partner:0.2.27 was found locally. 2022-10-11 10:44:19 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = source-amazon-seller-partner-check-167-0-dxrpr with resources io.airbyte.config.ResourceRequirements@72a15bff[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-10-11 10:44:19 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/167/0 --log-driver none --name source-amazon-seller-partner-check-167-0-dxrpr --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e WORKER_CONNECTOR_IMAGE=airbyte/source-amazon-seller-partner:0.2.27 -e WORKER_JOB_ATTEMPT=0 -e AIRBYTE_VERSION=0.40.12 -e WORKER_JOB_ID=167 airbyte/source-amazon-seller-partner:0.2.27 check --config source_config.json 2022-10-11 10:44:22 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):109 - Check succeeded 2022-10-11 10:44:22 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-10-11 10:44:22 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:44:22 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END CHECK ----- 2022-10-11 10:44:22 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:44:22 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/167/0/logs.log 2022-10-11 10:44:22 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.40.12 2022-10-11 10:44:22 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:44:22 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START CHECK ----- 2022-10-11 10:44:22 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:44:22 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/destination-mysql:0.1.20 exists... 2022-10-11 10:44:22 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/destination-mysql:0.1.20 was found locally. 2022-10-11 10:44:22 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = destination-mysql-check-167-0-rvxos with resources io.airbyte.config.ResourceRequirements@72a15bff[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-10-11 10:44:22 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/167/0 --log-driver none --name destination-mysql-check-167-0-rvxos --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e WORKER_CONNECTOR_IMAGE=airbyte/destination-mysql:0.1.20 -e WORKER_JOB_ATTEMPT=0 -e AIRBYTE_VERSION=0.40.12 -e WORKER_JOB_ID=167 airbyte/destination-mysql:0.1.20 check --config source_config.json 2022-10-11 10:44:22 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Class path contains multiple SLF4J bindings. 2022-10-11 10:44:22 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-10-11 10:44:22 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-10-11 10:44:22 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Found binding in [jar:file:/airbyte/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-10-11 10:44:22 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2022-10-11 10:44:23 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] 2022-10-11 10:44:23 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:44:23 INFO i.a.i.d.m.MySQLDestination(main):136 - starting destination: class io.airbyte.integrations.destination.mysql.MySQLDestination 2022-10-11 10:44:23 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:44:23 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {check=null, config=source_config.json} 2022-10-11 10:44:23 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:44:23 INFO i.a.i.b.IntegrationRunner(runInternal):123 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-10-11 10:44:23 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:44:23 INFO i.a.i.b.IntegrationRunner(runInternal):124 - Command: CHECK 2022-10-11 10:44:23 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:44:23 INFO i.a.i.b.IntegrationRunner(runInternal):125 - Integration config: IntegrationConfig{command=CHECK, configPath='source_config.json', catalogPath='null', statePath='null'} 2022-10-11 10:44:23 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:44:23 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-10-11 10:44:23 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:44:23 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-10-11 10:44:23 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:44:23 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-10-11 10:44:23 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:44:23 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword multiline - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-10-11 10:44:23 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:44:23 INFO i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL 2022-10-11 10:44:23 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:44:23 INFO c.z.h.HikariDataSource():80 - HikariPool-1 - Starting... 2022-10-11 10:44:23 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:44:23 INFO c.z.h.HikariDataSource():82 - HikariPool-1 - Start completed. 2022-10-11 10:44:24 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:44:24 INFO c.z.h.HikariDataSource(close):350 - HikariPool-1 - Shutdown initiated... 2022-10-11 10:44:24 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:44:24 INFO c.z.h.HikariDataSource(close):352 - HikariPool-1 - Shutdown completed. 2022-10-11 10:44:24 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:44:24 INFO i.a.i.b.IntegrationRunner(runInternal):171 - Completed integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-10-11 10:44:24 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:44:24 INFO i.a.i.d.m.MySQLDestination(main):138 - completed destination: class io.airbyte.integrations.destination.mysql.MySQLDestination 2022-10-11 10:44:24 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-10-11 10:44:24 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:44:24 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END CHECK ----- 2022-10-11 10:44:24 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:44:24 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/167/0/logs.log 2022-10-11 10:44:24 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.40.12 2022-10-11 10:44:24 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):50 - Using default value for environment variable LOG_CONNECTOR_MESSAGES: 'false' 2022-10-11 10:44:24 INFO i.a.c.EnvConfigs(getEnvOrDefault):1091 - Using default value for environment variable METRIC_CLIENT: '' 2022-10-11 10:44:24 WARN i.a.m.l.MetricClientFactory(initialize):60 - Metric client is already initialized to 2022-10-11 10:44:24 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):50 - Using default value for environment variable LOG_CONNECTOR_MESSAGES: 'false' 2022-10-11 10:44:24 INFO i.a.w.g.DefaultReplicationWorker(run):122 - start sync worker. job id: 167 attempt id: 0 2022-10-11 10:44:24 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:44:24 INFO i.a.w.g.DefaultReplicationWorker(run):135 - configured sync modes: {null.GET_MERCHANT_LISTINGS_ALL_DATA=full_refresh - append} 2022-10-11 10:44:24 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START REPLICATION ----- 2022-10-11 10:44:24 INFO i.a.w.i.DefaultAirbyteDestination(start):65 - Running destination... 2022-10-11 10:44:24 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:44:24 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/destination-mysql:0.1.20 exists... 2022-10-11 10:44:24 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/destination-mysql:0.1.20 was found locally. 2022-10-11 10:44:24 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = destination-mysql-write-167-0-vpnjs with resources io.airbyte.config.ResourceRequirements@21408f8[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-10-11 10:44:24 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/167/0 --log-driver none --name destination-mysql-write-167-0-vpnjs --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e WORKER_CONNECTOR_IMAGE=airbyte/destination-mysql:0.1.20 -e WORKER_JOB_ATTEMPT=0 -e AIRBYTE_VERSION=0.40.12 -e WORKER_JOB_ID=167 airbyte/destination-mysql:0.1.20 write --config destination_config.json --catalog destination_catalog.json 2022-10-11 10:44:24 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/source-amazon-seller-partner:0.2.27 exists... 2022-10-11 10:44:24 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/source-amazon-seller-partner:0.2.27 was found locally. 2022-10-11 10:44:24 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = source-amazon-seller-partner-read-167-0-mgqum with resources io.airbyte.config.ResourceRequirements@a9d2151[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-10-11 10:44:24 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/167/0 --log-driver none --name source-amazon-seller-partner-read-167-0-mgqum --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e WORKER_CONNECTOR_IMAGE=airbyte/source-amazon-seller-partner:0.2.27 -e WORKER_JOB_ATTEMPT=0 -e AIRBYTE_VERSION=0.40.12 -e WORKER_JOB_ID=167 airbyte/source-amazon-seller-partner:0.2.27 read --config source_config.json --catalog source_catalog.json --state input_state.json 2022-10-11 10:44:24 INFO i.a.w.g.DefaultReplicationWorker(run):177 - Waiting for source and destination threads to complete. 2022-10-11 10:44:24 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):435 - Destination output thread started. 2022-10-11 10:44:24 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):322 - Replication thread started. 2022-10-11 10:44:24 destination > SLF4J: Class path contains multiple SLF4J bindings. 2022-10-11 10:44:24 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-10-11 10:44:24 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-10-11 10:44:24 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-10-11 10:44:24 destination > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2022-10-11 10:44:24 destination > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] 2022-10-11 10:44:24 source > Starting syncing SourceAmazonSellerPartner 2022-10-11 10:44:25 destination > 2022-10-11 10:44:25 INFO i.a.i.d.m.MySQLDestination(main):136 - starting destination: class io.airbyte.integrations.destination.mysql.MySQLDestination 2022-10-11 10:44:25 destination > 2022-10-11 10:44:25 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {catalog=destination_catalog.json, write=null, config=destination_config.json} 2022-10-11 10:44:25 destination > 2022-10-11 10:44:25 INFO i.a.i.b.IntegrationRunner(runInternal):123 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-10-11 10:44:25 destination > 2022-10-11 10:44:25 INFO i.a.i.b.IntegrationRunner(runInternal):124 - Command: WRITE 2022-10-11 10:44:25 destination > 2022-10-11 10:44:25 INFO i.a.i.b.IntegrationRunner(runInternal):125 - Integration config: IntegrationConfig{command=WRITE, configPath='destination_config.json', catalogPath='destination_catalog.json', statePath='null'} 2022-10-11 10:44:25 destination > 2022-10-11 10:44:25 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-10-11 10:44:25 destination > 2022-10-11 10:44:25 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-10-11 10:44:25 destination > 2022-10-11 10:44:25 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-10-11 10:44:25 destination > 2022-10-11 10:44:25 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword multiline - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-10-11 10:44:25 source > Syncing stream: GET_MERCHANT_LISTINGS_ALL_DATA 2022-10-11 10:44:25 destination > 2022-10-11 10:44:25 INFO i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL 2022-10-11 10:44:25 destination > 2022-10-11 10:44:25 INFO c.z.h.HikariDataSource():80 - HikariPool-1 - Starting... 2022-10-11 10:44:25 destination > 2022-10-11 10:44:25 INFO c.z.h.HikariDataSource():82 - HikariPool-1 - Start completed. 2022-10-11 10:44:25 destination > 2022-10-11 10:44:25 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):98 - Write config: WriteConfig{streamName=GET_MERCHANT_LISTINGS_ALL_DATA, namespace=null, outputSchemaName=mszweirad, tmpTableName=_airbyte_tmp_ebq_get___ant_listings_all_data, outputTableName=_airbyte_raw_get_merchant_listings_all_data, syncMode=append} 2022-10-11 10:44:25 destination > 2022-10-11 10:44:25 INFO i.a.i.d.b.BufferedStreamConsumer(startTracked):116 - class io.airbyte.integrations.destination.buffered_stream_consumer.BufferedStreamConsumer started. 2022-10-11 10:44:25 destination > 2022-10-11 10:44:25 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):123 - Preparing tmp tables in destination started for 1 streams 2022-10-11 10:44:25 destination > 2022-10-11 10:44:25 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):127 - Preparing tmp table in destination started for stream GET_MERCHANT_LISTINGS_ALL_DATA. schema: mszweirad, tmp table name: _airbyte_tmp_ebq_get___ant_listings_all_data 2022-10-11 10:44:25 destination > 2022-10-11 10:44:25 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):133 - Preparing tables in destination completed. 2022-10-11 10:45:27 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):352 - Records read: 1000 (807 KB) 2022-10-11 10:45:27 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):352 - Records read: 2000 (1 MB) 2022-10-11 10:45:27 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):352 - Records read: 3000 (2 MB) 2022-10-11 10:45:27 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):352 - Records read: 4000 (3 MB) 2022-10-11 10:45:27 source > Read 4730 records from GET_MERCHANT_LISTINGS_ALL_DATA stream 2022-10-11 10:45:27 source > Finished syncing GET_MERCHANT_LISTINGS_ALL_DATA 2022-10-11 10:45:27 source > SourceAmazonSellerPartner runtimes: Syncing stream GET_MERCHANT_LISTINGS_ALL_DATA 0:01:02.439487 2022-10-11 10:45:27 source > Finished syncing SourceAmazonSellerPartner 2022-10-11 10:45:28 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):355 - Source has no more messages, closing connection. 2022-10-11 10:45:28 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):363 - Total records read: 4730 (3 MB) 2022-10-11 10:45:28 WARN i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$5):366 - Schema validation errors found for stream GET_MERCHANT_LISTINGS_ALL_DATA. Error messages: [$.quantity is of an incorrect type. Expected it to be [null, number], $.pending-quantity is of an incorrect type. Expected it to be [null, number], $.price is of an incorrect type. Expected it to be [null, number]] 2022-10-11 10:45:28 INFO i.a.w.g.DefaultReplicationWorker(run):182 - One of source or destination thread complete. Waiting on the other. 2022-10-11 10:45:28 destination > 2022-10-11 10:45:28 INFO i.a.i.b.FailureTrackingAirbyteMessageConsumer(close):65 - Airbyte message consumer: succeeded. 2022-10-11 10:45:28 destination > 2022-10-11 10:45:28 INFO i.a.i.d.b.BufferedStreamConsumer(close):171 - executing on success close procedure. 2022-10-11 10:45:28 destination > 2022-10-11 10:45:28 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing GET_MERCHANT_LISTINGS_ALL_DATA: 4730 records (14 MB) 2022-10-11 10:45:28 destination > 2022-10-11 10:45:28 INFO i.a.i.d.j.SqlOperations(onDestinationCloseOperations):138 - No onDestinationCloseOperations required for this destination. 2022-10-11 10:45:28 destination > 2022-10-11 10:45:28 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):163 - Finalizing tables in destination started for 1 streams 2022-10-11 10:45:28 destination > 2022-10-11 10:45:28 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):168 - Finalizing stream GET_MERCHANT_LISTINGS_ALL_DATA. schema mszweirad, tmp table _airbyte_tmp_ebq_get___ant_listings_all_data, final table _airbyte_raw_get_merchant_listings_all_data 2022-10-11 10:45:28 destination > 2022-10-11 10:45:28 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):181 - Executing finalization of tables. 2022-10-11 10:45:29 destination > 2022-10-11 10:45:29 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):183 - Finalizing tables in destination completed. 2022-10-11 10:45:29 destination > 2022-10-11 10:45:29 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):186 - Cleaning tmp tables in destination started for 1 streams 2022-10-11 10:45:29 destination > 2022-10-11 10:45:29 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):190 - Cleaning tmp table in destination started for stream GET_MERCHANT_LISTINGS_ALL_DATA. schema mszweirad, tmp table name: _airbyte_tmp_ebq_get___ant_listings_all_data 2022-10-11 10:45:29 destination > 2022-10-11 10:45:29 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):195 - Cleaning tmp tables in destination completed. 2022-10-11 10:45:29 destination > 2022-10-11 10:45:29 INFO i.a.i.b.IntegrationRunner(runInternal):171 - Completed integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-10-11 10:45:29 destination > 2022-10-11 10:45:29 INFO i.a.i.d.m.MySQLDestination(main):138 - completed destination: class io.airbyte.integrations.destination.mysql.MySQLDestination 2022-10-11 10:45:29 INFO i.a.w.g.DefaultReplicationWorker(run):184 - Source and destination threads complete. 2022-10-11 10:45:29 INFO i.a.w.g.DefaultReplicationWorker(run):281 - Source did not output any state messages 2022-10-11 10:45:29 WARN i.a.w.g.DefaultReplicationWorker(run):289 - State capture: No new state, falling back on input state: io.airbyte.config.State@4f5648dd[state={}] 2022-10-11 10:45:29 INFO i.a.w.g.DefaultReplicationWorker(run):300 - sync summary: { "status" : "completed", "recordsSynced" : 4730, "bytesSynced" : 3861687, "startTime" : 1665485064292, "endTime" : 1665485129208, "totalStats" : { "recordsEmitted" : 4730, "bytesEmitted" : 3861687, "sourceStateMessagesEmitted" : 0, "destinationStateMessagesEmitted" : 0, "recordsCommitted" : 4730, "meanSecondsBeforeSourceStateMessageEmitted" : 0, "maxSecondsBeforeSourceStateMessageEmitted" : 0, "maxSecondsBetweenStateMessageEmittedandCommitted" : 0, "meanSecondsBetweenStateMessageEmittedandCommitted" : 0 }, "streamStats" : [ { "streamName" : "GET_MERCHANT_LISTINGS_ALL_DATA", "stats" : { "recordsEmitted" : 4730, "bytesEmitted" : 3861687, "recordsCommitted" : 4730 } } ] } 2022-10-11 10:45:29 INFO i.a.w.g.DefaultReplicationWorker(run):301 - failures: [ ] 2022-10-11 10:45:29 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-10-11 10:45:29 INFO i.a.w.t.s.ReplicationActivityImpl(lambda$replicate$3):157 - sync summary: io.airbyte.config.StandardSyncOutput@6cda1522[standardSyncSummary=io.airbyte.config.StandardSyncSummary@29d886dd[status=completed,recordsSynced=4730,bytesSynced=3861687,startTime=1665485064292,endTime=1665485129208,totalStats=io.airbyte.config.SyncStats@5c7dad5a[recordsEmitted=4730,bytesEmitted=3861687,sourceStateMessagesEmitted=0,destinationStateMessagesEmitted=0,recordsCommitted=4730,meanSecondsBeforeSourceStateMessageEmitted=0,maxSecondsBeforeSourceStateMessageEmitted=0,maxSecondsBetweenStateMessageEmittedandCommitted=0,meanSecondsBetweenStateMessageEmittedandCommitted=0,additionalProperties={}],streamStats=[io.airbyte.config.StreamSyncStats@183b888f[streamName=GET_MERCHANT_LISTINGS_ALL_DATA,stats=io.airbyte.config.SyncStats@2474fdaf[recordsEmitted=4730,bytesEmitted=3861687,sourceStateMessagesEmitted=,destinationStateMessagesEmitted=,recordsCommitted=4730,meanSecondsBeforeSourceStateMessageEmitted=,maxSecondsBeforeSourceStateMessageEmitted=,maxSecondsBetweenStateMessageEmittedandCommitted=,meanSecondsBetweenStateMessageEmittedandCommitted=,additionalProperties={}]]]],normalizationSummary=,state=io.airbyte.config.State@4f5648dd[state={}],outputCatalog=io.airbyte.protocol.models.ConfiguredAirbyteCatalog@49f77992[streams=[io.airbyte.protocol.models.ConfiguredAirbyteStream@78d11a8b[stream=io.airbyte.protocol.models.AirbyteStream@3c6a9aee[name=GET_MERCHANT_LISTINGS_ALL_DATA,jsonSchema={"type":"object","title":"Get Merchant Listings Reports","$schema":"http://json-schema.org/draft-07/schema#","properties":{"asin1":{"type":["null","string"]},"asin2":{"type":["null","string"]},"asin3":{"type":["null","string"]},"price":{"type":["null","number"]},"status":{"type":["null","string"]},"quantity":{"type":["null","number"]},"image-url":{"type":["null","string"]},"item-name":{"type":["null","string"]},"item-note":{"type":["null","string"]},"open-date":{"type":["null","string"]},"add-delete":{"type":["null","string"]},"listing-id":{"type":["null","string"]},"product-id":{"type":["null","string"]},"seller-sku":{"type":["null","string"]},"item-condition":{"type":["null","string"]},"zshop-boldface":{"type":["null","string"]},"product-id-type":{"type":["null","string"]},"zshop-category1":{"type":["null","string"]},"item-description":{"type":["null","string"]},"pending-quantity":{"type":["null","number"]},"zshop-browse-path":{"type":["null","string"]},"expedited-shipping":{"type":["null","string"]},"zshop-shipping-fee":{"type":["null","string"]},"fulfillment-channel":{"type":["null","string"]},"item-is-marketplace":{"type":["null","string"]},"merchant-shipping-group":{"type":["null","string"]},"zshop-storefront-feature":{"type":["null","string"]},"will-ship-internationally":{"type":["null","string"]},"bid-for-featured-placement":{"type":["null","string"]}},"description":"Get Merchant Listings All Data Reports"},supportedSyncModes=[full_refresh],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=append,primaryKey=[],additionalProperties={}]],additionalProperties={}],failures=[]] 2022-10-11 10:45:29 INFO i.a.w.t.s.ReplicationActivityImpl(lambda$replicate$3):162 - Sync summary length: 3180 2022-10-11 10:45:29 INFO i.a.c.t.TemporalUtils(withBackgroundHeartbeat):280 - Stopping temporal heartbeating... 2022-10-11 10:45:29 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:45:29 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END REPLICATION ----- 2022-10-11 10:45:29 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:45:29 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):50 - Using default value for environment variable NEED_STATE_VALIDATION: 'true' 2022-10-11 10:45:29 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/167/0/logs.log 2022-10-11 10:45:29 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.40.12 2022-10-11 10:45:29 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:45:29 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START DEFAULT NORMALIZATION ----- 2022-10-11 10:45:29 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:45:29 INFO i.a.w.n.DefaultNormalizationRunner(runProcess):134 - Running with normalization version: airbyte/normalization-mysql:0.2.22 2022-10-11 10:45:29 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/normalization-mysql:0.2.22 exists... 2022-10-11 10:45:29 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/normalization-mysql:0.2.22 was found locally. 2022-10-11 10:45:29 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = normalization-mysql-normalize-167-0-lvnwp with resources io.airbyte.config.ResourceRequirements@34f25427[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-10-11 10:45:29 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/167/0/normalize --log-driver none --name normalization-mysql-normalize-167-0-lvnwp --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_VERSION=0.40.12 airbyte/normalization-mysql:0.2.22 run --integration-type mysql --config destination_config.json --catalog destination_catalog.json 2022-10-11 10:45:29 normalization > Running: transform-config --config destination_config.json --integration-type mysql --out /data/167/0/normalize 2022-10-11 10:45:30 normalization > Namespace(config='destination_config.json', integration_type=, out='/data/167/0/normalize') 2022-10-11 10:45:30 normalization > transform_mysql 2022-10-11 10:45:30 normalization > Running: transform-catalog --integration-type mysql --profile-config-dir /data/167/0/normalize --catalog destination_catalog.json --out /data/167/0/normalize/models/generated/ --json-column _airbyte_data 2022-10-11 10:45:30 normalization > Processing destination_catalog.json... 2022-10-11 10:45:30 normalization > Generating airbyte_ctes/mszweirad/get_merchant_listings_all_data_ab1.sql from GET_MERCHANT_LISTINGS_ALL_DATA 2022-10-11 10:45:30 normalization > Generating airbyte_ctes/mszweirad/get_merchant_listings_all_data_ab2.sql from GET_MERCHANT_LISTINGS_ALL_DATA 2022-10-11 10:45:30 normalization > Truncating _airbyte_get_merchant_listings_all_data_hashid (#46) to _airbyte_get_merchant_tings_all_data_hashid (#44) 2022-10-11 10:45:30 normalization > Generating airbyte_ctes/mszweirad/get_merchant_listings_all_data_ab3.sql from GET_MERCHANT_LISTINGS_ALL_DATA 2022-10-11 10:45:30 normalization > Truncating _airbyte_get_merchant_listings_all_data_hashid (#46) to _airbyte_get_merchant_tings_all_data_hashid (#44) 2022-10-11 10:45:30 normalization > Generating airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql from GET_MERCHANT_LISTINGS_ALL_DATA 2022-10-11 10:45:30 normalization > detected no config file for ssh, assuming ssh is off. 2022-10-11 10:45:31 normalization > [--event-buffer-size EVENT_BUFFER_SIZE] 2022-10-11 10:45:31 normalization > --event-buffer-size EVENT_BUFFER_SIZE 2022-10-11 10:45:31 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:45:31 normalization > DBT >=1.0.0 detected; using 10K event buffer size 2022-10-11 10:45:31 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:45:33 normalization > Running with dbt=1.0.0 2022-10-11 10:45:33 normalization > Partial parse save file not found. Starting full parse. 2022-10-11 10:45:34 normalization > [WARNING]: Configuration paths exist in your dbt_project.yml file which do not apply to any resources. There are 2 unused configuration paths: - models.airbyte_utils.generated.airbyte_views - models.airbyte_utils.generated.airbyte_tables 2022-10-11 10:45:34 normalization > Found 4 models, 0 tests, 0 snapshots, 0 analyses, 584 macros, 0 operations, 0 seed files, 1 source, 0 exposures, 0 metrics 2022-10-11 10:45:34 normalization > Concurrency: 1 threads (target='prod') 2022-10-11 10:45:34 normalization > 1 of 1 START table model mszweirad.get_merchant_listings_all_data....................................................... [RUN] 2022-10-11 10:45:34 normalization > 1 of 1 ERROR creating table model mszweirad.get_merchant_listings_all_data.............................................. [ERROR in 0.09s] 2022-10-11 10:45:34 normalization > Finished running 1 table model in 0.28s. 2022-10-11 10:45:34 normalization > Completed with 1 error and 0 warnings: 2022-10-11 10:45:34 normalization > Database Error in model get_merchant_listings_all_data (models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql) 2022-10-11 10:45:34 normalization > 1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders' 2022-10-11 10:45:34 normalization > compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql 2022-10-11 10:45:34 normalization > Done. PASS=0 WARN=0 ERROR=1 SKIP=0 TOTAL=1 2022-10-11 10:45:34 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:45:34 normalization > Diagnosing dbt debug to check if destination is available for dbt and well configured (1): 2022-10-11 10:45:34 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:45:35 normalization > 10:45:35 Running with dbt=1.0.0 2022-10-11 10:45:35 normalization > dbt version: 1.0.0 2022-10-11 10:45:35 normalization > python version: 3.9.9 2022-10-11 10:45:35 normalization > python path: /usr/local/bin/python 2022-10-11 10:45:35 normalization > os info: Linux-5.10.16.3-microsoft-standard-WSL2-x86_64-with-glibc2.31 2022-10-11 10:45:35 normalization > Using profiles.yml file at /data/167/0/normalize/profiles.yml 2022-10-11 10:45:35 normalization > Using dbt_project.yml file at /data/167/0/normalize/dbt_project.yml 2022-10-11 10:45:35 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:45:35 normalization > Configuration: 2022-10-11 10:45:35 normalization > profiles.yml file [OK found and valid] 2022-10-11 10:45:35 normalization > dbt_project.yml file [OK found and valid] 2022-10-11 10:45:35 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:45:35 normalization > Required dependencies: 2022-10-11 10:45:35 normalization > - git [OK found] 2022-10-11 10:45:35 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:45:35 normalization > Connection: 2022-10-11 10:45:35 normalization > server: localhost 2022-10-11 10:45:35 normalization > port: 3308 2022-10-11 10:45:35 normalization > database: None 2022-10-11 10:45:35 normalization > schema: mszweirad 2022-10-11 10:45:35 normalization > user: root 2022-10-11 10:45:35 normalization > Connection test: [OK connection ok] 2022-10-11 10:45:35 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:45:35 normalization > All checks passed! 2022-10-11 10:45:36 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:45:36 normalization > Forward dbt output logs to diagnose/debug errors (0): 2022-10-11 10:45:36 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:45:36 normalization > Running with dbt=1.0.0 2022-10-11 10:45:36 normalization > Partial parse save file not found. Starting full parse. 2022-10-11 10:45:36 normalization > [WARNING]: Configuration paths exist in your dbt_project.yml file which do not apply to any resources. There are 2 unused configuration paths: - models.airbyte_utils.generated.airbyte_views - models.airbyte_utils.generated.airbyte_tables 2022-10-11 10:45:36 normalization > Found 4 models, 0 tests, 0 snapshots, 0 analyses, 584 macros, 0 operations, 0 seed files, 1 source, 0 exposures, 0 metrics 2022-10-11 10:45:36 normalization > Concurrency: 1 threads (target='prod') 2022-10-11 10:45:36 normalization > 1 of 1 START table model mszweirad.get_merchant_listings_all_data....................................................... [RUN] 2022-10-11 10:45:36 normalization > 1 of 1 ERROR creating table model mszweirad.get_merchant_listings_all_data.............................................. [ERROR in 0.09s] 2022-10-11 10:45:36 normalization > Finished running 1 table model in 0.28s. 2022-10-11 10:45:36 normalization > Completed with 1 error and 0 warnings: 2022-10-11 10:45:36 normalization > Database Error in model get_merchant_listings_all_data (models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql) 2022-10-11 10:45:36 normalization > 1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders' 2022-10-11 10:45:36 normalization > compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql 2022-10-11 10:45:36 normalization > Done. PASS=0 WARN=0 ERROR=1 SKIP=0 TOTAL=1 2022-10-11 10:45:36 INFO i.a.w.g.DefaultNormalizationWorker(run):82 - Normalization executed in 6 seconds. 2022-10-11 10:45:36 ERROR i.a.w.g.DefaultNormalizationWorker(run):90 - Normalization Failed. 2022-10-11 10:45:36 INFO i.a.w.g.DefaultNormalizationWorker(run):95 - Normalization summary: io.airbyte.config.NormalizationSummary@534c5ec3[startTime=1665485129395,endTime=1665485136131,failures=[io.airbyte.config.FailureReason@3b358c2f[failureOrigin=normalization,failureType=system_error,internalMessage=1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders',externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@1dc0a402[additionalProperties={attemptNumber=0, jobId=167, from_trace_message=true}],stacktrace=AirbyteDbtError: 1 of 1 ERROR creating table model mszweirad.get_merchant_listings_all_data.............................................. [ERROR in 0.09s] Database Error in model get_merchant_listings_all_data (models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql) 1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders' compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql 1 of 1 ERROR creating table model mszweirad.get_merchant_listings_all_data.............................................. [ERROR in 0.09s] Database Error in model get_merchant_listings_all_data (models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql) 1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders' compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql,retryable=,timestamp=1665485136130], io.airbyte.config.FailureReason@67f9318[failureOrigin=normalization,failureType=system_error,internalMessage=1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders',externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@37747f52[additionalProperties={attemptNumber=0, jobId=167, from_trace_message=true}],stacktrace=AirbyteDbtError: 1 of 1 ERROR creating table model mszweirad.get_merchant_listings_all_data.............................................. [ERROR in 0.09s] Database Error in model get_merchant_listings_all_data (models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql) 1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders' compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql 1 of 1 ERROR creating table model mszweirad.get_merchant_listings_all_data.............................................. [ERROR in 0.09s] Database Error in model get_merchant_listings_all_data (models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql) 1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders' compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql,retryable=,timestamp=1665485136130]]] 2022-10-11 10:45:36 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-10-11 10:45:36 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:45:36 INFO i.a.c.t.TemporalUtils(withBackgroundHeartbeat):280 - Stopping temporal heartbeating... 2022-10-11 10:45:36 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END DEFAULT NORMALIZATION ----- 2022-10-11 10:45:36 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:45:36 INFO i.a.a.LoggingTrackingClient(track):43 - track. version: null, userId: null, action: Connector Jobs, metadata: {job_type=sync, namespace_definition=destination, config.source.auth_type=oauth2.0, config.source.aws_access_key._secret=set, config.destination.tunnel_method.tunnel_method=NO_TUNNEL, config.source.replication_start_date=set, config.source.period_in_days=set, frequency=manual, connector_source_definition_id=e55879a8-0ef8-4557-abcf-ab34c53ec460, config.destination.port=set, workspace_id=75163712-cfa4-4f06-88be-82fab7cb88db, config.destination.database=set, attempt_stage=STARTED, config.destination.password._secret=set, attempt_id=2, connector_destination=MySQL, connector_destination_docker_repository=airbyte/destination-mysql, config.source.lwa_client_secret._secret=set, table_prefix=false, workspace_name=75163712-cfa4-4f06-88be-82fab7cb88db, config.source.region=DE, config.source.lwa_app_id=set, number_of_streams=1, connector_source=Amazon Seller Partner, config.source.app_id._secret=set, config.destination.host=set, connector_source_docker_repository=airbyte/source-amazon-seller-partner, config.source.max_wait_seconds=set, config.destination.username=set, catalog.sync_mode.full_refresh=set, connection_id=b2a5833d-a68e-4dca-9297-f8983fa0dc97, job_id=167, connector_source_version=0.2.27, catalog.destination_sync_mode.append=set, connector_destination_version=0.1.20, config.source.aws_environment=PRODUCTION, operation.normalization=1, config.destination.ssl=false, operation_count=1, config.source.refresh_token._secret=set, connector_destination_definition_id=ca81ee7c-3163-4246-af40-094cc31e5e42, config.source.aws_secret_key._secret=set, config.source.role_arn._secret=set} 2022-10-11 10:45:36 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/167/1/logs.log 2022-10-11 10:45:36 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.40.12 2022-10-11 10:45:36 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:45:36 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START CHECK ----- 2022-10-11 10:45:36 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:45:36 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/source-amazon-seller-partner:0.2.27 exists... 2022-10-11 10:45:36 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/source-amazon-seller-partner:0.2.27 was found locally. 2022-10-11 10:45:36 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = source-amazon-seller-partner-check-167-1-kmsoo with resources io.airbyte.config.ResourceRequirements@72a15bff[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-10-11 10:45:36 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/167/1 --log-driver none --name source-amazon-seller-partner-check-167-1-kmsoo --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e WORKER_CONNECTOR_IMAGE=airbyte/source-amazon-seller-partner:0.2.27 -e WORKER_JOB_ATTEMPT=1 -e AIRBYTE_VERSION=0.40.12 -e WORKER_JOB_ID=167 airbyte/source-amazon-seller-partner:0.2.27 check --config source_config.json 2022-10-11 10:45:39 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):109 - Check succeeded 2022-10-11 10:45:40 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-10-11 10:45:40 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:45:40 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END CHECK ----- 2022-10-11 10:45:40 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:45:40 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/167/1/logs.log 2022-10-11 10:45:40 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.40.12 2022-10-11 10:45:40 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:45:40 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START CHECK ----- 2022-10-11 10:45:40 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:45:40 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/destination-mysql:0.1.20 exists... 2022-10-11 10:45:40 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/destination-mysql:0.1.20 was found locally. 2022-10-11 10:45:40 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = destination-mysql-check-167-1-zjsja with resources io.airbyte.config.ResourceRequirements@72a15bff[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-10-11 10:45:40 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/167/1 --log-driver none --name destination-mysql-check-167-1-zjsja --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e WORKER_CONNECTOR_IMAGE=airbyte/destination-mysql:0.1.20 -e WORKER_JOB_ATTEMPT=1 -e AIRBYTE_VERSION=0.40.12 -e WORKER_JOB_ID=167 airbyte/destination-mysql:0.1.20 check --config source_config.json 2022-10-11 10:45:40 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Class path contains multiple SLF4J bindings. 2022-10-11 10:45:40 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-10-11 10:45:40 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-10-11 10:45:40 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Found binding in [jar:file:/airbyte/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-10-11 10:45:40 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2022-10-11 10:45:40 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] 2022-10-11 10:45:41 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:45:41 INFO i.a.i.d.m.MySQLDestination(main):136 - starting destination: class io.airbyte.integrations.destination.mysql.MySQLDestination 2022-10-11 10:45:41 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:45:41 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {check=null, config=source_config.json} 2022-10-11 10:45:41 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:45:41 INFO i.a.i.b.IntegrationRunner(runInternal):123 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-10-11 10:45:41 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:45:41 INFO i.a.i.b.IntegrationRunner(runInternal):124 - Command: CHECK 2022-10-11 10:45:41 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:45:41 INFO i.a.i.b.IntegrationRunner(runInternal):125 - Integration config: IntegrationConfig{command=CHECK, configPath='source_config.json', catalogPath='null', statePath='null'} 2022-10-11 10:45:41 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:45:41 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-10-11 10:45:41 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:45:41 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-10-11 10:45:41 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:45:41 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-10-11 10:45:41 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:45:41 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword multiline - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-10-11 10:45:41 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:45:41 INFO i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL 2022-10-11 10:45:41 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:45:41 INFO c.z.h.HikariDataSource():80 - HikariPool-1 - Starting... 2022-10-11 10:45:41 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:45:41 INFO c.z.h.HikariDataSource():82 - HikariPool-1 - Start completed. 2022-10-11 10:45:41 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:45:41 INFO c.z.h.HikariDataSource(close):350 - HikariPool-1 - Shutdown initiated... 2022-10-11 10:45:41 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:45:41 INFO c.z.h.HikariDataSource(close):352 - HikariPool-1 - Shutdown completed. 2022-10-11 10:45:41 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:45:41 INFO i.a.i.b.IntegrationRunner(runInternal):171 - Completed integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-10-11 10:45:41 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:45:41 INFO i.a.i.d.m.MySQLDestination(main):138 - completed destination: class io.airbyte.integrations.destination.mysql.MySQLDestination 2022-10-11 10:45:41 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-10-11 10:45:41 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:45:41 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END CHECK ----- 2022-10-11 10:45:41 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:45:41 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/167/1/logs.log 2022-10-11 10:45:41 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.40.12 2022-10-11 10:45:41 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):50 - Using default value for environment variable LOG_CONNECTOR_MESSAGES: 'false' 2022-10-11 10:45:41 INFO i.a.c.EnvConfigs(getEnvOrDefault):1091 - Using default value for environment variable METRIC_CLIENT: '' 2022-10-11 10:45:41 WARN i.a.m.l.MetricClientFactory(initialize):60 - Metric client is already initialized to 2022-10-11 10:45:41 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):50 - Using default value for environment variable LOG_CONNECTOR_MESSAGES: 'false' 2022-10-11 10:45:41 INFO i.a.w.g.DefaultReplicationWorker(run):122 - start sync worker. job id: 167 attempt id: 1 2022-10-11 10:45:41 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:45:41 INFO i.a.w.g.DefaultReplicationWorker(run):135 - configured sync modes: {null.GET_MERCHANT_LISTINGS_ALL_DATA=full_refresh - append} 2022-10-11 10:45:41 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START REPLICATION ----- 2022-10-11 10:45:41 INFO i.a.w.i.DefaultAirbyteDestination(start):65 - Running destination... 2022-10-11 10:45:41 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:45:41 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/destination-mysql:0.1.20 exists... 2022-10-11 10:45:42 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/destination-mysql:0.1.20 was found locally. 2022-10-11 10:45:42 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = destination-mysql-write-167-1-fqzje with resources io.airbyte.config.ResourceRequirements@67ec6fec[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-10-11 10:45:42 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/167/1 --log-driver none --name destination-mysql-write-167-1-fqzje --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e WORKER_CONNECTOR_IMAGE=airbyte/destination-mysql:0.1.20 -e WORKER_JOB_ATTEMPT=1 -e AIRBYTE_VERSION=0.40.12 -e WORKER_JOB_ID=167 airbyte/destination-mysql:0.1.20 write --config destination_config.json --catalog destination_catalog.json 2022-10-11 10:45:42 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/source-amazon-seller-partner:0.2.27 exists... 2022-10-11 10:45:42 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/source-amazon-seller-partner:0.2.27 was found locally. 2022-10-11 10:45:42 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = source-amazon-seller-partner-read-167-1-bkoqi with resources io.airbyte.config.ResourceRequirements@52d79af7[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-10-11 10:45:42 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/167/1 --log-driver none --name source-amazon-seller-partner-read-167-1-bkoqi --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e WORKER_CONNECTOR_IMAGE=airbyte/source-amazon-seller-partner:0.2.27 -e WORKER_JOB_ATTEMPT=1 -e AIRBYTE_VERSION=0.40.12 -e WORKER_JOB_ID=167 airbyte/source-amazon-seller-partner:0.2.27 read --config source_config.json --catalog source_catalog.json --state input_state.json 2022-10-11 10:45:42 INFO i.a.w.g.DefaultReplicationWorker(run):177 - Waiting for source and destination threads to complete. 2022-10-11 10:45:42 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):435 - Destination output thread started. 2022-10-11 10:45:42 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):322 - Replication thread started. 2022-10-11 10:45:42 destination > SLF4J: Class path contains multiple SLF4J bindings. 2022-10-11 10:45:42 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-10-11 10:45:42 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-10-11 10:45:42 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-10-11 10:45:42 destination > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2022-10-11 10:45:42 destination > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] 2022-10-11 10:45:42 source > Starting syncing SourceAmazonSellerPartner 2022-10-11 10:45:42 destination > 2022-10-11 10:45:42 INFO i.a.i.d.m.MySQLDestination(main):136 - starting destination: class io.airbyte.integrations.destination.mysql.MySQLDestination 2022-10-11 10:45:42 destination > 2022-10-11 10:45:42 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {catalog=destination_catalog.json, write=null, config=destination_config.json} 2022-10-11 10:45:42 destination > 2022-10-11 10:45:42 INFO i.a.i.b.IntegrationRunner(runInternal):123 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-10-11 10:45:42 destination > 2022-10-11 10:45:42 INFO i.a.i.b.IntegrationRunner(runInternal):124 - Command: WRITE 2022-10-11 10:45:42 destination > 2022-10-11 10:45:42 INFO i.a.i.b.IntegrationRunner(runInternal):125 - Integration config: IntegrationConfig{command=WRITE, configPath='destination_config.json', catalogPath='destination_catalog.json', statePath='null'} 2022-10-11 10:45:43 destination > 2022-10-11 10:45:43 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-10-11 10:45:43 destination > 2022-10-11 10:45:43 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-10-11 10:45:43 destination > 2022-10-11 10:45:43 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-10-11 10:45:43 destination > 2022-10-11 10:45:43 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword multiline - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-10-11 10:45:43 source > Syncing stream: GET_MERCHANT_LISTINGS_ALL_DATA 2022-10-11 10:45:43 destination > 2022-10-11 10:45:43 INFO i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL 2022-10-11 10:45:43 destination > 2022-10-11 10:45:43 INFO c.z.h.HikariDataSource():80 - HikariPool-1 - Starting... 2022-10-11 10:45:43 destination > 2022-10-11 10:45:43 INFO c.z.h.HikariDataSource():82 - HikariPool-1 - Start completed. 2022-10-11 10:45:43 destination > 2022-10-11 10:45:43 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):98 - Write config: WriteConfig{streamName=GET_MERCHANT_LISTINGS_ALL_DATA, namespace=null, outputSchemaName=mszweirad, tmpTableName=_airbyte_tmp_orn_get___ant_listings_all_data, outputTableName=_airbyte_raw_get_merchant_listings_all_data, syncMode=append} 2022-10-11 10:45:43 destination > 2022-10-11 10:45:43 INFO i.a.i.d.b.BufferedStreamConsumer(startTracked):116 - class io.airbyte.integrations.destination.buffered_stream_consumer.BufferedStreamConsumer started. 2022-10-11 10:45:43 destination > 2022-10-11 10:45:43 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):123 - Preparing tmp tables in destination started for 1 streams 2022-10-11 10:45:43 destination > 2022-10-11 10:45:43 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):127 - Preparing tmp table in destination started for stream GET_MERCHANT_LISTINGS_ALL_DATA. schema: mszweirad, tmp table name: _airbyte_tmp_orn_get___ant_listings_all_data 2022-10-11 10:45:43 destination > 2022-10-11 10:45:43 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):133 - Preparing tables in destination completed. 2022-10-11 10:46:44 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):352 - Records read: 1000 (807 KB) 2022-10-11 10:46:44 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):352 - Records read: 2000 (1 MB) 2022-10-11 10:46:45 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):352 - Records read: 3000 (2 MB) 2022-10-11 10:46:45 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):352 - Records read: 4000 (3 MB) 2022-10-11 10:46:45 source > Read 4730 records from GET_MERCHANT_LISTINGS_ALL_DATA stream 2022-10-11 10:46:45 source > Finished syncing GET_MERCHANT_LISTINGS_ALL_DATA 2022-10-11 10:46:45 source > SourceAmazonSellerPartner runtimes: Syncing stream GET_MERCHANT_LISTINGS_ALL_DATA 0:01:02.254339 2022-10-11 10:46:45 source > Finished syncing SourceAmazonSellerPartner 2022-10-11 10:46:45 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):355 - Source has no more messages, closing connection. 2022-10-11 10:46:45 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):363 - Total records read: 4730 (3 MB) 2022-10-11 10:46:45 WARN i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$5):366 - Schema validation errors found for stream GET_MERCHANT_LISTINGS_ALL_DATA. Error messages: [$.quantity is of an incorrect type. Expected it to be [null, number], $.pending-quantity is of an incorrect type. Expected it to be [null, number], $.price is of an incorrect type. Expected it to be [null, number]] 2022-10-11 10:46:45 INFO i.a.w.g.DefaultReplicationWorker(run):182 - One of source or destination thread complete. Waiting on the other. 2022-10-11 10:46:45 destination > 2022-10-11 10:46:45 INFO i.a.i.b.FailureTrackingAirbyteMessageConsumer(close):65 - Airbyte message consumer: succeeded. 2022-10-11 10:46:45 destination > 2022-10-11 10:46:45 INFO i.a.i.d.b.BufferedStreamConsumer(close):171 - executing on success close procedure. 2022-10-11 10:46:45 destination > 2022-10-11 10:46:45 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing GET_MERCHANT_LISTINGS_ALL_DATA: 4730 records (14 MB) 2022-10-11 10:46:46 destination > 2022-10-11 10:46:46 INFO i.a.i.d.j.SqlOperations(onDestinationCloseOperations):138 - No onDestinationCloseOperations required for this destination. 2022-10-11 10:46:46 destination > 2022-10-11 10:46:46 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):163 - Finalizing tables in destination started for 1 streams 2022-10-11 10:46:46 destination > 2022-10-11 10:46:46 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):168 - Finalizing stream GET_MERCHANT_LISTINGS_ALL_DATA. schema mszweirad, tmp table _airbyte_tmp_orn_get___ant_listings_all_data, final table _airbyte_raw_get_merchant_listings_all_data 2022-10-11 10:46:46 destination > 2022-10-11 10:46:46 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):181 - Executing finalization of tables. 2022-10-11 10:46:46 destination > 2022-10-11 10:46:46 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):183 - Finalizing tables in destination completed. 2022-10-11 10:46:46 destination > 2022-10-11 10:46:46 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):186 - Cleaning tmp tables in destination started for 1 streams 2022-10-11 10:46:46 destination > 2022-10-11 10:46:46 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):190 - Cleaning tmp table in destination started for stream GET_MERCHANT_LISTINGS_ALL_DATA. schema mszweirad, tmp table name: _airbyte_tmp_orn_get___ant_listings_all_data 2022-10-11 10:46:46 destination > 2022-10-11 10:46:46 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):195 - Cleaning tmp tables in destination completed. 2022-10-11 10:46:46 destination > 2022-10-11 10:46:46 INFO i.a.i.b.IntegrationRunner(runInternal):171 - Completed integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-10-11 10:46:46 destination > 2022-10-11 10:46:46 INFO i.a.i.d.m.MySQLDestination(main):138 - completed destination: class io.airbyte.integrations.destination.mysql.MySQLDestination 2022-10-11 10:46:46 INFO i.a.w.g.DefaultReplicationWorker(run):184 - Source and destination threads complete. 2022-10-11 10:46:46 INFO i.a.w.g.DefaultReplicationWorker(run):281 - Source did not output any state messages 2022-10-11 10:46:46 WARN i.a.w.g.DefaultReplicationWorker(run):289 - State capture: No new state, falling back on input state: io.airbyte.config.State@3c608eb9[state={}] 2022-10-11 10:46:46 INFO i.a.w.g.DefaultReplicationWorker(run):300 - sync summary: { "status" : "completed", "recordsSynced" : 4730, "bytesSynced" : 3861687, "startTime" : 1665485141910, "endTime" : 1665485206946, "totalStats" : { "recordsEmitted" : 4730, "bytesEmitted" : 3861687, "sourceStateMessagesEmitted" : 0, "destinationStateMessagesEmitted" : 0, "recordsCommitted" : 4730, "meanSecondsBeforeSourceStateMessageEmitted" : 0, "maxSecondsBeforeSourceStateMessageEmitted" : 0, "maxSecondsBetweenStateMessageEmittedandCommitted" : 0, "meanSecondsBetweenStateMessageEmittedandCommitted" : 0 }, "streamStats" : [ { "streamName" : "GET_MERCHANT_LISTINGS_ALL_DATA", "stats" : { "recordsEmitted" : 4730, "bytesEmitted" : 3861687, "recordsCommitted" : 4730 } } ] } 2022-10-11 10:46:46 INFO i.a.w.g.DefaultReplicationWorker(run):301 - failures: [ ] 2022-10-11 10:46:46 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:46:46 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END REPLICATION ----- 2022-10-11 10:46:46 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:46:46 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-10-11 10:46:46 INFO i.a.w.t.s.ReplicationActivityImpl(lambda$replicate$3):157 - sync summary: io.airbyte.config.StandardSyncOutput@57c9def2[standardSyncSummary=io.airbyte.config.StandardSyncSummary@12cb5a6f[status=completed,recordsSynced=4730,bytesSynced=3861687,startTime=1665485141910,endTime=1665485206946,totalStats=io.airbyte.config.SyncStats@42066011[recordsEmitted=4730,bytesEmitted=3861687,sourceStateMessagesEmitted=0,destinationStateMessagesEmitted=0,recordsCommitted=4730,meanSecondsBeforeSourceStateMessageEmitted=0,maxSecondsBeforeSourceStateMessageEmitted=0,maxSecondsBetweenStateMessageEmittedandCommitted=0,meanSecondsBetweenStateMessageEmittedandCommitted=0,additionalProperties={}],streamStats=[io.airbyte.config.StreamSyncStats@2393ecf5[streamName=GET_MERCHANT_LISTINGS_ALL_DATA,stats=io.airbyte.config.SyncStats@3ab4883b[recordsEmitted=4730,bytesEmitted=3861687,sourceStateMessagesEmitted=,destinationStateMessagesEmitted=,recordsCommitted=4730,meanSecondsBeforeSourceStateMessageEmitted=,maxSecondsBeforeSourceStateMessageEmitted=,maxSecondsBetweenStateMessageEmittedandCommitted=,meanSecondsBetweenStateMessageEmittedandCommitted=,additionalProperties={}]]]],normalizationSummary=,state=io.airbyte.config.State@3c608eb9[state={}],outputCatalog=io.airbyte.protocol.models.ConfiguredAirbyteCatalog@72e4a520[streams=[io.airbyte.protocol.models.ConfiguredAirbyteStream@3935585[stream=io.airbyte.protocol.models.AirbyteStream@3f5bf546[name=GET_MERCHANT_LISTINGS_ALL_DATA,jsonSchema={"type":"object","title":"Get Merchant Listings Reports","$schema":"http://json-schema.org/draft-07/schema#","properties":{"asin1":{"type":["null","string"]},"asin2":{"type":["null","string"]},"asin3":{"type":["null","string"]},"price":{"type":["null","number"]},"status":{"type":["null","string"]},"quantity":{"type":["null","number"]},"image-url":{"type":["null","string"]},"item-name":{"type":["null","string"]},"item-note":{"type":["null","string"]},"open-date":{"type":["null","string"]},"add-delete":{"type":["null","string"]},"listing-id":{"type":["null","string"]},"product-id":{"type":["null","string"]},"seller-sku":{"type":["null","string"]},"item-condition":{"type":["null","string"]},"zshop-boldface":{"type":["null","string"]},"product-id-type":{"type":["null","string"]},"zshop-category1":{"type":["null","string"]},"item-description":{"type":["null","string"]},"pending-quantity":{"type":["null","number"]},"zshop-browse-path":{"type":["null","string"]},"expedited-shipping":{"type":["null","string"]},"zshop-shipping-fee":{"type":["null","string"]},"fulfillment-channel":{"type":["null","string"]},"item-is-marketplace":{"type":["null","string"]},"merchant-shipping-group":{"type":["null","string"]},"zshop-storefront-feature":{"type":["null","string"]},"will-ship-internationally":{"type":["null","string"]},"bid-for-featured-placement":{"type":["null","string"]}},"description":"Get Merchant Listings All Data Reports"},supportedSyncModes=[full_refresh],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=append,primaryKey=[],additionalProperties={}]],additionalProperties={}],failures=[]] 2022-10-11 10:46:46 INFO i.a.w.t.s.ReplicationActivityImpl(lambda$replicate$3):162 - Sync summary length: 3179 2022-10-11 10:46:46 INFO i.a.c.t.TemporalUtils(withBackgroundHeartbeat):280 - Stopping temporal heartbeating... 2022-10-11 10:46:46 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):50 - Using default value for environment variable NEED_STATE_VALIDATION: 'true' 2022-10-11 10:46:47 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/167/1/logs.log 2022-10-11 10:46:47 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.40.12 2022-10-11 10:46:47 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:46:47 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START DEFAULT NORMALIZATION ----- 2022-10-11 10:46:47 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:46:47 INFO i.a.w.n.DefaultNormalizationRunner(runProcess):134 - Running with normalization version: airbyte/normalization-mysql:0.2.22 2022-10-11 10:46:47 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/normalization-mysql:0.2.22 exists... 2022-10-11 10:46:47 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/normalization-mysql:0.2.22 was found locally. 2022-10-11 10:46:47 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = normalization-mysql-normalize-167-1-uopou with resources io.airbyte.config.ResourceRequirements@1e78d588[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-10-11 10:46:47 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/167/1/normalize --log-driver none --name normalization-mysql-normalize-167-1-uopou --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_VERSION=0.40.12 airbyte/normalization-mysql:0.2.22 run --integration-type mysql --config destination_config.json --catalog destination_catalog.json 2022-10-11 10:46:47 normalization > Running: transform-config --config destination_config.json --integration-type mysql --out /data/167/1/normalize 2022-10-11 10:46:47 normalization > Namespace(config='destination_config.json', integration_type=, out='/data/167/1/normalize') 2022-10-11 10:46:47 normalization > transform_mysql 2022-10-11 10:46:47 normalization > Running: transform-catalog --integration-type mysql --profile-config-dir /data/167/1/normalize --catalog destination_catalog.json --out /data/167/1/normalize/models/generated/ --json-column _airbyte_data 2022-10-11 10:46:47 normalization > Processing destination_catalog.json... 2022-10-11 10:46:47 normalization > Generating airbyte_ctes/mszweirad/get_merchant_listings_all_data_ab1.sql from GET_MERCHANT_LISTINGS_ALL_DATA 2022-10-11 10:46:47 normalization > Generating airbyte_ctes/mszweirad/get_merchant_listings_all_data_ab2.sql from GET_MERCHANT_LISTINGS_ALL_DATA 2022-10-11 10:46:47 normalization > Truncating _airbyte_get_merchant_listings_all_data_hashid (#46) to _airbyte_get_merchant_tings_all_data_hashid (#44) 2022-10-11 10:46:47 normalization > Generating airbyte_ctes/mszweirad/get_merchant_listings_all_data_ab3.sql from GET_MERCHANT_LISTINGS_ALL_DATA 2022-10-11 10:46:47 normalization > Truncating _airbyte_get_merchant_listings_all_data_hashid (#46) to _airbyte_get_merchant_tings_all_data_hashid (#44) 2022-10-11 10:46:47 normalization > Generating airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql from GET_MERCHANT_LISTINGS_ALL_DATA 2022-10-11 10:46:47 normalization > detected no config file for ssh, assuming ssh is off. 2022-10-11 10:46:49 normalization > [--event-buffer-size EVENT_BUFFER_SIZE] 2022-10-11 10:46:49 normalization > --event-buffer-size EVENT_BUFFER_SIZE 2022-10-11 10:46:49 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:46:49 normalization > DBT >=1.0.0 detected; using 10K event buffer size 2022-10-11 10:46:49 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:46:50 normalization > Running with dbt=1.0.0 2022-10-11 10:46:50 normalization > Partial parse save file not found. Starting full parse. 2022-10-11 10:46:51 normalization > [WARNING]: Configuration paths exist in your dbt_project.yml file which do not apply to any resources. There are 2 unused configuration paths: - models.airbyte_utils.generated.airbyte_views - models.airbyte_utils.generated.airbyte_tables 2022-10-11 10:46:51 normalization > Found 4 models, 0 tests, 0 snapshots, 0 analyses, 584 macros, 0 operations, 0 seed files, 1 source, 0 exposures, 0 metrics 2022-10-11 10:46:51 normalization > Concurrency: 1 threads (target='prod') 2022-10-11 10:46:52 normalization > 1 of 1 START table model mszweirad.get_merchant_listings_all_data....................................................... [RUN] 2022-10-11 10:46:52 normalization > 1 of 1 ERROR creating table model mszweirad.get_merchant_listings_all_data.............................................. [ERROR in 0.12s] 2022-10-11 10:46:52 normalization > Finished running 1 table model in 0.33s. 2022-10-11 10:46:52 normalization > Completed with 1 error and 0 warnings: 2022-10-11 10:46:52 normalization > Database Error in model get_merchant_listings_all_data (models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql) 2022-10-11 10:46:52 normalization > 1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders' 2022-10-11 10:46:52 normalization > compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql 2022-10-11 10:46:52 normalization > Done. PASS=0 WARN=0 ERROR=1 SKIP=0 TOTAL=1 2022-10-11 10:46:52 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:46:52 normalization > Diagnosing dbt debug to check if destination is available for dbt and well configured (1): 2022-10-11 10:46:52 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:46:53 normalization > 10:46:53 Running with dbt=1.0.0 2022-10-11 10:46:53 normalization > dbt version: 1.0.0 2022-10-11 10:46:53 normalization > python version: 3.9.9 2022-10-11 10:46:53 normalization > python path: /usr/local/bin/python 2022-10-11 10:46:53 normalization > os info: Linux-5.10.16.3-microsoft-standard-WSL2-x86_64-with-glibc2.31 2022-10-11 10:46:53 normalization > Using profiles.yml file at /data/167/1/normalize/profiles.yml 2022-10-11 10:46:53 normalization > Using dbt_project.yml file at /data/167/1/normalize/dbt_project.yml 2022-10-11 10:46:53 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:46:53 normalization > Configuration: 2022-10-11 10:46:53 normalization > profiles.yml file [OK found and valid] 2022-10-11 10:46:53 normalization > dbt_project.yml file [OK found and valid] 2022-10-11 10:46:53 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:46:53 normalization > Required dependencies: 2022-10-11 10:46:53 normalization > - git [OK found] 2022-10-11 10:46:53 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:46:53 normalization > Connection: 2022-10-11 10:46:53 normalization > server: localhost 2022-10-11 10:46:53 normalization > port: 3308 2022-10-11 10:46:53 normalization > database: None 2022-10-11 10:46:53 normalization > schema: mszweirad 2022-10-11 10:46:53 normalization > user: root 2022-10-11 10:46:53 normalization > Connection test: [OK connection ok] 2022-10-11 10:46:53 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:46:53 normalization > All checks passed! 2022-10-11 10:46:53 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:46:53 normalization > Forward dbt output logs to diagnose/debug errors (0): 2022-10-11 10:46:53 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:46:53 normalization > Running with dbt=1.0.0 2022-10-11 10:46:53 normalization > Partial parse save file not found. Starting full parse. 2022-10-11 10:46:53 normalization > [WARNING]: Configuration paths exist in your dbt_project.yml file which do not apply to any resources. There are 2 unused configuration paths: - models.airbyte_utils.generated.airbyte_views - models.airbyte_utils.generated.airbyte_tables 2022-10-11 10:46:53 normalization > Found 4 models, 0 tests, 0 snapshots, 0 analyses, 584 macros, 0 operations, 0 seed files, 1 source, 0 exposures, 0 metrics 2022-10-11 10:46:53 normalization > Concurrency: 1 threads (target='prod') 2022-10-11 10:46:53 normalization > 1 of 1 START table model mszweirad.get_merchant_listings_all_data....................................................... [RUN] 2022-10-11 10:46:53 normalization > 1 of 1 ERROR creating table model mszweirad.get_merchant_listings_all_data.............................................. [ERROR in 0.12s] 2022-10-11 10:46:53 normalization > Finished running 1 table model in 0.33s. 2022-10-11 10:46:53 normalization > Completed with 1 error and 0 warnings: 2022-10-11 10:46:53 normalization > Database Error in model get_merchant_listings_all_data (models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql) 2022-10-11 10:46:53 normalization > 1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders' 2022-10-11 10:46:53 normalization > compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql 2022-10-11 10:46:53 normalization > Done. PASS=0 WARN=0 ERROR=1 SKIP=0 TOTAL=1 2022-10-11 10:46:53 INFO i.a.w.g.DefaultNormalizationWorker(run):82 - Normalization executed in 6 seconds. 2022-10-11 10:46:53 ERROR i.a.w.g.DefaultNormalizationWorker(run):90 - Normalization Failed. 2022-10-11 10:46:53 INFO i.a.w.g.DefaultNormalizationWorker(run):95 - Normalization summary: io.airbyte.config.NormalizationSummary@2fac4c2f[startTime=1665485207131,endTime=1665485213927,failures=[io.airbyte.config.FailureReason@26db6f01[failureOrigin=normalization,failureType=system_error,internalMessage=1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders',externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@7e572ac7[additionalProperties={attemptNumber=1, jobId=167, from_trace_message=true}],stacktrace=AirbyteDbtError: 1 of 1 ERROR creating table model mszweirad.get_merchant_listings_all_data.............................................. [ERROR in 0.12s] Database Error in model get_merchant_listings_all_data (models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql) 1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders' compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql 1 of 1 ERROR creating table model mszweirad.get_merchant_listings_all_data.............................................. [ERROR in 0.12s] Database Error in model get_merchant_listings_all_data (models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql) 1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders' compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql,retryable=,timestamp=1665485213926], io.airbyte.config.FailureReason@d01109a[failureOrigin=normalization,failureType=system_error,internalMessage=1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders',externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@4081f821[additionalProperties={attemptNumber=1, jobId=167, from_trace_message=true}],stacktrace=AirbyteDbtError: 1 of 1 ERROR creating table model mszweirad.get_merchant_listings_all_data.............................................. [ERROR in 0.12s] Database Error in model get_merchant_listings_all_data (models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql) 1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders' compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql 1 of 1 ERROR creating table model mszweirad.get_merchant_listings_all_data.............................................. [ERROR in 0.12s] Database Error in model get_merchant_listings_all_data (models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql) 1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders' compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql,retryable=,timestamp=1665485213926]]] 2022-10-11 10:46:53 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-10-11 10:46:53 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:46:53 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END DEFAULT NORMALIZATION ----- 2022-10-11 10:46:53 INFO i.a.c.t.TemporalUtils(withBackgroundHeartbeat):280 - Stopping temporal heartbeating... 2022-10-11 10:46:53 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:46:54 INFO i.a.a.LoggingTrackingClient(track):43 - track. version: null, userId: null, action: Connector Jobs, metadata: {job_type=sync, namespace_definition=destination, config.source.auth_type=oauth2.0, config.source.aws_access_key._secret=set, config.destination.tunnel_method.tunnel_method=NO_TUNNEL, config.source.replication_start_date=set, config.source.period_in_days=set, frequency=manual, connector_source_definition_id=e55879a8-0ef8-4557-abcf-ab34c53ec460, config.destination.port=set, workspace_id=75163712-cfa4-4f06-88be-82fab7cb88db, config.destination.database=set, attempt_stage=STARTED, config.destination.password._secret=set, attempt_id=3, connector_destination=MySQL, connector_destination_docker_repository=airbyte/destination-mysql, config.source.lwa_client_secret._secret=set, table_prefix=false, workspace_name=75163712-cfa4-4f06-88be-82fab7cb88db, config.source.region=DE, config.source.lwa_app_id=set, number_of_streams=1, connector_source=Amazon Seller Partner, config.source.app_id._secret=set, config.destination.host=set, connector_source_docker_repository=airbyte/source-amazon-seller-partner, config.source.max_wait_seconds=set, config.destination.username=set, catalog.sync_mode.full_refresh=set, connection_id=b2a5833d-a68e-4dca-9297-f8983fa0dc97, job_id=167, connector_source_version=0.2.27, catalog.destination_sync_mode.append=set, connector_destination_version=0.1.20, config.source.aws_environment=PRODUCTION, operation.normalization=1, config.destination.ssl=false, operation_count=1, config.source.refresh_token._secret=set, connector_destination_definition_id=ca81ee7c-3163-4246-af40-094cc31e5e42, config.source.aws_secret_key._secret=set, config.source.role_arn._secret=set} 2022-10-11 10:46:54 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/167/2/logs.log 2022-10-11 10:46:54 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.40.12 2022-10-11 10:46:54 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:46:54 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START CHECK ----- 2022-10-11 10:46:54 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:46:54 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/source-amazon-seller-partner:0.2.27 exists... 2022-10-11 10:46:54 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/source-amazon-seller-partner:0.2.27 was found locally. 2022-10-11 10:46:54 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = source-amazon-seller-partner-check-167-2-ctcuq with resources io.airbyte.config.ResourceRequirements@72a15bff[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-10-11 10:46:54 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/167/2 --log-driver none --name source-amazon-seller-partner-check-167-2-ctcuq --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e WORKER_CONNECTOR_IMAGE=airbyte/source-amazon-seller-partner:0.2.27 -e WORKER_JOB_ATTEMPT=2 -e AIRBYTE_VERSION=0.40.12 -e WORKER_JOB_ID=167 airbyte/source-amazon-seller-partner:0.2.27 check --config source_config.json 2022-10-11 10:46:57 INFO i.a.w.i.DefaultAirbyteStreamFactory(internalLog):109 - Check succeeded 2022-10-11 10:46:57 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-10-11 10:46:57 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:46:57 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END CHECK ----- 2022-10-11 10:46:57 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:46:57 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/167/2/logs.log 2022-10-11 10:46:57 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.40.12 2022-10-11 10:46:57 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:46:57 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START CHECK ----- 2022-10-11 10:46:57 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:46:57 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/destination-mysql:0.1.20 exists... 2022-10-11 10:46:57 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/destination-mysql:0.1.20 was found locally. 2022-10-11 10:46:57 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = destination-mysql-check-167-2-ctpss with resources io.airbyte.config.ResourceRequirements@72a15bff[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-10-11 10:46:57 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/167/2 --log-driver none --name destination-mysql-check-167-2-ctpss --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e WORKER_CONNECTOR_IMAGE=airbyte/destination-mysql:0.1.20 -e WORKER_JOB_ATTEMPT=2 -e AIRBYTE_VERSION=0.40.12 -e WORKER_JOB_ID=167 airbyte/destination-mysql:0.1.20 check --config source_config.json 2022-10-11 10:46:58 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Class path contains multiple SLF4J bindings. 2022-10-11 10:46:58 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-10-11 10:46:58 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-10-11 10:46:58 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Found binding in [jar:file:/airbyte/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-10-11 10:46:58 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2022-10-11 10:46:58 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] 2022-10-11 10:46:58 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:46:58 INFO i.a.i.d.m.MySQLDestination(main):136 - starting destination: class io.airbyte.integrations.destination.mysql.MySQLDestination 2022-10-11 10:46:58 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:46:58 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {check=null, config=source_config.json} 2022-10-11 10:46:58 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:46:58 INFO i.a.i.b.IntegrationRunner(runInternal):123 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-10-11 10:46:58 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:46:58 INFO i.a.i.b.IntegrationRunner(runInternal):124 - Command: CHECK 2022-10-11 10:46:58 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:46:58 INFO i.a.i.b.IntegrationRunner(runInternal):125 - Integration config: IntegrationConfig{command=CHECK, configPath='source_config.json', catalogPath='null', statePath='null'} 2022-10-11 10:46:58 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:46:58 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-10-11 10:46:58 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:46:58 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-10-11 10:46:58 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:46:58 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-10-11 10:46:58 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:46:58 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword multiline - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-10-11 10:46:58 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:46:58 INFO i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL 2022-10-11 10:46:58 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:46:58 INFO c.z.h.HikariDataSource():80 - HikariPool-1 - Starting... 2022-10-11 10:46:58 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:46:58 INFO c.z.h.HikariDataSource():82 - HikariPool-1 - Start completed. 2022-10-11 10:46:59 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:46:59 INFO c.z.h.HikariDataSource(close):350 - HikariPool-1 - Shutdown initiated... 2022-10-11 10:46:59 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:46:59 INFO c.z.h.HikariDataSource(close):352 - HikariPool-1 - Shutdown completed. 2022-10-11 10:46:59 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:46:59 INFO i.a.i.b.IntegrationRunner(runInternal):171 - Completed integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-10-11 10:46:59 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-11 10:46:59 INFO i.a.i.d.m.MySQLDestination(main):138 - completed destination: class io.airbyte.integrations.destination.mysql.MySQLDestination 2022-10-11 10:46:59 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-10-11 10:46:59 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:46:59 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END CHECK ----- 2022-10-11 10:46:59 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:46:59 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/167/2/logs.log 2022-10-11 10:46:59 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.40.12 2022-10-11 10:46:59 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):50 - Using default value for environment variable LOG_CONNECTOR_MESSAGES: 'false' 2022-10-11 10:46:59 INFO i.a.c.EnvConfigs(getEnvOrDefault):1091 - Using default value for environment variable METRIC_CLIENT: '' 2022-10-11 10:46:59 WARN i.a.m.l.MetricClientFactory(initialize):60 - Metric client is already initialized to 2022-10-11 10:46:59 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):50 - Using default value for environment variable LOG_CONNECTOR_MESSAGES: 'false' 2022-10-11 10:46:59 INFO i.a.w.g.DefaultReplicationWorker(run):122 - start sync worker. job id: 167 attempt id: 2 2022-10-11 10:46:59 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:46:59 INFO i.a.w.g.DefaultReplicationWorker(run):135 - configured sync modes: {null.GET_MERCHANT_LISTINGS_ALL_DATA=full_refresh - append} 2022-10-11 10:46:59 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START REPLICATION ----- 2022-10-11 10:46:59 INFO i.a.w.i.DefaultAirbyteDestination(start):65 - Running destination... 2022-10-11 10:46:59 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:46:59 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/destination-mysql:0.1.20 exists... 2022-10-11 10:46:59 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/destination-mysql:0.1.20 was found locally. 2022-10-11 10:46:59 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = destination-mysql-write-167-2-pctzi with resources io.airbyte.config.ResourceRequirements@27eeeb0b[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-10-11 10:46:59 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/167/2 --log-driver none --name destination-mysql-write-167-2-pctzi --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e WORKER_CONNECTOR_IMAGE=airbyte/destination-mysql:0.1.20 -e WORKER_JOB_ATTEMPT=2 -e AIRBYTE_VERSION=0.40.12 -e WORKER_JOB_ID=167 airbyte/destination-mysql:0.1.20 write --config destination_config.json --catalog destination_catalog.json 2022-10-11 10:46:59 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/source-amazon-seller-partner:0.2.27 exists... 2022-10-11 10:46:59 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/source-amazon-seller-partner:0.2.27 was found locally. 2022-10-11 10:46:59 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = source-amazon-seller-partner-read-167-2-qfvjo with resources io.airbyte.config.ResourceRequirements@786e1432[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-10-11 10:46:59 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/167/2 --log-driver none --name source-amazon-seller-partner-read-167-2-qfvjo --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e WORKER_CONNECTOR_IMAGE=airbyte/source-amazon-seller-partner:0.2.27 -e WORKER_JOB_ATTEMPT=2 -e AIRBYTE_VERSION=0.40.12 -e WORKER_JOB_ID=167 airbyte/source-amazon-seller-partner:0.2.27 read --config source_config.json --catalog source_catalog.json --state input_state.json 2022-10-11 10:46:59 INFO i.a.w.g.DefaultReplicationWorker(run):177 - Waiting for source and destination threads to complete. 2022-10-11 10:46:59 INFO i.a.w.g.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$7):435 - Destination output thread started. 2022-10-11 10:46:59 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):322 - Replication thread started. 2022-10-11 10:47:00 destination > SLF4J: Class path contains multiple SLF4J bindings. 2022-10-11 10:47:00 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-10-11 10:47:00 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-10-11 10:47:00 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-10-11 10:47:00 destination > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2022-10-11 10:47:00 destination > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] 2022-10-11 10:47:00 source > Starting syncing SourceAmazonSellerPartner 2022-10-11 10:47:00 destination > 2022-10-11 10:47:00 INFO i.a.i.d.m.MySQLDestination(main):136 - starting destination: class io.airbyte.integrations.destination.mysql.MySQLDestination 2022-10-11 10:47:00 destination > 2022-10-11 10:47:00 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {catalog=destination_catalog.json, write=null, config=destination_config.json} 2022-10-11 10:47:00 destination > 2022-10-11 10:47:00 INFO i.a.i.b.IntegrationRunner(runInternal):123 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-10-11 10:47:00 destination > 2022-10-11 10:47:00 INFO i.a.i.b.IntegrationRunner(runInternal):124 - Command: WRITE 2022-10-11 10:47:00 destination > 2022-10-11 10:47:00 INFO i.a.i.b.IntegrationRunner(runInternal):125 - Integration config: IntegrationConfig{command=WRITE, configPath='destination_config.json', catalogPath='destination_catalog.json', statePath='null'} 2022-10-11 10:47:00 source > Syncing stream: GET_MERCHANT_LISTINGS_ALL_DATA 2022-10-11 10:47:00 destination > 2022-10-11 10:47:00 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-10-11 10:47:00 destination > 2022-10-11 10:47:00 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-10-11 10:47:00 destination > 2022-10-11 10:47:00 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-10-11 10:47:00 destination > 2022-10-11 10:47:00 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword multiline - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword 2022-10-11 10:47:00 destination > 2022-10-11 10:47:00 INFO i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL 2022-10-11 10:47:00 destination > 2022-10-11 10:47:00 INFO c.z.h.HikariDataSource():80 - HikariPool-1 - Starting... 2022-10-11 10:47:00 destination > 2022-10-11 10:47:00 INFO c.z.h.HikariDataSource():82 - HikariPool-1 - Start completed. 2022-10-11 10:47:00 destination > 2022-10-11 10:47:00 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):98 - Write config: WriteConfig{streamName=GET_MERCHANT_LISTINGS_ALL_DATA, namespace=null, outputSchemaName=mszweirad, tmpTableName=_airbyte_tmp_zbp_get___ant_listings_all_data, outputTableName=_airbyte_raw_get_merchant_listings_all_data, syncMode=append} 2022-10-11 10:47:00 destination > 2022-10-11 10:47:00 INFO i.a.i.d.b.BufferedStreamConsumer(startTracked):116 - class io.airbyte.integrations.destination.buffered_stream_consumer.BufferedStreamConsumer started. 2022-10-11 10:47:00 destination > 2022-10-11 10:47:00 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):123 - Preparing tmp tables in destination started for 1 streams 2022-10-11 10:47:00 destination > 2022-10-11 10:47:00 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):127 - Preparing tmp table in destination started for stream GET_MERCHANT_LISTINGS_ALL_DATA. schema: mszweirad, tmp table name: _airbyte_tmp_zbp_get___ant_listings_all_data 2022-10-11 10:47:01 destination > 2022-10-11 10:47:01 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):133 - Preparing tables in destination completed. 2022-10-11 10:48:02 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):352 - Records read: 1000 (807 KB) 2022-10-11 10:48:02 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):352 - Records read: 2000 (1 MB) 2022-10-11 10:48:02 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):352 - Records read: 3000 (2 MB) 2022-10-11 10:48:02 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):352 - Records read: 4000 (3 MB) 2022-10-11 10:48:02 source > Read 4730 records from GET_MERCHANT_LISTINGS_ALL_DATA stream 2022-10-11 10:48:02 source > Finished syncing GET_MERCHANT_LISTINGS_ALL_DATA 2022-10-11 10:48:02 source > SourceAmazonSellerPartner runtimes: Syncing stream GET_MERCHANT_LISTINGS_ALL_DATA 0:01:02.171278 2022-10-11 10:48:02 source > Finished syncing SourceAmazonSellerPartner 2022-10-11 10:48:03 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):355 - Source has no more messages, closing connection. 2022-10-11 10:48:03 INFO i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$6):363 - Total records read: 4730 (3 MB) 2022-10-11 10:48:03 WARN i.a.w.g.DefaultReplicationWorker(lambda$getReplicationRunnable$5):366 - Schema validation errors found for stream GET_MERCHANT_LISTINGS_ALL_DATA. Error messages: [$.quantity is of an incorrect type. Expected it to be [null, number], $.pending-quantity is of an incorrect type. Expected it to be [null, number], $.price is of an incorrect type. Expected it to be [null, number]] 2022-10-11 10:48:03 INFO i.a.w.g.DefaultReplicationWorker(run):182 - One of source or destination thread complete. Waiting on the other. 2022-10-11 10:48:03 destination > 2022-10-11 10:48:03 INFO i.a.i.b.FailureTrackingAirbyteMessageConsumer(close):65 - Airbyte message consumer: succeeded. 2022-10-11 10:48:03 destination > 2022-10-11 10:48:03 INFO i.a.i.d.b.BufferedStreamConsumer(close):171 - executing on success close procedure. 2022-10-11 10:48:03 destination > 2022-10-11 10:48:03 INFO i.a.i.d.r.InMemoryRecordBufferingStrategy(lambda$flushAll$1):86 - Flushing GET_MERCHANT_LISTINGS_ALL_DATA: 4730 records (14 MB) 2022-10-11 10:48:03 destination > 2022-10-11 10:48:03 INFO i.a.i.d.j.SqlOperations(onDestinationCloseOperations):138 - No onDestinationCloseOperations required for this destination. 2022-10-11 10:48:03 destination > 2022-10-11 10:48:03 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):163 - Finalizing tables in destination started for 1 streams 2022-10-11 10:48:03 destination > 2022-10-11 10:48:03 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):168 - Finalizing stream GET_MERCHANT_LISTINGS_ALL_DATA. schema mszweirad, tmp table _airbyte_tmp_zbp_get___ant_listings_all_data, final table _airbyte_raw_get_merchant_listings_all_data 2022-10-11 10:48:03 destination > 2022-10-11 10:48:03 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):181 - Executing finalization of tables. 2022-10-11 10:48:04 destination > 2022-10-11 10:48:04 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):183 - Finalizing tables in destination completed. 2022-10-11 10:48:04 destination > 2022-10-11 10:48:04 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):186 - Cleaning tmp tables in destination started for 1 streams 2022-10-11 10:48:04 destination > 2022-10-11 10:48:04 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):190 - Cleaning tmp table in destination started for stream GET_MERCHANT_LISTINGS_ALL_DATA. schema mszweirad, tmp table name: _airbyte_tmp_zbp_get___ant_listings_all_data 2022-10-11 10:48:04 destination > 2022-10-11 10:48:04 INFO i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):195 - Cleaning tmp tables in destination completed. 2022-10-11 10:48:04 destination > 2022-10-11 10:48:04 INFO i.a.i.b.IntegrationRunner(runInternal):171 - Completed integration: io.airbyte.integrations.base.ssh.SshWrappedDestination 2022-10-11 10:48:04 destination > 2022-10-11 10:48:04 INFO i.a.i.d.m.MySQLDestination(main):138 - completed destination: class io.airbyte.integrations.destination.mysql.MySQLDestination 2022-10-11 10:48:04 INFO i.a.w.g.DefaultReplicationWorker(run):184 - Source and destination threads complete. 2022-10-11 10:48:04 INFO i.a.w.g.DefaultReplicationWorker(run):281 - Source did not output any state messages 2022-10-11 10:48:04 WARN i.a.w.g.DefaultReplicationWorker(run):289 - State capture: No new state, falling back on input state: io.airbyte.config.State@2401169c[state={}] 2022-10-11 10:48:04 INFO i.a.w.g.DefaultReplicationWorker(run):300 - sync summary: { "status" : "completed", "recordsSynced" : 4730, "bytesSynced" : 3861687, "startTime" : 1665485219603, "endTime" : 1665485284279, "totalStats" : { "recordsEmitted" : 4730, "bytesEmitted" : 3861687, "sourceStateMessagesEmitted" : 0, "destinationStateMessagesEmitted" : 0, "recordsCommitted" : 4730, "meanSecondsBeforeSourceStateMessageEmitted" : 0, "maxSecondsBeforeSourceStateMessageEmitted" : 0, "maxSecondsBetweenStateMessageEmittedandCommitted" : 0, "meanSecondsBetweenStateMessageEmittedandCommitted" : 0 }, "streamStats" : [ { "streamName" : "GET_MERCHANT_LISTINGS_ALL_DATA", "stats" : { "recordsEmitted" : 4730, "bytesEmitted" : 3861687, "recordsCommitted" : 4730 } } ] } 2022-10-11 10:48:04 INFO i.a.w.g.DefaultReplicationWorker(run):301 - failures: [ ] 2022-10-11 10:48:04 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-10-11 10:48:04 INFO i.a.w.t.s.ReplicationActivityImpl(lambda$replicate$3):157 - sync summary: io.airbyte.config.StandardSyncOutput@6aba8965[standardSyncSummary=io.airbyte.config.StandardSyncSummary@2fb80a56[status=completed,recordsSynced=4730,bytesSynced=3861687,startTime=1665485219603,endTime=1665485284279,totalStats=io.airbyte.config.SyncStats@581d17fe[recordsEmitted=4730,bytesEmitted=3861687,sourceStateMessagesEmitted=0,destinationStateMessagesEmitted=0,recordsCommitted=4730,meanSecondsBeforeSourceStateMessageEmitted=0,maxSecondsBeforeSourceStateMessageEmitted=0,maxSecondsBetweenStateMessageEmittedandCommitted=0,meanSecondsBetweenStateMessageEmittedandCommitted=0,additionalProperties={}],streamStats=[io.airbyte.config.StreamSyncStats@1edde2f8[streamName=GET_MERCHANT_LISTINGS_ALL_DATA,stats=io.airbyte.config.SyncStats@2092a1e7[recordsEmitted=4730,bytesEmitted=3861687,sourceStateMessagesEmitted=,destinationStateMessagesEmitted=,recordsCommitted=4730,meanSecondsBeforeSourceStateMessageEmitted=,maxSecondsBeforeSourceStateMessageEmitted=,maxSecondsBetweenStateMessageEmittedandCommitted=,meanSecondsBetweenStateMessageEmittedandCommitted=,additionalProperties={}]]]],normalizationSummary=,state=io.airbyte.config.State@2401169c[state={}],outputCatalog=io.airbyte.protocol.models.ConfiguredAirbyteCatalog@4f97f519[streams=[io.airbyte.protocol.models.ConfiguredAirbyteStream@7f05a9f2[stream=io.airbyte.protocol.models.AirbyteStream@ebe5ec8[name=GET_MERCHANT_LISTINGS_ALL_DATA,jsonSchema={"type":"object","title":"Get Merchant Listings Reports","$schema":"http://json-schema.org/draft-07/schema#","properties":{"asin1":{"type":["null","string"]},"asin2":{"type":["null","string"]},"asin3":{"type":["null","string"]},"price":{"type":["null","number"]},"status":{"type":["null","string"]},"quantity":{"type":["null","number"]},"image-url":{"type":["null","string"]},"item-name":{"type":["null","string"]},"item-note":{"type":["null","string"]},"open-date":{"type":["null","string"]},"add-delete":{"type":["null","string"]},"listing-id":{"type":["null","string"]},"product-id":{"type":["null","string"]},"seller-sku":{"type":["null","string"]},"item-condition":{"type":["null","string"]},"zshop-boldface":{"type":["null","string"]},"product-id-type":{"type":["null","string"]},"zshop-category1":{"type":["null","string"]},"item-description":{"type":["null","string"]},"pending-quantity":{"type":["null","number"]},"zshop-browse-path":{"type":["null","string"]},"expedited-shipping":{"type":["null","string"]},"zshop-shipping-fee":{"type":["null","string"]},"fulfillment-channel":{"type":["null","string"]},"item-is-marketplace":{"type":["null","string"]},"merchant-shipping-group":{"type":["null","string"]},"zshop-storefront-feature":{"type":["null","string"]},"will-ship-internationally":{"type":["null","string"]},"bid-for-featured-placement":{"type":["null","string"]}},"description":"Get Merchant Listings All Data Reports"},supportedSyncModes=[full_refresh],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[],namespace=,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=append,primaryKey=[],additionalProperties={}]],additionalProperties={}],failures=[]] 2022-10-11 10:48:04 INFO i.a.w.t.s.ReplicationActivityImpl(lambda$replicate$3):162 - Sync summary length: 3179 2022-10-11 10:48:04 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:48:04 INFO i.a.c.t.TemporalUtils(withBackgroundHeartbeat):280 - Stopping temporal heartbeating... 2022-10-11 10:48:04 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END REPLICATION ----- 2022-10-11 10:48:04 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:48:04 INFO i.a.c.f.EnvVariableFeatureFlags(getEnvOrDefault):50 - Using default value for environment variable NEED_STATE_VALIDATION: 'true' 2022-10-11 10:48:04 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/167/2/logs.log 2022-10-11 10:48:04 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.40.12 2022-10-11 10:48:04 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:48:04 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START DEFAULT NORMALIZATION ----- 2022-10-11 10:48:04 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:48:04 INFO i.a.w.n.DefaultNormalizationRunner(runProcess):134 - Running with normalization version: airbyte/normalization-mysql:0.2.22 2022-10-11 10:48:04 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/normalization-mysql:0.2.22 exists... 2022-10-11 10:48:04 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/normalization-mysql:0.2.22 was found locally. 2022-10-11 10:48:04 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = normalization-mysql-normalize-167-2-fyavh with resources io.airbyte.config.ResourceRequirements@301bbaa2[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] 2022-10-11 10:48:04 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/167/2/normalize --log-driver none --name normalization-mysql-normalize-167-2-fyavh --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_VERSION=0.40.12 airbyte/normalization-mysql:0.2.22 run --integration-type mysql --config destination_config.json --catalog destination_catalog.json 2022-10-11 10:48:04 normalization > Running: transform-config --config destination_config.json --integration-type mysql --out /data/167/2/normalize 2022-10-11 10:48:05 normalization > Namespace(config='destination_config.json', integration_type=, out='/data/167/2/normalize') 2022-10-11 10:48:05 normalization > transform_mysql 2022-10-11 10:48:05 normalization > Running: transform-catalog --integration-type mysql --profile-config-dir /data/167/2/normalize --catalog destination_catalog.json --out /data/167/2/normalize/models/generated/ --json-column _airbyte_data 2022-10-11 10:48:05 normalization > Processing destination_catalog.json... 2022-10-11 10:48:05 normalization > Generating airbyte_ctes/mszweirad/get_merchant_listings_all_data_ab1.sql from GET_MERCHANT_LISTINGS_ALL_DATA 2022-10-11 10:48:05 normalization > Generating airbyte_ctes/mszweirad/get_merchant_listings_all_data_ab2.sql from GET_MERCHANT_LISTINGS_ALL_DATA 2022-10-11 10:48:05 normalization > Truncating _airbyte_get_merchant_listings_all_data_hashid (#46) to _airbyte_get_merchant_tings_all_data_hashid (#44) 2022-10-11 10:48:05 normalization > Generating airbyte_ctes/mszweirad/get_merchant_listings_all_data_ab3.sql from GET_MERCHANT_LISTINGS_ALL_DATA 2022-10-11 10:48:05 normalization > Truncating _airbyte_get_merchant_listings_all_data_hashid (#46) to _airbyte_get_merchant_tings_all_data_hashid (#44) 2022-10-11 10:48:05 normalization > Generating airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql from GET_MERCHANT_LISTINGS_ALL_DATA 2022-10-11 10:48:05 normalization > detected no config file for ssh, assuming ssh is off. 2022-10-11 10:48:06 normalization > [--event-buffer-size EVENT_BUFFER_SIZE] 2022-10-11 10:48:06 normalization > --event-buffer-size EVENT_BUFFER_SIZE 2022-10-11 10:48:06 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:48:06 normalization > DBT >=1.0.0 detected; using 10K event buffer size 2022-10-11 10:48:06 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:48:08 normalization > Running with dbt=1.0.0 2022-10-11 10:48:08 normalization > Partial parse save file not found. Starting full parse. 2022-10-11 10:48:09 normalization > [WARNING]: Configuration paths exist in your dbt_project.yml file which do not apply to any resources. There are 2 unused configuration paths: - models.airbyte_utils.generated.airbyte_tables - models.airbyte_utils.generated.airbyte_views 2022-10-11 10:48:09 normalization > Found 4 models, 0 tests, 0 snapshots, 0 analyses, 584 macros, 0 operations, 0 seed files, 1 source, 0 exposures, 0 metrics 2022-10-11 10:48:09 normalization > Concurrency: 1 threads (target='prod') 2022-10-11 10:48:09 normalization > 1 of 1 START table model mszweirad.get_merchant_listings_all_data....................................................... [RUN] 2022-10-11 10:48:09 normalization > 1 of 1 ERROR creating table model mszweirad.get_merchant_listings_all_data.............................................. [ERROR in 0.11s] 2022-10-11 10:48:09 normalization > Finished running 1 table model in 0.31s. 2022-10-11 10:48:09 normalization > Completed with 1 error and 0 warnings: 2022-10-11 10:48:09 normalization > Database Error in model get_merchant_listings_all_data (models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql) 2022-10-11 10:48:09 normalization > 1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders' 2022-10-11 10:48:09 normalization > compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql 2022-10-11 10:48:09 normalization > Done. PASS=0 WARN=0 ERROR=1 SKIP=0 TOTAL=1 2022-10-11 10:48:09 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:48:09 normalization > Diagnosing dbt debug to check if destination is available for dbt and well configured (1): 2022-10-11 10:48:09 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:48:11 normalization > 10:48:11 Running with dbt=1.0.0 2022-10-11 10:48:11 normalization > dbt version: 1.0.0 2022-10-11 10:48:11 normalization > python version: 3.9.9 2022-10-11 10:48:11 normalization > python path: /usr/local/bin/python 2022-10-11 10:48:11 normalization > os info: Linux-5.10.16.3-microsoft-standard-WSL2-x86_64-with-glibc2.31 2022-10-11 10:48:11 normalization > Using profiles.yml file at /data/167/2/normalize/profiles.yml 2022-10-11 10:48:11 normalization > Using dbt_project.yml file at /data/167/2/normalize/dbt_project.yml 2022-10-11 10:48:11 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:48:11 normalization > Configuration: 2022-10-11 10:48:11 normalization > profiles.yml file [OK found and valid] 2022-10-11 10:48:11 normalization > dbt_project.yml file [OK found and valid] 2022-10-11 10:48:11 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:48:11 normalization > Required dependencies: 2022-10-11 10:48:11 normalization > - git [OK found] 2022-10-11 10:48:11 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:48:11 normalization > Connection: 2022-10-11 10:48:11 normalization > server: localhost 2022-10-11 10:48:11 normalization > port: 3308 2022-10-11 10:48:11 normalization > database: None 2022-10-11 10:48:11 normalization > schema: mszweirad 2022-10-11 10:48:11 normalization > user: root 2022-10-11 10:48:11 normalization > Connection test: [OK connection ok] 2022-10-11 10:48:11 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:48:11 normalization > All checks passed! 2022-10-11 10:48:11 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:48:11 normalization > Forward dbt output logs to diagnose/debug errors (0): 2022-10-11 10:48:11 INFO i.a.w.n.NormalizationAirbyteStreamFactory(filterOutAndHandleNonAirbyteMessageLines):104 - 2022-10-11 10:48:11 normalization > Running with dbt=1.0.0 2022-10-11 10:48:11 normalization > Partial parse save file not found. Starting full parse. 2022-10-11 10:48:11 normalization > [WARNING]: Configuration paths exist in your dbt_project.yml file which do not apply to any resources. There are 2 unused configuration paths: - models.airbyte_utils.generated.airbyte_tables - models.airbyte_utils.generated.airbyte_views 2022-10-11 10:48:11 normalization > Found 4 models, 0 tests, 0 snapshots, 0 analyses, 584 macros, 0 operations, 0 seed files, 1 source, 0 exposures, 0 metrics 2022-10-11 10:48:11 normalization > Concurrency: 1 threads (target='prod') 2022-10-11 10:48:11 normalization > 1 of 1 START table model mszweirad.get_merchant_listings_all_data....................................................... [RUN] 2022-10-11 10:48:11 normalization > 1 of 1 ERROR creating table model mszweirad.get_merchant_listings_all_data.............................................. [ERROR in 0.11s] 2022-10-11 10:48:11 normalization > Finished running 1 table model in 0.31s. 2022-10-11 10:48:11 normalization > Completed with 1 error and 0 warnings: 2022-10-11 10:48:11 normalization > Database Error in model get_merchant_listings_all_data (models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql) 2022-10-11 10:48:11 normalization > 1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders' 2022-10-11 10:48:11 normalization > compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql 2022-10-11 10:48:11 normalization > Done. PASS=0 WARN=0 ERROR=1 SKIP=0 TOTAL=1 2022-10-11 10:48:11 INFO i.a.w.g.DefaultNormalizationWorker(run):82 - Normalization executed in 6 seconds. 2022-10-11 10:48:11 ERROR i.a.w.g.DefaultNormalizationWorker(run):90 - Normalization Failed. 2022-10-11 10:48:11 INFO i.a.w.g.DefaultNormalizationWorker(run):95 - Normalization summary: io.airbyte.config.NormalizationSummary@161ee1c[startTime=1665485284454,endTime=1665485291291,failures=[io.airbyte.config.FailureReason@3d172647[failureOrigin=normalization,failureType=system_error,internalMessage=1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders',externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@503445ed[additionalProperties={attemptNumber=2, jobId=167, from_trace_message=true}],stacktrace=AirbyteDbtError: 1 of 1 ERROR creating table model mszweirad.get_merchant_listings_all_data.............................................. [ERROR in 0.11s] Database Error in model get_merchant_listings_all_data (models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql) 1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders' compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql 1 of 1 ERROR creating table model mszweirad.get_merchant_listings_all_data.............................................. [ERROR in 0.11s] Database Error in model get_merchant_listings_all_data (models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql) 1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders' compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql,retryable=,timestamp=1665485291290], io.airbyte.config.FailureReason@2c2dfee2[failureOrigin=normalization,failureType=system_error,internalMessage=1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders',externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@22b2e475[additionalProperties={attemptNumber=2, jobId=167, from_trace_message=true}],stacktrace=AirbyteDbtError: 1 of 1 ERROR creating table model mszweirad.get_merchant_listings_all_data.............................................. [ERROR in 0.11s] Database Error in model get_merchant_listings_all_data (models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql) 1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders' compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql 1 of 1 ERROR creating table model mszweirad.get_merchant_listings_all_data.............................................. [ERROR in 0.11s] Database Error in model get_merchant_listings_all_data (models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql) 1292 (22007): Truncated incorrect CHAR(1050) value: 'Der Ständer wird aufgrund seiner standfesten Spreizung besonders für E-Räder, Transporträder, Tandems und Räder mit Kinders' compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/mszweirad/get_merchant_listings_all_data.sql,retryable=,timestamp=1665485291290]]] 2022-10-11 10:48:11 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling... 2022-10-11 10:48:11 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:48:11 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END DEFAULT NORMALIZATION ----- 2022-10-11 10:48:11 INFO i.a.c.i.LineGobbler(voidCall):114 - 2022-10-11 10:48:11 INFO i.a.c.t.TemporalUtils(withBackgroundHeartbeat):280 - Stopping temporal heartbeating...