Vertica v6.1.0-0: server closed the connection unexpectedly
I'm writing a script to export data from our vertica cluster.
The command I'm using is:
vsql MY_DB_NAME -At -F$'\t' -o /data/vertica_archive/MY_DATA_2015_07_01.tsv -c "select * from DATA_TABLE where ts_date ='2015-07-01';"
Sporadically resulting with:
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
All of our queries are simple "select * from TABLE where ts_date=DATE", but some of the queries resultset will generate a 10GB files.
Is there any exit code documentation or can any one suggest how to debug?