Hi,
I have a Crawler that runs Daily and uses Connection that connects to my RDS with Aurora MySQL Engine.
Since last week (31 Mar 2022 UTC) I suddenly started receiving this Error Log and the crawler keep on failing.
Error crawling database serendipt: SQLException: SQLState: 01S00 Error Code: 0 Message: The server time zone value 'ASIA/MANILA' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
The last time the crawler succeed was (30 Mar 2022 UTC).
I tried adding some mysql parameters to fix the timezone, such as serverTimezone=UTC&useLegacyDatetimeCode=true&useJDBCCompliantTimezoneShift=true or serverTimezone=Asia%2FManila. But the same Error Logs appears. None of the changes seems to reflect in the Crawler, but when trying in "Test Connection" it succeeds.
My workaround in it, is I just ends up directly connecting to my JDBC connection inside the Job, and just connected the JDBC connection to the Job.
Note: I just checked today, Test Connection in Connection does not work anymore but still able to connect inside the Job.