## Environment
Airbyte Version: 0.35.65-alpha
Source: Jira (0.2.18)
Destination:… MySQL (0.1.18)
* **Severity**: Low
* **Step where error happened**: Sync job
## Current Behavior
I created a connection between Jira and MySQL.
I tried with all tables from Jira and I receive this error: io.airbyte.workers.WorkerException: Normalization Failed.
I tried again with one table "users" and receive the same error.
## Logs
<details>
<summary>LOG</summary>
2022-04-08 22:29:14 [32mINFO[m i.a.w.w.WorkerRun(call):49 - Executing worker wrapper. Airbyte version: 0.35.65-alpha
2022-04-08 22:29:14 [32mINFO[m i.a.w.t.TemporalAttemptExecution(get):105 - Docker volume job log path: /tmp/workspace/22/2/logs.log
2022-04-08 22:29:14 [32mINFO[m i.a.w.t.TemporalAttemptExecution(get):110 - Executing worker wrapper. Airbyte version: 0.35.65-alpha
2022-04-08 22:29:14 [32mINFO[m i.a.w.DefaultReplicationWorker(run):104 - start sync worker. job id: 22 attempt id: 2
2022-04-08 22:29:14 [32mINFO[m i.a.w.DefaultReplicationWorker(run):116 - configured sync modes: {null.users=full_refresh - overwrite}
2022-04-08 22:29:14 [32mINFO[m i.a.w.p.a.DefaultAirbyteDestination(start):69 - Running destination...
2022-04-08 22:29:14 [32mINFO[m i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/destination-mysql:0.1.18 exists...
2022-04-08 22:29:14 [32mINFO[m i.a.c.i.LineGobbler(voidCall):82 - airbyte/destination-mysql:0.1.18 was found locally.
2022-04-08 22:29:14 [32mINFO[m i.a.w.p.DockerProcessFactory(create):106 - Creating docker job ID: 22
2022-04-08 22:29:14 [32mINFO[m i.a.w.p.DockerProcessFactory(create):158 - Preparing command: docker run --rm --init -i -w /data/22/2 --log-driver none --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e WORKER_CONNECTOR_IMAGE=airbyte/destination-mysql:0.1.18 -e WORKER_JOB_ATTEMPT=2 -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e AIRBYTE_VERSION=0.35.65-alpha -e WORKER_JOB_ID=22 airbyte/destination-mysql:0.1.18 write --config destination_config.json --catalog destination_catalog.json
2022-04-08 22:29:14 [32mINFO[m i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/source-jira:0.2.18 exists...
2022-04-08 22:29:14 [32mINFO[m i.a.c.i.LineGobbler(voidCall):82 - airbyte/source-jira:0.2.18 was found locally.
2022-04-08 22:29:14 [32mINFO[m i.a.w.p.DockerProcessFactory(create):106 - Creating docker job ID: 22
2022-04-08 22:29:14 [32mINFO[m i.a.w.p.DockerProcessFactory(create):158 - Preparing command: docker run --rm --init -i -w /data/22/2 --log-driver none --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e WORKER_CONNECTOR_IMAGE=airbyte/source-jira:0.2.18 -e WORKER_JOB_ATTEMPT=2 -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e AIRBYTE_VERSION=0.35.65-alpha -e WORKER_JOB_ID=22 airbyte/source-jira:0.2.18 read --config source_config.json --catalog source_catalog.json --state input_state.json
2022-04-08 22:29:14 [32mINFO[m i.a.w.DefaultReplicationWorker(run):158 - Waiting for source and destination threads to complete.
2022-04-08 22:29:14 [32mINFO[m i.a.w.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$6):339 - Destination output thread started.
2022-04-08 22:29:14 [32mINFO[m i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):279 - Replication thread started.
2022-04-08 22:29:15 [43mdestination[0m > SLF4J: Class path contains multiple SLF4J bindings.
2022-04-08 22:29:15 [43mdestination[0m > SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
2022-04-08 22:29:15 [43mdestination[0m > SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
2022-04-08 22:29:15 [43mdestination[0m > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
2022-04-08 22:29:15 [43mdestination[0m > SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
2022-04-08 22:29:15 [44msource[0m > Starting syncing SourceJira
2022-04-08 22:29:15 [44msource[0m > Syncing stream: users
2022-04-08 22:29:16 [43mdestination[0m > 2022-04-08 22:29:16 [32mINFO[m i.a.i.d.m.MySQLDestination(main):125 - starting destination: class io.airbyte.integrations.destination.mysql.MySQLDestination
2022-04-08 22:29:16 [43mdestination[0m > 2022-04-08 22:29:16 [32mINFO[m i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {catalog=destination_catalog.json, write=null, config=destination_config.json}
2022-04-08 22:29:16 [43mdestination[0m > 2022-04-08 22:29:16 [32mINFO[m i.a.i.b.IntegrationRunner(run):88 - Sentry transaction event: 0cf1e79dc07f471cbb59080fec00f5c1
2022-04-08 22:29:16 [43mdestination[0m > 2022-04-08 22:29:16 [32mINFO[m i.a.i.b.IntegrationRunner(runInternal):106 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination
2022-04-08 22:29:16 [43mdestination[0m > 2022-04-08 22:29:16 [32mINFO[m i.a.i.b.IntegrationRunner(runInternal):107 - Command: WRITE
2022-04-08 22:29:16 [43mdestination[0m > 2022-04-08 22:29:16 [32mINFO[m i.a.i.b.IntegrationRunner(runInternal):108 - Integration config: IntegrationConfig{command=WRITE, configPath='destination_config.json', catalogPath='destination_catalog.json', statePath='null'}
2022-04-08 22:29:16 [43mdestination[0m > 2022-04-08 22:29:16 [33mWARN[m 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-04-08 22:29:16 [43mdestination[0m > 2022-04-08 22:29:16 [33mWARN[m 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-04-08 22:29:16 [43mdestination[0m > 2022-04-08 22:29:16 [33mWARN[m 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-04-08 22:29:16 [43mdestination[0m > 2022-04-08 22:29:16 [33mWARN[m 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-04-08 22:29:16 [44msource[0m > Read 50 records from users stream
2022-04-08 22:29:16 [44msource[0m > Finished syncing SourceJira
2022-04-08 22:29:16 [44msource[0m > SourceJira runtimes:
2022-04-08 22:29:16 [44msource[0m > Finished syncing SourceJira
2022-04-08 22:29:16 [43mdestination[0m > 2022-04-08 22:29:16 [32mINFO[m i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL
2022-04-08 22:29:16 [43mdestination[0m > 2022-04-08 22:29:16 [32mINFO[m i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$toWriteConfig$0):96 - Write config: WriteConfig{streamName=users, namespace=null, outputSchemaName=reports, tmpTableName=_airbyte_tmp_jqh_users, outputTableName=_airbyte_raw_users, syncMode=overwrite}
2022-04-08 22:29:16 [32mINFO[m i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):305 - Total records read: 50 (45 KB)
2022-04-08 22:29:16 [32mINFO[m i.a.w.DefaultReplicationWorker(run):163 - One of source or destination thread complete. Waiting on the other.
2022-04-08 22:29:16 [43mdestination[0m > 2022-04-08 22:29:16 [32mINFO[m i.a.i.d.b.BufferedStreamConsumer(startTracked):141 - class io.airbyte.integrations.destination.buffered_stream_consumer.BufferedStreamConsumer started.
2022-04-08 22:29:16 [43mdestination[0m > 2022-04-08 22:29:16 [32mINFO[m i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):121 - Preparing tmp tables in destination started for 1 streams
2022-04-08 22:29:16 [43mdestination[0m > 2022-04-08 22:29:16 [32mINFO[m i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):125 - Preparing tmp table in destination started for stream users. schema: reports, tmp table name: _airbyte_tmp_jqh_users
2022-04-08 22:29:17 [43mdestination[0m > 2022-04-08 22:29:17 [32mINFO[m i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onStartFunction$1):131 - Preparing tables in destination completed.
2022-04-08 22:29:17 [43mdestination[0m > 2022-04-08 22:29:17 [32mINFO[m i.a.i.b.FailureTrackingAirbyteMessageConsumer(close):65 - Airbyte message consumer: succeeded.
2022-04-08 22:29:17 [43mdestination[0m > 2022-04-08 22:29:17 [32mINFO[m i.a.i.d.b.BufferedStreamConsumer(close):217 - executing on success close procedure.
2022-04-08 22:29:17 [43mdestination[0m > 2022-04-08 22:29:17 [32mINFO[m i.a.i.d.b.BufferedStreamConsumer(flushQueueToDestination):181 - Flushing buffer: 172970 bytes
2022-04-08 22:29:17 [43mdestination[0m > 2022-04-08 22:29:17 [32mINFO[m i.a.i.d.b.BufferedStreamConsumer(lambda$flushQueueToDestination$1):185 - Flushing users: 50 records
2022-04-08 22:29:17 [43mdestination[0m > 2022-04-08 22:29:17 [32mINFO[m i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):160 - Finalizing tables in destination started for 1 streams
2022-04-08 22:29:17 [43mdestination[0m > 2022-04-08 22:29:17 [32mINFO[m i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):165 - Finalizing stream users. schema reports, tmp table _airbyte_tmp_jqh_users, final table _airbyte_raw_users
2022-04-08 22:29:17 [43mdestination[0m > 2022-04-08 22:29:17 [32mINFO[m i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):178 - Executing finalization of tables.
2022-04-08 22:29:17 [43mdestination[0m > 2022-04-08 22:29:17 [32mINFO[m i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):180 - Finalizing tables in destination completed.
2022-04-08 22:29:17 [43mdestination[0m > 2022-04-08 22:29:17 [32mINFO[m i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):183 - Cleaning tmp tables in destination started for 1 streams
2022-04-08 22:29:17 [43mdestination[0m > 2022-04-08 22:29:17 [32mINFO[m i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):187 - Cleaning tmp table in destination started for stream users. schema reports, tmp table name: _airbyte_tmp_jqh_users
2022-04-08 22:29:17 [43mdestination[0m > 2022-04-08 22:29:17 [32mINFO[m i.a.i.d.j.JdbcBufferedConsumerFactory(lambda$onCloseFunction$3):192 - Cleaning tmp tables in destination completed.
2022-04-08 22:29:17 [43mdestination[0m > 2022-04-08 22:29:17 [32mINFO[m i.a.i.b.IntegrationRunner(runInternal):154 - Completed integration: io.airbyte.integrations.base.ssh.SshWrappedDestination
2022-04-08 22:29:17 [43mdestination[0m > 2022-04-08 22:29:17 [32mINFO[m i.a.i.d.m.MySQLDestination(main):127 - completed destination: class io.airbyte.integrations.destination.mysql.MySQLDestination
2022-04-08 22:29:17 [32mINFO[m i.a.w.DefaultReplicationWorker(run):165 - Source and destination threads complete.
2022-04-08 22:29:17 [32mINFO[m i.a.w.DefaultReplicationWorker(run):228 - sync summary: io.airbyte.config.ReplicationAttemptSummary@6d6e7810[status=completed,recordsSynced=50,bytesSynced=46334,startTime=1649456954720,endTime=1649456957376,totalStats=io.airbyte.config.SyncStats@3ca962b9[recordsEmitted=50,bytesEmitted=46334,stateMessagesEmitted=0,recordsCommitted=50],streamStats=[io.airbyte.config.StreamSyncStats@599c05e2[streamName=users,stats=io.airbyte.config.SyncStats@181bb9f5[recordsEmitted=50,bytesEmitted=46334,stateMessagesEmitted=<null>,recordsCommitted=50]]]]
2022-04-08 22:29:17 [32mINFO[m i.a.w.DefaultReplicationWorker(run):250 - Source did not output any state messages
2022-04-08 22:29:17 [33mWARN[m i.a.w.DefaultReplicationWorker(run):258 - State capture: No new state, falling back on input state: io.airbyte.config.State@62bec1e[state={}]
2022-04-08 22:29:17 [32mINFO[m i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling...
2022-04-08 22:29:17 [32mINFO[m i.a.w.t.s.ReplicationActivityImpl(lambda$replicate$1):147 - sync summary: io.airbyte.config.StandardSyncOutput@1236191b[standardSyncSummary=io.airbyte.config.StandardSyncSummary@108af1d8[status=completed,recordsSynced=50,bytesSynced=46334,startTime=1649456954720,endTime=1649456957376,totalStats=io.airbyte.config.SyncStats@3ca962b9[recordsEmitted=50,bytesEmitted=46334,stateMessagesEmitted=0,recordsCommitted=50],streamStats=[io.airbyte.config.StreamSyncStats@599c05e2[streamName=users,stats=io.airbyte.config.SyncStats@181bb9f5[recordsEmitted=50,bytesEmitted=46334,stateMessagesEmitted=<null>,recordsCommitted=50]]]],state=io.airbyte.config.State@62bec1e[state={}],outputCatalog=io.airbyte.protocol.models.ConfiguredAirbyteCatalog@6ab7e01f[streams=[io.airbyte.protocol.models.ConfiguredAirbyteStream@41cea925[stream=io.airbyte.protocol.models.AirbyteStream@63928ec6[name=users,jsonSchema={"xml":{"name":"user"},"type":"object","$schema":"http://json-schema.org/draft-07/schema#","properties":{"key":{"type":"string","description":"This property is no longer available and will be removed from the documentation soon. See the [deprecation notice](https://developer.atlassian.com/cloud/jira/platform/deprecation-notice-user-privacy-api-migration-guide/) for details."},"name":{"type":"string","description":"This property is no longer available and will be removed from the documentation soon. See the [deprecation notice](https://developer.atlassian.com/cloud/jira/platform/deprecation-notice-user-privacy-api-migration-guide/) for details."},"self":{"type":"string","format":"uri","readOnly":true,"description":"The URL of the user."},"active":{"type":"boolean","readOnly":true,"description":"Whether the user is active."},"expand":{"xml":{"attribute":true},"type":"string","readOnly":true,"description":"Expand options that include additional user details in the response."},"groups":{"type":"object","readOnly":true,"properties":{"size":{"xml":{"attribute":true},"type":"integer","format":"int32"},"items":{"type":"array","items":{"type":"object","properties":{"name":{"type":"string","description":"The name of group."},"self":{"type":"string","format":"uri","readOnly":true,"description":"The URL for these group details."}}}},"callback":{"type":"object"},"max-results":{"xml":{"name":"max-results","attribute":true},"type":"integer","format":"int32"},"pagingCallback":{"type":"object"}},"description":"The groups that the user belongs to."},"locale":{"type":"string","readOnly":true,"description":"The locale of the user. Depending on the user’s privacy setting, this may be returned as null."},"timeZone":{"type":"string","readOnly":true,"description":"The time zone specified in the user's profile. Depending on the user’s privacy setting, this may be returned as null."},"accountId":{"type":"string","maxLength":128,"description":"The account ID of the user, which uniquely identifies the user across all Atlassian products. For example, *5b10ac8d82e05b22cc7d4ef5*. Required in requests."},"avatarUrls":{"type":"object","readOnly":true,"properties":{"16x16":{"type":"string","format":"uri","description":"The URL of the item's 16x16 pixel avatar."},"24x24":{"type":"string","format":"uri","description":"The URL of the item's 24x24 pixel avatar."},"32x32":{"type":"string","format":"uri","description":"The URL of the item's 32x32 pixel avatar."},"48x48":{"type":"string","format":"uri","description":"The URL of the item's 48x48 pixel avatar."}},"description":"The avatars of the user."},"accountType":{"enum":["atlassian","app","customer","unknown"],"type":"string","readOnly":true,"description":"The user account type. Can take the following values:\n\n * `atlassian` regular Atlassian user account\n * `app` system account used for Connect applications and OAuth to represent external systems\n * `customer` Jira Service Desk account representing an external service desk"},"displayName":{"type":"string","readOnly":true,"description":"The display name of the user. Depending on the user’s privacy setting, this may return an alternative value."},"emailAddress":{"type":"string","readOnly":true,"description":"The email address of the user. Depending on the user’s privacy setting, this may be returned as null."},"applicationRoles":{"type":"object","readOnly":true,"properties":{"size":{"xml":{"attribute":true},"type":"integer","format":"int32"},"items":{"type":"array","items":{"type":"object","properties":{"key":{"type":"string","description":"The key of the application role."},"name":{"type":"string","description":"The display name of the application role."},"groups":{"type":"array","items":{"type":"string"},"description":"The groups associated with the application role.","uniqueItems":true},"defined":{"type":"boolean","description":"Deprecated."},"platform":{"type":"boolean","description":"Indicates if the application role belongs to Jira platform (`jira-core`)."},"userCount":{"type":"integer","format":"int32","description":"The number of users counting against your license."},"defaultGroups":{"type":"array","items":{"type":"string"},"description":"The groups that are granted default access for this application role.","uniqueItems":true},"numberOfSeats":{"type":"integer","format":"int32","description":"The maximum count of users on your license."},"remainingSeats":{"type":"integer","format":"int32","description":"The count of users remaining on your license."},"hasUnlimitedSeats":{"type":"boolean"},"selectedByDefault":{"type":"boolean","description":"Determines whether this application role should be selected by default on user creation."},"userCountDescription":{"type":"string","description":"The [type of users](https://confluence.atlassian.com/x/lRW3Ng) being counted against your license."}}}},"callback":{"type":"object"},"max-results":{"xml":{"name":"max-results","attribute":true},"type":"integer","format":"int32"},"pagingCallback":{"type":"object"}},"description":"The application roles the user is assigned to."}},"description":"A user with details as permitted by the user's Atlassian Account privacy settings. However, be aware of these exceptions:\n\n * User record deleted from Atlassian: This occurs as the result of a right to be forgotten request. In this case, `displayName` provides an indication and other parameters have default values or are blank (for example, email is blank).\n * User record corrupted: This occurs as a results of events such as a server import and can only happen to deleted users. In this case, `accountId` returns *unknown* and all other parameters have fallback values.\n * User record unavailable: This usually occurs due to an internal service outage. In this case, all parameters have fallback values.","additionalProperties":false},supportedSyncModes=[full_refresh],sourceDefinedCursor=<null>,defaultCursorField=[],sourceDefinedPrimaryKey=[],namespace=<null>,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[],additionalProperties={}]],additionalProperties={}],failures=[]]
2022-04-08 22:29:17 [32mINFO[m i.a.w.t.TemporalUtils(withBackgroundHeartbeat):235 - Stopping temporal heartbeating...
2022-04-08 22:29:17 [32mINFO[m i.a.c.p.ConfigRepository(updateConnectionState):731 - Updating connection 9d3573f7-6cfb-4657-8af9-53efe185f07a state: io.airbyte.config.State@45801442[state={}]
2022-04-08 22:29:17 [32mINFO[m i.a.w.t.TemporalAttemptExecution(get):105 - Docker volume job log path: /tmp/workspace/22/2/logs.log
2022-04-08 22:29:17 [32mINFO[m i.a.w.t.TemporalAttemptExecution(get):110 - Executing worker wrapper. Airbyte version: 0.35.65-alpha
2022-04-08 22:29:17 [32mINFO[m i.a.w.DefaultNormalizationWorker(run):46 - Running normalization.
2022-04-08 22:29:17 [32mINFO[m i.a.w.n.DefaultNormalizationRunner(runProcess):122 - Running with normalization version: airbyte/normalization-mysql:0.1.74
2022-04-08 22:29:17 [32mINFO[m i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/normalization-mysql:0.1.74 exists...
2022-04-08 22:29:17 [32mINFO[m i.a.c.i.LineGobbler(voidCall):82 - airbyte/normalization-mysql:0.1.74 was found locally.
2022-04-08 22:29:17 [32mINFO[m i.a.w.p.DockerProcessFactory(create):106 - Creating docker job ID: 22
2022-04-08 22:29:17 [32mINFO[m i.a.w.p.DockerProcessFactory(create):158 - Preparing command: docker run --rm --init -i -w /data/22/2/normalize --log-driver none --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e AIRBYTE_VERSION=0.35.65-alpha airbyte/normalization-mysql:0.1.74 run --integration-type mysql --config destination_config.json --catalog destination_catalog.json
2022-04-08 22:29:17 [42mnormalization[0m > Running: transform-config --config destination_config.json --integration-type mysql --out /data/22/2/normalize
2022-04-08 22:29:17 [42mnormalization[0m > Namespace(config='destination_config.json', integration_type=<DestinationType.mysql: 'mysql'>, out='/data/22/2/normalize')
2022-04-08 22:29:17 [42mnormalization[0m > transform_mysql
2022-04-08 22:29:17 [42mnormalization[0m > Running: transform-catalog --integration-type mysql --profile-config-dir /data/22/2/normalize --catalog destination_catalog.json --out /data/22/2/normalize/models/generated/ --json-column _airbyte_data
2022-04-08 22:29:18 [42mnormalization[0m > Processing destination_catalog.json...
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_ctes/reports/users_ab1.sql from users
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_ctes/reports/users_ab2.sql from users
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_ctes/reports/users_ab3.sql from users
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_tables/reports/users.sql from users
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_ctes/reports/users_groups_ab1.sql from users/groups
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_ctes/reports/users_groups_ab2.sql from users/groups
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_ctes/reports/users_groups_ab3.sql from users/groups
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_tables/reports/users_groups.sql from users/groups
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_ctes/reports/users_avatarurls_ab1.sql from users/avatarUrls
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_ctes/reports/users_avatarurls_ab2.sql from users/avatarUrls
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_ctes/reports/users_avatarurls_ab3.sql from users/avatarUrls
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_tables/reports/users_avatarurls.sql from users/avatarUrls
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_ctes/reports/users_applicationroles_ab1.sql from users/applicationRoles
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_ctes/reports/users_applicationroles_ab2.sql from users/applicationRoles
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_ctes/reports/users_applicationroles_ab3.sql from users/applicationRoles
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_tables/reports/users_applicationroles.sql from users/applicationRoles
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_ctes/reports/users_groups_items_ab1.sql from users/groups/items
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_ctes/reports/users_groups_items_ab2.sql from users/groups/items
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_ctes/reports/users_groups_items_ab3.sql from users/groups/items
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_tables/reports/users_groups_items.sql from users/groups/items
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_ctes/reports/users_applicationroles_items_ab1.sql from users/applicationRoles/items
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_ctes/reports/users_applicationroles_items_ab2.sql from users/applicationRoles/items
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_ctes/reports/users_applicationroles_items_ab3.sql from users/applicationRoles/items
2022-04-08 22:29:18 [42mnormalization[0m > Generating airbyte_tables/reports/users_applicationroles_items.sql from users/applicationRoles/items
2022-04-08 22:29:18 [42mnormalization[0m > Ignoring stream 'groups' from users/applicationRoles/items/groups because properties list is empty
2022-04-08 22:29:18 [42mnormalization[0m > Ignoring stream 'defaultGroups' from users/applicationRoles/items/defaultGroups because properties list is empty
2022-04-08 22:29:18 [42mnormalization[0m > detected no config file for ssh, assuming ssh is off.
2022-04-08 22:29:19 [32mINFO[m i.a.w.t.TemporalAttemptExecution(lambda$getWorkerThread$2):158 - Completing future exceptionally...
io.airbyte.workers.WorkerException: Normalization Failed.
at io.airbyte.workers.DefaultNormalizationWorker.run(DefaultNormalizationWorker.java:60) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at io.airbyte.workers.DefaultNormalizationWorker.run(DefaultNormalizationWorker.java:18) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$2(TemporalAttemptExecution.java:155) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at java.lang.Thread.run(Thread.java:833) [?:?]
Caused by: io.airbyte.workers.WorkerException: Normalization Failed.
at io.airbyte.workers.DefaultNormalizationWorker.run(DefaultNormalizationWorker.java:57) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
... 3 more
Suppressed: io.airbyte.workers.WorkerException: Normalization process wasn't successful
at io.airbyte.workers.normalization.DefaultNormalizationRunner.close(DefaultNormalizationRunner.java:160) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at io.airbyte.workers.DefaultNormalizationWorker.run(DefaultNormalizationWorker.java:45) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at io.airbyte.workers.DefaultNormalizationWorker.run(DefaultNormalizationWorker.java:18) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$2(TemporalAttemptExecution.java:155) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at java.lang.Thread.run(Thread.java:833) [?:?]
2022-04-08 22:29:19 [32mINFO[m i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling...
2022-04-08 22:29:19 [32mINFO[m i.a.w.t.TemporalUtils(withBackgroundHeartbeat):235 - Stopping temporal heartbeating...
2022-04-08 22:29:19 [33mWARN[m i.t.i.a.POJOActivityTaskHandler(activityFailureToResult):307 - Activity failure. ActivityId=044514e7-8239-3908-877f-ae05bd57b706, activityType=Normalize, attempt=1
java.lang.RuntimeException: io.temporal.serviceclient.CheckedExceptionWrapper: java.util.concurrent.ExecutionException: io.airbyte.workers.WorkerException: Normalization Failed.
at io.airbyte.workers.temporal.TemporalUtils.withBackgroundHeartbeat(TemporalUtils.java:233) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at io.airbyte.workers.temporal.sync.NormalizationActivityImpl.normalize(NormalizationActivityImpl.java:71) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]
at io.temporal.internal.activity.POJOActivityTaskHandler$POJOActivityInboundCallsInterceptor.execute(POJOActivityTaskHandler.java:214) ~[temporal-sdk-1.8.1.jar:?]
at io.temporal.internal.activity.POJOActivityTaskHandler$POJOActivityImplementation.execute(POJOActivityTaskHandler.java:180) ~[temporal-sdk-1.8.1.jar:?]
at io.temporal.internal.activity.POJOActivityTaskHandler.handle(POJOActivityTaskHandler.java:120) ~[temporal-sdk-1.8.1.jar:?]
at io.temporal.internal.worker.ActivityWorker$TaskHandlerImpl.handle(ActivityWorker.java:204) ~[temporal-sdk-1.8.1.jar:?]
at io.temporal.internal.worker.ActivityWorker$TaskHandlerImpl.handle(ActivityWorker.java:164) ~[temporal-sdk-1.8.1.jar:?]
at io.temporal.internal.worker.PollTaskExecutor.lambda$process$0(PollTaskExecutor.java:93) ~[temporal-sdk-1.8.1.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) [?:?]
at java.lang.Thread.run(Thread.java:833) [?:?]
Caused by: io.temporal.serviceclient.CheckedExceptionWrapper: java.util.concurrent.ExecutionException: io.airbyte.workers.WorkerException: Normalization Failed.
at io.temporal.serviceclient.CheckedExceptionWrapper.wrap(CheckedExceptionWrapper.java:56) ~[temporal-serviceclient-1.8.1.jar:?]
at io.temporal.internal.sync.WorkflowInternal.wrap(WorkflowInternal.java:448) ~[temporal-sdk-1.8.1.jar:?]
at io.temporal.activity.Activity.wrap(Activity.java:51) ~[temporal-sdk-1.8.1.jar:?]
at io.airbyte.workers.temporal.TemporalAttemptExecution.get(TemporalAttemptExecution.java:135) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at io.airbyte.workers.temporal.sync.NormalizationActivityImpl.lambda$normalize$1(NormalizationActivityImpl.java:97) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at io.airbyte.workers.temporal.TemporalUtils.withBackgroundHeartbeat(TemporalUtils.java:228) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
... 14 more
Caused by: java.util.concurrent.ExecutionException: io.airbyte.workers.WorkerException: Normalization Failed.
at java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:396) ~[?:?]
at java.util.concurrent.CompletableFuture.get(CompletableFuture.java:2073) ~[?:?]
at io.airbyte.workers.temporal.TemporalAttemptExecution.get(TemporalAttemptExecution.java:129) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at io.airbyte.workers.temporal.sync.NormalizationActivityImpl.lambda$normalize$1(NormalizationActivityImpl.java:97) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at io.airbyte.workers.temporal.TemporalUtils.withBackgroundHeartbeat(TemporalUtils.java:228) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
... 14 more
Caused by: io.airbyte.workers.WorkerException: Normalization Failed.
at io.airbyte.workers.DefaultNormalizationWorker.run(DefaultNormalizationWorker.java:60) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at io.airbyte.workers.DefaultNormalizationWorker.run(DefaultNormalizationWorker.java:18) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$2(TemporalAttemptExecution.java:155) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
... 1 more
Caused by: io.airbyte.workers.WorkerException: Normalization Failed.
at io.airbyte.workers.DefaultNormalizationWorker.run(DefaultNormalizationWorker.java:57) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at io.airbyte.workers.DefaultNormalizationWorker.run(DefaultNormalizationWorker.java:18) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$2(TemporalAttemptExecution.java:155) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
... 1 more
Suppressed: io.airbyte.workers.WorkerException: Normalization process wasn't successful
at io.airbyte.workers.normalization.DefaultNormalizationRunner.close(DefaultNormalizationRunner.java:160) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at io.airbyte.workers.DefaultNormalizationWorker.run(DefaultNormalizationWorker.java:45) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at io.airbyte.workers.DefaultNormalizationWorker.run(DefaultNormalizationWorker.java:18) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$2(TemporalAttemptExecution.java:155) ~[io.airbyte-airbyte-workers-0.35.65-alpha.jar:?]
at java.lang.Thread.run(Thread.java:833) [?:?]
</details>
## Steps to Reproduce
1. docker-compose up --build
1. Create connection with Jira
1. Launch mysql with `docker run --rm -it -e MYSQL_ROOT_PASSWORD=some \
-e MYSQL_DATABASE=some \
-e MYSQL_USER=some \
-e MYSQL_PASSWORD=some \
-p 3306:3306 \
mysql`
1. Connect in mysql `docker exec -it <container id> mysql -uroot -proot`
1. execute: `SET GLOBAL local_infile = true;`
1. get ip from docker: `docker inspect -f '{{range.NetworkSettings.Networks}}{{.IPAddress}}{{end}}' <container id>`
1. create destination mysql with information
1. create connection from source Jira and Destination MySQL
1. Sync Now
┆Issue is synchronized with this [Monday item](https://airbyte-bunch.monday.com/boards/2536787439/pulses/2537075761) by [Unito](https://www.unito.io)
