I am setting up the Connection in AWS Glue, trying to connect to my dev db instance (AWS rds Aurora PostgreSQL), I double checked VPC, subnet and setup the inbound rule to allow incoming connections to the db.
At the step of "Test Connection", it failed and providing me the following error message (not much information I can follow for debugging):
No older events at this moment.
Retry
2024-05-20T08:36:13.863Z ERROR StatusLogger Unrecognized format specifier [d]
2024-05-20T08:36:13.866Z ERROR StatusLogger Unrecognized conversion specifier [d] starting at position 16 in conversion pattern.
2024-05-20T08:36:13.866Z
2024-05-20T08:36:13.868Z ERROR StatusLogger Unrecognized format specifier [thread]
2024-05-20T08:36:13.868Z ERROR StatusLogger Unrecognized conversion specifier [thread] starting at position 25 in conversion pattern.
2024-05-20T08:36:13.868Z ERROR StatusLogger Unrecognized format specifier [level]
2024-05-20T08:36:13.868Z ERROR StatusLogger Unrecognized conversion specifier [level] starting at position 35 in conversion pattern.
2024-05-20T08:36:13.868Z ERROR StatusLogger Unrecognized format specifier [logger]
2024-05-20T08:36:13.869Z ERROR StatusLogger Unrecognized conversion specifier [logger] starting at position 47 in conversion pattern.
2024-05-20T08:36:13.869Z ERROR StatusLogger Unrecognized format specifier [msg]
2024-05-20T08:36:13.869Z ERROR StatusLogger Unrecognized conversion specifier [msg] starting at position 54 in conversion pattern.
2024-05-20T08:36:13.869Z ERROR StatusLogger Unrecognized format specifier [n]
2024-05-20T08:36:13.869Z ERROR StatusLogger Unrecognized conversion specifier [n] starting at position 56 in conversion pattern.
2024-05-20T08:36:13.889Z ERROR StatusLogger Unrecognized format specifier [d] ERROR StatusLogger Unrecognized conversion specifier [d] starting at position 16 in conversion pattern.
2024-05-20T08:36:13.890Z
2024-05-20T08:36:13.890Z ERROR StatusLogger Unrecognized format specifier [thread]
2024-05-20T08:36:13.890Z ERROR StatusLogger Unrecognized conversion specifier [thread] starting at position 25 in conversion pattern.
2024-05-20T08:36:13.891Z ERROR StatusLogger Unrecognized format specifier [level]
2024-05-20T08:36:13.891Z ERROR StatusLogger Unrecognized conversion specifier [level] starting at position 35 in conversion pattern.
2024-05-20T08:36:13.891Z ERROR StatusLogger Unrecognized format specifier [logger]
2024-05-20T08:36:13.891Z ERROR StatusLogger Unrecognized conversion specifier [logger] starting at position 47 in conversion pattern.
2024-05-20T08:36:14.061Z ERROR StatusLogger Unrecognized format specifier [msg]
2024-05-20T08:36:14.061Z ERROR StatusLogger Unrecognized conversion specifier [msg] starting at position 54 in conversion pattern.
2024-05-20T08:36:14.062Z ERROR StatusLogger Unrecognized format specifier [n]
2024-05-20T08:36:14.062Z ERROR StatusLogger Unrecognized conversion specifier [n] starting at position 56 in conversion pattern.
No newer events at this moment.
Auto retry paused.
Please help!
BTW, I am able to connect to the db instance using DBVisualizer using the same username and password, so login has no problem.