Source MySQL: Zero date value prohibited #36344
Unanswered
cattmerry
asked this question in
Connector Questions
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
airbyte version : airbyte helm chart - 0.47.29
source mysql version : 8.0
I've searched several articles and solutions to no avail, so I'm asking.
I added the following values to the JDBC URL Parameters, but to no avail.
zerodatetimebehavior=CONVERT_TO_NULL
zerodatetimebehavior=Converttonull
Here's the source data we tested
The error log looks like this

log file :
48ce1dd5_0e50_41ec_ac1d_f106b779eef8_job_7621_attempt_3_txt.txt
I also tried updating airbyte helm chart to the latest version(0.56.50), but it still failed.
This is a situation where the data cannot be modified in production mysql.
The official documentation says you can set zerodatetimebehavior=Converttonull, but it doesn't seem to work. (https://docs.airbyte.com/integrations/sources/mysql/mysql-troubleshooting?_gl=1*l8jred*_gcl_au*MzU1NTg3NzYyLjE3MTAyMDYxNzQ.#common-config-errors)
I would appreciate it if someone could help.
Beta Was this translation helpful? Give feedback.
All reactions