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.