I am having this same exact problem!
I am trying to load 6.8 Mil records which is a 391Mb .rdf file.
I do not have a load balancer in the mix, and am now running with 8Gb Ram on an t3.large instance on AWS.
Tried watching the syslog on the server and it does not show any errors on that side.