DB Migration: EC2 Psql DB to RDS psql .
I'm creating a DMS task with an EC2 DB as the source endpoint and an RDS over cross-account as the target. When I first started my migration task, it will finally display this problem.
" [TASK_MANAGER] D: Recode: SQL_ERROR SqlState: 08001 NativeError: 101 Message: [unixODBC]FATAL: too many connections for role "user-xyz"; Failed to connect; Failed while preparing utility stream component; Cannot initialize subtask; Stream component 'st_1_2DVOTXQUUTOU27RXDGTYU7Z2HJ7QAXUTVEYYR6I' terminated [1022506] (replicationtask.c:2891)" "
Additionally, I checked the sessions in the database to kill off all of my connections, but none from DMS, AWS, or my user were found.
- I checked test connection of both endpoints and it's successful
- Both account VPC is Peered.
- Also used large size replication instance and my target RDS to handle load.
- My max_connection of EC2 db is 400.
- I also checked out this setup through aws cli but did not find any solution.
Anyone please helps me here