Normalization failed for mysql source/dest

  • 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)

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.

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.