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.

gefragt vor 2 Jahren596 Aufrufe
2 Antworten
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.

beantwortet vor 2 Jahren
  • 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?

beantwortet vor einem Jahr

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen