Can't create Glue Connection to RDS MySQL - [Error] Failed to test connection due to FAILED status.

0

Hello, I have problem when create Glue connection to RDS MySQL. My RDS MySQL instance put in private subnet, with NAT Gateway, and Glue have necessary permissions (I use old IAM role, which I previously create connection to using in another project) When I test connection it shows error Failed to test connection due to FAILED status. Opening CloudWatch Logs I see:

2024-02-22T21:06:23.898+07:00 ERROR StatusLogger Unrecognized format specifier [d]

2024-02-22T21:06:23.899+07:00

2024-02-22T21:06:23.899+07:00 ERROR StatusLogger Unrecognized conversion specifier [d] starting at position 16 in conversion pattern.

2024-02-22T21:06:23.902+07:00 ERROR StatusLogger Unrecognized format specifier [thread]

2024-02-22T21:06:23.902+07:00

2024-02-22T21:06:23.902+07:00 ERROR StatusLogger Unrecognized conversion specifier [thread] starting at position 25 in conversion pattern.

2024-02-22T21:06:23.903+07:00

2024-02-22T21:06:23.903+07:00 ERROR StatusLogger Unrecognized format specifier [level]

2024-02-22T21:06:23.903+07:00

2024-02-22T21:06:23.903+07:00 ERROR StatusLogger Unrecognized conversion specifier [level] starting at position 35 in conversion pattern.

2024-02-22T21:06:23.903+07:00

2024-02-22T21:06:23.904+07:00 ERROR StatusLogger Unrecognized format specifier [logger]

2024-02-22T21:06:23.904+07:00

2024-02-22T21:06:23.904+07:00 ERROR StatusLogger Unrecognized conversion specifier [logger] starting at position 47 in conversion pattern.

2024-02-22T21:06:23.904+07:00

2024-02-22T21:06:23.904+07:00 ERROR StatusLogger Unrecognized format specifier [msg]

2024-02-22T21:06:23.905+07:00

2024-02-22T21:06:23.905+07:00 ERROR StatusLogger Unrecognized conversion specifier [msg] starting at position 54 in conversion pattern.

2024-02-22T21:06:23.905+07:00

2024-02-22T21:06:23.905+07:00 ERROR StatusLogger Unrecognized format specifier [n]

2024-02-22T21:06:23.905+07:00

2024-02-22T21:06:24.111+07:00 ERROR StatusLogger Unrecognized conversion specifier [n] starting at position 56 in conversion pattern.

2024-02-22T21:06:24.112+07:00

2024-02-22T21:06:24.112+07:00 ERROR StatusLogger Unrecognized format specifier [d]

2024-02-22T21:06:24.112+07:00

2024-02-22T21:06:24.112+07:00 ERROR StatusLogger Unrecognized conversion specifier [d] starting at position 16 in conversion pattern.

2024-02-22T21:06:24.112+07:00

2024-02-22T21:06:24.112+07:00 ERROR StatusLogger Unrecognized format specifier [thread]

2024-02-22T21:06:24.112+07:00

2024-02-22T21:06:24.112+07:00 ERROR StatusLogger Unrecognized conversion specifier [thread] starting at position 25 in conversion pattern.

2024-02-22T21:06:24.112+07:00

2024-02-22T21:06:24.112+07:00 ERROR StatusLogger Unrecognized format specifier [level]

2024-02-22T21:06:24.113+07:00

2024-02-22T21:06:24.113+07:00 ERROR StatusLogger Unrecognized conversion specifier [level] starting at position 35 in conversion pattern.

2024-02-22T21:06:24.113+07:00

2024-02-22T21:06:24.113+07:00 ERROR StatusLogger Unrecognized format specifier [logger]

2024-02-22T21:06:24.113+07:00

2024-02-22T21:06:24.113+07:00 ERROR StatusLogger Unrecognized conversion specifier [logger] starting at position 47 in conversion pattern.

2024-02-22T21:06:24.113+07:00

2024-02-22T21:06:24.113+07:00 ERROR StatusLogger Unrecognized format specifier [msg]

2024-02-22T21:06:24.113+07:00

2024-02-22T21:06:24.131+07:00 ERROR StatusLogger Unrecognized conversion specifier [msg] starting at position 54 in conversion pattern.

2024-02-22T21:06:24.131+07:00

2024-02-22T21:06:24.131+07:00 ERROR StatusLogger Unrecognized format specifier [n]

2024-02-22T21:06:24.131+07:00

2024-02-22T21:06:24.131+07:00 ERROR StatusLogger Unrecognized conversion specifier [n] starting at position 56 in conversion pattern.

2024-02-22T21:06:24.131+07:00

2024-02-22T21:06:27.224+07:00 Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class is com.mysql.cj.jdbc.Driver'. The driver is automat

Anyone please helps me to fix this error. Thanks a lot, guy!!!

1개 답변
0

That log is truncated. Anyway the test tool is just for reference and uses old drivers. In your case, I would test it directly on a job/notebook.

profile pictureAWS
전문가
답변함 3달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인