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.

posta 2 anni fa596 visualizzazioni
2 Risposte
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.

con risposta 2 anni fa
  • 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?

con risposta un anno fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande