Loading Data via gpfdists Failed with "Unknown SSL protocol error"
Article ID: 295442
Updated On:
Products
Issue/Introduction
Symptoms:
When attempting to load the large volume of data via gpfdists protocol, after a while it failed with error message “Unknown SSL protocol error”.
Error Message:
2017-08-16 11:56:51.156856 UTC,"gpadmin","gpadmin",p128362,th-262436992,"192.0.2.1","37180",2017-08-16 11:55:02 UTC,3321245,con58397,cmd59,seg15,slice1,dx1696640,x3321245,sx1,"ERROR","08006","connection with gpfdist failed for gpfdists://etl1.example.com:8080/data/batch1/data.gz. effective url: https://etl1.example.com:8080/data/batch1/data.gz.","Unknown SSL protocol error in connection to etl1.example.com:8080",,,,,"insert into ""table1""(""c1"", ""c2"") select * from ""table1_ex""
* Unknown SSL protocol error in connection to etl1.example.com:8080
Environment
Cause
The "max open files" ulimit setting on the server hosting gpfdist service is with a default value (1024), which is not big enough when there are too many data files to load.
When the limit was reached gpfdist instance could not open a new file for incoming request from Greenplum database side, hence returned "Unknown SSL protocol error".
Resolution
Adjust "max open files" ulimit setting on the server hosting gpfdist instance and make sure it's big enough for the specific tasks.
See Configuring Your Systems and Installing Greenplum for how to set the ulimit settings for the user running gpfdist on the host
Feedback
