UnsupportedResultException with Aurora Serverless V2

[ryanmargono]

I'm getting UnsupportedResultException: The result contains the unsupported data type regtype about every other request. I'm using the same postgres engine, version, and models as my Aurora Serverless V1.

Also seeing that migrations are not running with sync enabled.

Any suggestions?

[ArsenyYankovsky]

Please read the list of supported column types in the official document here. The UnsupportedResultException is thrown from the AWS SDK itself.

[ryanmargono]

Hey @ArsenyYankovsky, I read through that prior to migration and I confirmed through the RDS query editor that there are no unsupported types in my schema.

Furthermore, RDS query editor (which uses Data API under the hood) works flawlessly. This leads me to believe there could be something wrong with the lib.

[vin1627]

the same issue that I've encountered. Im using typeorm then connect to Data API. at first run of the database it was successfully update/ migrate my schema after that it will show the error on 2nd run and so on

[ficzusistvan]

Hi! I'm experiencing the same issue. I tried registering a type parser:
const registerCustomTypeParsers = () => { types.setTypeParser(2206, (val) => { console.log({ val }) return val }) // 2206 is the OID for regtype } , but with no luck. Any suggestions?

[vin1627]

I've only encountered this when I used dataAPI.
I tried to use the host from RDS then I was able to avoid this error

[ficzusistvan]

Thanks @vin1627 ! Directly accessing the underlying postgres db solved the issue.
I was trying to generate/run migrations when I encountered this error.
The ugly solution for me is to use a DataSource without Data API for migrations, the problem in this case is that the db must be publicly accessible..