Normalization failed for mysql source/dest

Troubleshooting
#1
  • Is this your first time deploying Airbyte?: Yes
  • OS Version / Instance: Amazon Linux 2
  • Memory / Disk: 50GB
  • Deployment:
  • Airbyte Version: 0.35.65-alpha
  • Source name/version: mysql 8.0.28
  • Destination name/version: mysql 8.0.28 docker
  • Step: The issue is happening during normalization. Not using SSH Tunnel
  • Description:
    My source and destination are MySQL databases with same version. Connection is successful when Transformation is ‘Raw JSON’ but fails when ‘Normalization’ is selected. When Transformation is ‘Normalization’ I can see the necessary raw tables created and populated in the destination schema. Attached log file for reference.

I tried reading a file (Source: File) into my mysql destination and the normalization fails here too. Can see the raw table created for the source file.
logs-36.txt (93.8 KB)

Sync Failing: Normalization Failed (MSSQL --> MySQL)
#3

Hi @greeshmagirish,
We are working on upgrading the normalization for MySQL in this PR. I can’t figure if it’ll solve you problem because you log file does not contain an explicit enough error from which I could deduce anything. It would be great if you could open an issue on our repo to report this bug.

#4

Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.

#5