Hi I have 3 node yugabyte cluster on AWS with i3.4xlarge instance type and replication factor of 3.
I have been trying to do simple copy with a csv file but it hangs every time and I am not sure what I am doing wrong.
The csv is 6.6 GB in size and has 58566067 count of rows.
Also there is no errors logs but the COPY command did exit unexpectedly with error:
You are now connected to database "pdns" as user "yugabyte".
ysqlsh:copy.sql:2: WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
ysqlsh:copy.sql:2: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
I retried but no luck and I know the writes are not happening because I went to the UI and write ops/sec is staying at 0. If anyone could help that would be great. Thanks