I have 3 public and 3 private subnets in an AWS VPC. I am currently trying to deploy an Aurora Postgres database cluster with RDS and I'm receiving an error when trying to create my primary database along with 2 read replicas. The error I am getting is incompatible-network
. After doing some research, a lot of fixes mention to verify the subnet group the database cluster is configured with has subnets that still exist and have available IP addresses. It turns out, my subnets do exist but have ZERO available IP addresses. This is really odd to me since the public subnets have over 200 available IPs.
I'm not sure if this relevant to this post, but the application that is being hosted in this VPC is being deployed through AWS CodeDeploy as a blue/green deployment, meaning for each deployment, new instances are being created. I still cannot understand why the number of available IP addresses is zero. Any advice on how to fix this would be appreciated. Please let me know if I need to provide anything to come to a solution. Thanks!