Based on the descriptions in the MySQL connector I...
# replication-troubleshooting
d
Based on the descriptions in the MySQL connector I thought this might have been fixed but it hasn't. Airbyte has trouble processing invalid date formats... Airbyte version: 0.40.15 Snowflake connector: 0.4.38 MySQL connector: 1.0.6 The relevant parts of the log is attached - Airbyte throws an error when attempting to process a date with the wrong month, example, '2021-00-03'. Is there a fix for this? For any other invalid date format is appears to null the value (which is expected).
s
Hey @Dwayne Rudy, is the issue you’re experiencing related to this one? https://github.com/airbytehq/airbyte/issues/16574
d
Yes it appears it is. The only difference being the exception is MySQL: java.sql.SQLException: MONTH. And the destination is Snowflake instead of Bigquery.
s
Thanks @Dwayne Rudy, can you make an issue on our Github relating to this? This is still an open issue that the team is working on and it would be great to have an issue to track for our users.
d