InvokeRDSBootstrapDatabase throws the error while trying to connect to database

[rnlduaeo]

Database initialization functionality in SaaSBoost tried to access poastgresql and threw an exception. I got below error message in rdsbootstrap lambda log group.

Reproduction Steps

1. upload .sql file(UTF-8 encoded) in rds appconfig screen.
2. try to onboard a tenant, you will see the above error message.

What did you expect to happen?

At least the database connection should be established, even though some syntax error might be occurred.

What actually happened?

Can't connect to database host

Environment

• AWS Region : ap-northeast-2
• AWS SaaS Boost Version : Version 798371c
• Workload OS (Linux or Windows) : linux

Other

---

This is 🐛 Bug Report

[bella-kwon]

For someone who encounters this error like me.
Here's the root cause I found -
ResultSet had been closed within try block(line: 187) in RdsBootstrap.databaseExists before trying rs.next() (line:194)
I So I just moved while block while (rs.next()) { into the try block as follows. You can fix this temporarily by changing this part and try to run it.

Of course, I understand that there will be many considerations for supporting DB engines from the team's perspectives.

I wrote this to reduce the # of developers who are wandering until then.