Glue Crawler using JDBC mysql Connection unable to configure serverTimezone.

0

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.

asked 2 years ago582 views
2 Answers
0

After searching for a while, this is the only place I've seen this issue mentioned. I have the same issue except the MySQL timezone is "CDT". Adding "?serverTimezone=CST6CDT" to the connection string, allows the connection test to pass. However it appears a Crawler using the connection drops that connections string argument.

answered 2 years ago
  • 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.

0

I am too struggling with same issue. Has anyone found resolution on this?

answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions