How to use OpenSSL to create self signed certificates to test GPLOAD or GPFDIST
search cancel

How to use OpenSSL to create self signed certificates to test GPLOAD or GPFDIST

book

Article ID: 296283

calendar_today

Updated On:

Products

VMware Tanzu Greenplum

Issue/Introduction

This article explains how to use OpenSSL to create self signed certificates to test GPLOAD or GPFDIST.

Environment

Product Version: 5.0

Resolution

Download and install openSSL on the ETL server and the master server using the following command:

yum install openssl


The openssl.cnf is the default .cnf that is installed when openSSL is installed, it is located here: $GPHOME/etc/openssl.cnf.

In the environment where this was tested, we had 1 ETL server running Linux and a Greenplum cluster with eight primary segment instances.

For this test we will create the certs on the master server but these could also be created on the ETL server.


1. The first step is to create the certificates for the Server (server certificates).

Since we are using gpfdist, we will need a rootCA.pem renamed to root.crt. This file is used to sign the public and private key.

SSH to the master server and navigate to $GPHOME/etc/:

openssl req -x509 -nodes -newkey rsa:4096 -keyout rootCA.key -out rootCA.pem -sha256 -days 3650 -config ./openssl.cnf


This will create a rootCA.key and a rootCA.pem.

The ETL servers hostname in this example is ETL, as a result, the next certs were created for my ETL server. 
openssl genrsa -out ETL.key 2048
openssl req -new -nodes -newkey rsa:2048 -keyout ETL.key -out ETL.csr  -config ./openssl.cnf
You can accept the default value for every prompt for the command above except for the Common Name. This has to be given the hostname of the server you are creating this certificate for. In this example, it is the ETL server.

The next step is to sign the ETL.csr with the root certificate from the first step. 
openssl x509 -req -in ETL.csr -CA rootCA.pem -CAkey rootCA.key -CAcreateserial -out ETL.crt -days 3650 -sha256 -extensions v3_req -extfile ./openssl.cnf

Copy these files to a location where the gploader will look for them on the ETL server, this location is defined in the control_file on the ETL server.

Rename the ETL.crt, ETL.key to server.crt and server.key and rename the rootCA.pem to root.crt and copy these files to the location as explained above.


2. The next step is to create the certificates for the segment instances (client certificates).

Copy the rootCA.pem renamed to root.crt and rootCA.key created in the first step to $PGDATA/gpfdists on each of the segments. These 2 files are used across the cluster to sign the server certs. 

SSH to the segment server and "cd" to each of these instances and run the command in steps 2 to 4 again, changing their names as shown below. This will create the client certs and client keys.

Note: This has to be done on each segment server. Once the certs are created and signed by steps 1 to 3 below, copy the client.crt and client.key to each of the segments and put in $PGDATA/gpfdists.
  1. openssl genrsa -out client.key 2048
  2. openssl req -new -nodes -newkey rsa:2048 -keyout client.key -out client.csr  -config ./openssl.cnf
  3. openssl x509 -req -in mdw.csr -CA root.crt -CAkey rootCA.key -CAcreateserial -out client.crt -days 3650 -sha256 -extensions v3_req -extfile ./openssl.cnf

Make sure you accept the default for every prompt for command 3 above, except for the Common Name - this has to be given the hostname of the current segment server.

After this procedure is completed, the segment hosts will need a minimum of the files listed below:

client.crt 
  • Files ending in .crt are public keys.
client.key 
  • Files ending in .key are private keys,
root.crt 
  • This is the certificate you would usually get from a certificate authority but these are self signed, so we create it ourselves because it is required to correctly configure the client.crt.
This completes the creation of the certificates and testing can now proceed. 
 

3. The following procedure can be used to test gpload.

a. The first step is to use create the table used the the test on the database in this case its public.persons on the gpadmin database 
create table public.persons(personid int, lastname VARCHAR, firstname VARCHAR,address VARCHAR,city VARCHAR); 

b. This is the command used to kick off the job on the ETL server. 
gpload -f "/home/gpadmin/control_file " -l "/home/gpadmin/logfile.log" -V --gpfdist_timeout 30

The following is the control_file: 
%YAML 1.1

---

VERSION: 1.0.0.1



DATABASE: gpadmin

USER: gpadmin
HOST: mdw_lab2

PORT: 3129

GPLOAD:

   INPUT:

     - SOURCE:

        FILE:

          - "/home/gpadmin/gp_data.txt"    

        SSL: true

        CERTIFICATES_PATH: "/home/user/certs"

     - COLUMNS:

       - "personid":

       - "lastname":

       - "firstname":

       - "address":

       - "city":

     - MAX_LINE_LENGTH: 32768

     - FORMAT: TEXT

     - DELIMITER: "\x7c"

     - ESCAPE: 'off'

     - NULL_AS: '\N'

     - QUOTE: '"'

     - ENCODING: 'utf8'

     - ERROR_LIMIT: 0

   OUTPUT:

     - TABLE: public.persons

     - MODE: INSERT

   PRELOAD:

c. Below are the contents of the file "gp_data.txt"  to be read by the external table with gploader. 
cat /home/gpadmin/gp_data.txt 

218189|"haqaarbi"|"kqutyan"|"haqdf"|"UaaaS"

d. Below are the contents of the location certs were stored on the ETL server. 
ls -al /home/user/certs
total 36
drwxrwxr-x 2 gpadmin gpadmin  148 May 28 10:21 .
drwx------ 8 gpadmin gpadmin 4096 May 28 11:35 ..
-rw-rw-r-- 1 gpadmin gpadmin 3272 May 28 08:14 rootCA.key
-rw-rw-r-- 1 gpadmin gpadmin 2004 May 28 10:21 root.crt
-rw-rw-r-- 1 gpadmin gpadmin 1586 May 28 08:14 server.crt
-rw------- 1 gpadmin gpadmin 1708 May 28 08:14 server.key

e. This is the log printed to the screen for a successful completion of the gpload job: 
gpload -f "/home/gpadmin/cf_test_1" -l "/home/gpadmin/cf_test.log" -V --gpfdist_timeout 30
2019-05-28 14:52:07|DEBUG|getting config for version
2019-05-28 14:52:07|DEBUG|trying version
2019-05-28 14:52:07|DEBUG|found version
2019-05-28 14:52:07|INFO|gpload session started 2019-05-28 14:52:07
2019-05-28 14:52:07|DEBUG|config {u'database': u'gpadmin', u'host': u'mdw_lab2', u'version': u'1.0.0.1', u'user': u'gpadmin', u'gpload': {u'preload': None, u'input': [{u'source': {u'ssl': True, u'file': [u'/home/gpadmin/gp_data_ff.txt'], u'certificates_path': u'/home/gpadmin/certs'}}, {u'columns': [{u'personid': None}, {u'lastname': None}, {u'firstname': None}, {u'address': None}, {u'city': None}]}, {u'max_line_length': 32768}, {u'format': u'TEXT'}, {u'delimiter': u'|'}, {u'escape': u'off'}, {u'null_as': u'\\N'}, {u'quote': u'"'}, {u'encoding': u'utf8'}, {u'error_limit': 0}], u'output': [{u'table': u'public.persons'}, {u'mode': u'INSERT'}]}, u'port': 3129}
2019-05-28 14:52:07|DEBUG|getting config for gpload:output
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying output
2019-05-28 14:52:07|DEBUG|found output
2019-05-28 14:52:07|DEBUG|getting config for gpload:output:table
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying output
2019-05-28 14:52:07|DEBUG|found output
2019-05-28 14:52:07|DEBUG|trying table
2019-05-28 14:52:07|DEBUG|found table
2019-05-28 14:52:07|DEBUG|getting config for host
2019-05-28 14:52:07|DEBUG|trying host
2019-05-28 14:52:07|DEBUG|found host
2019-05-28 14:52:07|DEBUG|getting config for port
2019-05-28 14:52:07|DEBUG|trying port
2019-05-28 14:52:07|DEBUG|found port
2019-05-28 14:52:07|DEBUG|getting config for user
2019-05-28 14:52:07|DEBUG|trying user
2019-05-28 14:52:07|DEBUG|found user
2019-05-28 14:52:07|DEBUG|getting config for database
2019-05-28 14:52:07|DEBUG|trying database
2019-05-28 14:52:07|DEBUG|found database
2019-05-28 14:52:07|DEBUG|getting config for password
2019-05-28 14:52:07|DEBUG|trying password
2019-05-28 14:52:07|DEBUG|connection string: user=gpadmin host=mdw_lab2 port=3129 database=gpadmin
2019-05-28 14:52:07|DEBUG|Successfully connected to database
2019-05-28 14:52:07|DEBUG|found input column: [u'"personid"', u'integer', None, False]
2019-05-28 14:52:07|DEBUG|found input column: [u'"lastname"', u'character varying', None, False]
2019-05-28 14:52:07|DEBUG|found input column: [u'"firstname"', u'character varying', None, False]
2019-05-28 14:52:07|DEBUG|found input column: [u'"address"', u'character varying', None, False]
2019-05-28 14:52:07|DEBUG|found input column: [u'"city"', u'character varying', None, False]
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:columns
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying columns
2019-05-28 14:52:07|DEBUG|found columns
2019-05-28 14:52:07|DEBUG|getting source column data type from target
2019-05-28 14:52:07|DEBUG|getting source column data type from target
2019-05-28 14:52:07|DEBUG|getting source column data type from target
2019-05-28 14:52:07|DEBUG|getting source column data type from target
2019-05-28 14:52:07|DEBUG|getting source column data type from target
2019-05-28 14:52:07|DEBUG|from columns are:
2019-05-28 14:52:07|DEBUG|personid: integer
2019-05-28 14:52:07|DEBUG|lastname: character varying
2019-05-28 14:52:07|DEBUG|firstname: character varying
2019-05-28 14:52:07|DEBUG|address: character varying
2019-05-28 14:52:07|DEBUG|city: character varying
2019-05-28 14:52:07|DEBUG|getting config for gpload:output:mapping
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying output
2019-05-28 14:52:07|DEBUG|found output
2019-05-28 14:52:07|DEBUG|trying mapping
2019-05-28 14:52:07|DEBUG|"personid": integer = "personid"
2019-05-28 14:52:07|DEBUG|"lastname": character varying = "lastname"
2019-05-28 14:52:07|DEBUG|"firstname": character varying = "firstname"
2019-05-28 14:52:07|DEBUG|"address": character varying = "address"
2019-05-28 14:52:07|DEBUG|"city": character varying = "city"
2019-05-28 14:52:07|DEBUG|getting config for gpload:input
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:source(1)
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying source(1)
2019-05-28 14:52:07|DEBUG|found source
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:source(1):local_hostname
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying source(1)
2019-05-28 14:52:07|DEBUG|found source
2019-05-28 14:52:07|DEBUG|trying local_hostname
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:fully_qualified_domain_name
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying fully_qualified_domain_name
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:source:ssl
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying source
2019-05-28 14:52:07|DEBUG|found source
2019-05-28 14:52:07|DEBUG|trying ssl
2019-05-28 14:52:07|DEBUG|found ssl
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:source:certificates_path
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying source
2019-05-28 14:52:07|DEBUG|found source
2019-05-28 14:52:07|DEBUG|trying certificates_path
2019-05-28 14:52:07|DEBUG|found certificates_path
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:source:sslclean
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying source
2019-05-28 14:52:07|DEBUG|found source
2019-05-28 14:52:07|DEBUG|trying sslclean
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:source(1):port
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying source(1)
2019-05-28 14:52:07|DEBUG|found source
2019-05-28 14:52:07|DEBUG|trying port
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:source(1):port_range
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying source(1)
2019-05-28 14:52:07|DEBUG|found source
2019-05-28 14:52:07|DEBUG|trying port_range
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:source(1):port
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying source(1)
2019-05-28 14:52:07|DEBUG|found source
2019-05-28 14:52:07|DEBUG|trying port
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:source(1):port
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying source(1)
2019-05-28 14:52:07|DEBUG|found source
2019-05-28 14:52:07|DEBUG|trying port
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:source(1):file
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying source(1)
2019-05-28 14:52:07|DEBUG|found source
2019-05-28 14:52:07|DEBUG|trying file
2019-05-28 14:52:07|DEBUG|found file
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:max_line_length
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying max_line_length
2019-05-28 14:52:07|DEBUG|found max_line_length
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:transform
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying transform
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:transform_config
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying transform_config
2019-05-28 14:52:07|LOG|trying to run gpfdist --ssl /home/gpadmin/certs -p 8000 -P 9000 -f "/home/gpadmin/gp_data_ff.txt" -t 30 -V -m 32768
2019-05-28 14:52:07|LOG|gpfdist says: 2019-05-28 14:52:07 19095 INFO The certificate was successfully loaded from "/home/gpadmin/certs/server.crt"
2019-05-28 14:52:07|LOG|gpfdist says: 2019-05-28 14:52:07 19095 INFO The private key was successfully loaded from "/home/gpadmin/certs/server.key"
2019-05-28 14:52:07|LOG|gpfdist says: 2019-05-28 14:52:07 19095 INFO The CA file successfully loaded from "/home/gpadmin/certs/root.crt"
2019-05-28 14:52:07|LOG|gpfdist says: 2019-05-28 14:52:07 19095 INFO Before opening listening sockets - following listening sockets are available:
2019-05-28 14:52:07|LOG|gpfdist says: 2019-05-28 14:52:07 19095 INFO IPV6 socket: [::]:8000
2019-05-28 14:52:07|DEBUG|gpfdist: [msg] libevent using: epoll
2019-05-28 14:52:07|LOG|gpfdist says: 2019-05-28 14:52:07 19095 INFO IPV4 socket: 0.0.0.0:8000
2019-05-28 14:52:07|DEBUG|gpfdist: 
2019-05-28 14:52:07|LOG|gpfdist says: 2019-05-28 14:52:07 19095 INFO Trying to open listening socket:
2019-05-28 14:52:07|LOG|gpfdist says: 2019-05-28 14:52:07 19095 INFO IPV6 socket: [::]:8000
2019-05-28 14:52:07|LOG|gpfdist says: 2019-05-28 14:52:07 19095 INFO Opening listening socket succeeded
2019-05-28 14:52:07|LOG|gpfdist says: 2019-05-28 14:52:07 19095 INFO Trying to open listening socket:
2019-05-28 14:52:07|LOG|gpfdist says: 2019-05-28 14:52:07 19095 INFO IPV4 socket: 0.0.0.0:8000
2019-05-28 14:52:07|LOG|gpfdist says: 2019-05-28 14:52:07 19095 WARN Address already in use (errno = 98), port: 8000
2019-05-28 14:52:07|LOG|gpfdist says: Serving HTTPS on port 8000, directory /home/gpadmin
2019-05-28 14:52:07|INFO|started gpfdist --ssl /home/gpadmin/certs -p 8000 -P 9000 -f "/home/gpadmin/gp_data_ff.txt" -t 30 -V -m 32768
2019-05-28 14:52:07|LOG|gpfdist is running on port 8000
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:source:ssl
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying source
2019-05-28 14:52:07|DEBUG|found source
2019-05-28 14:52:07|DEBUG|trying ssl
2019-05-28 14:52:07|DEBUG|found ssl
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:source(2)
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying source(2)
2019-05-28 14:52:07|DEBUG|getting config for gpload:preload
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying preload
2019-05-28 14:52:07|DEBUG|getting config for gpload:output:mode
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying output
2019-05-28 14:52:07|DEBUG|found output
2019-05-28 14:52:07|DEBUG|trying mode
2019-05-28 14:52:07|DEBUG|found mode
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:error_table
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying error_table
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:log_errors
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying log_errors
2019-05-28 14:52:07|DEBUG|getting config for gpload:sql
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying sql
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:format
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying format
2019-05-28 14:52:07|DEBUG|found format
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:format
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying format
2019-05-28 14:52:07|DEBUG|found format
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:delimiter
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying delimiter
2019-05-28 14:52:07|DEBUG|found delimiter
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:null_as
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying null_as
2019-05-28 14:52:07|DEBUG|found null_as
2019-05-28 14:52:07|DEBUG|null \N
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:escape
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying escape
2019-05-28 14:52:07|DEBUG|found escape
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:header
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying header
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:force_not_null
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying force_not_null
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:encoding
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying encoding
2019-05-28 14:52:07|DEBUG|found encoding
2019-05-28 14:52:07|DEBUG|getting config for gpload:input:error_limit
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying input
2019-05-28 14:52:07|DEBUG|found input
2019-05-28 14:52:07|DEBUG|trying error_limit
2019-05-28 14:52:07|DEBUG|found error_limit
2019-05-28 14:52:07|DEBUG|getting config for gpload:external:schema
2019-05-28 14:52:07|DEBUG|trying gpload
2019-05-28 14:52:07|DEBUG|found gpload
2019-05-28 14:52:07|DEBUG|trying external
2019-05-28 14:52:07|DEBUG|into columns [[u'"personid"', u'integer', u'"personid"', False], [u'"lastname"', u'character varying', u'"lastname"', False], [u'"firstname"', u'character varying', u'"firstname"', False], [u'"address"', u'character varying', u'"address"', False], [u'"city"', u'character varying', u'"city"', False]]
2019-05-28 14:52:07|LOG|INSERT INTO "public"."persons" ("personid","lastname","firstname","address","city") SELECT "personid","lastname","firstname","address","city" FROM ext_gpload_c83e30d0_814f_11e9_9ba4_005056ac8496
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [7] Using SSL
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [8] Using SSL
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [9] Using SSL
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [10] Using SSL
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [11] Using SSL
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [12] Using SSL
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [13] Using SSL
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [14] Using SSL
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] ::ffff:10.193.102.14 requests //home/gpadmin/gp_data_ff.txt
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] got a request at port 41863:
2019-05-28 14:52:07|DEBUG|gpfdist:  GET //home/gpadmin/gp_data_ff.txt HTTP/1.1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] request headers:
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] Host:DataLabs-Informatica:8000
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] Accept:*/*
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] X-GP-XID:1558945339-0000021280
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] X-GP-CID:0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] X-GP-SN:0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] X-GP-SEGMENT-ID:3
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] X-GP-SEGMENT-COUNT:8
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] X-GP-LINE-DELIM-LENGTH:-1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] X-GP-PROTO:1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] X-GP-MASTER_HOST:10.193.102.15
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] X-GP-MASTER_PORT:3129
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] X-GP-CSVOPT:m0x111q0n0h0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] X-GP_SEG_PG_CONF:/data/primary/gp_5.16.0_201905270918183/postgresql.conf
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] X-GP_SEG_DATADIR:/data/primary/gp_5.16.0_201905270918183
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] X-GP-DATABASE:gpadmin
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] X-GP-USER:gpadmin
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] X-GP-SEG-PORT:30226
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:0:7] X-GP-SESSION-ID:18709
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO remove sessions
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:3:7] r->path /home/gpadmin/gp_data_ff.txt
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:3:7] new session trying to open the data stream
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:3:7] new session successfully opened the data stream
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:3:7] new session (1): (/home/gpadmin/gp_data_ff.txt, 1558945339-0000021280.0.0.1)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:1:3:7] joined session (/home/gpadmin/gp_data_ff.txt, 1558945339-0000021280.0.0.1)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:1:3:7] ::ffff:10.193.102.14 GET //home/gpadmin/gp_data_ff.txt - OK
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] ::ffff:10.193.102.14 requests //home/gpadmin/gp_data_ff.txt
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] got a request at port 41862:
2019-05-28 14:52:07|DEBUG|gpfdist:  GET //home/gpadmin/gp_data_ff.txt HTTP/1.1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] request headers:
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] Host:DataLabs-Informatica:8000
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] Accept:*/*
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] X-GP-XID:1558945339-0000021280
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] X-GP-CID:0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] X-GP-SN:0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] X-GP-SEGMENT-ID:2
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] X-GP-SEGMENT-COUNT:8
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] X-GP-LINE-DELIM-LENGTH:-1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] X-GP-PROTO:1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] X-GP-MASTER_HOST:10.193.102.15
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] X-GP-MASTER_PORT:3129
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] X-GP-CSVOPT:m0x111q0n0h0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] X-GP_SEG_PG_CONF:/data/primary/gp_5.16.0_201905270918182/postgresql.conf
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] X-GP_SEG_DATADIR:/data/primary/gp_5.16.0_201905270918182
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] X-GP-DATABASE:gpadmin
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] X-GP-USER:gpadmin
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] X-GP-SEG-PORT:30225
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:0:8] X-GP-SESSION-ID:18709
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:2:2:8] joined session (/home/gpadmin/gp_data_ff.txt, 1558945339-0000021280.0.0.1)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:2:2:8] ::ffff:10.193.102.14 GET //home/gpadmin/gp_data_ff.txt - OK
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] ::ffff:10.193.102.16 requests //home/gpadmin/gp_data_ff.txt
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] got a request at port 11528:
2019-05-28 14:52:07|DEBUG|gpfdist:  GET //home/gpadmin/gp_data_ff.txt HTTP/1.1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] request headers:
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] Host:DataLabs-Informatica:8000
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] Accept:*/*
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] X-GP-XID:1558945339-0000021280
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] X-GP-CID:0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] X-GP-SN:0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] X-GP-SEGMENT-ID:6
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] X-GP-SEGMENT-COUNT:8
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] X-GP-LINE-DELIM-LENGTH:-1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] X-GP-PROTO:1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] X-GP-MASTER_HOST:10.193.102.15
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] X-GP-MASTER_PORT:3129
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] X-GP-CSVOPT:m0x111q0n0h0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] X-GP_SEG_PG_CONF:/data/primary/gp_5.16.0_201905270918186/postgresql.conf
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] X-GP_SEG_DATADIR:/data/primary/gp_5.16.0_201905270918186
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] X-GP-DATABASE:gpadmin
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] X-GP-USER:gpadmin
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] X-GP-SEG-PORT:30225
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:0:9] X-GP-SESSION-ID:18709
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:3:6:9] joined session (/home/gpadmin/gp_data_ff.txt, 1558945339-0000021280.0.0.1)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:3:6:9] ::ffff:10.193.102.16 GET //home/gpadmin/gp_data_ff.txt - OK
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] ::ffff:10.193.102.19 requests //home/gpadmin/gp_data_ff.txt
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] got a request at port 64280:
2019-05-28 14:52:07|DEBUG|gpfdist:  GET //home/gpadmin/gp_data_ff.txt HTTP/1.1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] request headers:
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] Host:DataLabs-Informatica:8000
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] Accept:*/*
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] X-GP-XID:1558945339-0000021280
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] X-GP-CID:0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] X-GP-SN:0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] X-GP-SEGMENT-ID:4
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] X-GP-SEGMENT-COUNT:8
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] X-GP-LINE-DELIM-LENGTH:-1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] X-GP-PROTO:1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] X-GP-MASTER_HOST:10.193.102.15
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] X-GP-MASTER_PORT:3129
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] X-GP-CSVOPT:m0x111q0n0h0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] X-GP_SEG_PG_CONF:/data/primary/gp_5.16.0_201905270918184/postgresql.conf
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] X-GP_SEG_DATADIR:/data/primary/gp_5.16.0_201905270918184
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] X-GP-DATABASE:gpadmin
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] X-GP-USER:gpadmin
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] X-GP-SEG-PORT:30225
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:0:10] X-GP-SESSION-ID:18709
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:4:4:10] joined session (/home/gpadmin/gp_data_ff.txt, 1558945339-0000021280.0.0.1)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:4:4:10] ::ffff:10.193.102.19 GET //home/gpadmin/gp_data_ff.txt - OK
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] ::ffff:10.193.102.16 requests //home/gpadmin/gp_data_ff.txt
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] got a request at port 11530:
2019-05-28 14:52:07|DEBUG|gpfdist:  GET //home/gpadmin/gp_data_ff.txt HTTP/1.1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] request headers:
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] Host:DataLabs-Informatica:8000
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] Accept:*/*
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] X-GP-XID:1558945339-0000021280
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] X-GP-CID:0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] X-GP-SN:0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] X-GP-SEGMENT-ID:7
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] X-GP-SEGMENT-COUNT:8
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] X-GP-LINE-DELIM-LENGTH:-1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] X-GP-PROTO:1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] X-GP-MASTER_HOST:10.193.102.15
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] X-GP-MASTER_PORT:3129
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] X-GP-CSVOPT:m0x111q0n0h0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] X-GP_SEG_PG_CONF:/data/primary/gp_5.16.0_201905270918187/postgresql.conf
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] X-GP_SEG_DATADIR:/data/primary/gp_5.16.0_201905270918187
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] X-GP-DATABASE:gpadmin
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] X-GP-USER:gpadmin
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] X-GP-SEG-PORT:30226
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:0:11] X-GP-SESSION-ID:18709
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:5:7:11] joined session (/home/gpadmin/gp_data_ff.txt, 1558945339-0000021280.0.0.1)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:5:7:11] ::ffff:10.193.102.16 GET //home/gpadmin/gp_data_ff.txt - OK
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] ::ffff:10.193.102.13 requests //home/gpadmin/gp_data_ff.txt
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] got a request at port 43882:
2019-05-28 14:52:07|DEBUG|gpfdist:  GET //home/gpadmin/gp_data_ff.txt HTTP/1.1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] request headers:
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] Host:DataLabs-Informatica:8000
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] Accept:*/*
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] X-GP-XID:1558945339-0000021280
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] X-GP-CID:0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] X-GP-SN:0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] X-GP-SEGMENT-ID:0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] X-GP-SEGMENT-COUNT:8
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] X-GP-LINE-DELIM-LENGTH:-1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] X-GP-PROTO:1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] X-GP-MASTER_HOST:10.193.102.15
2019-05-28 14:52:07|INFO|running time: 0.20 seconds
2019-05-28 14:52:07|LOG|killing gpfdist
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] X-GP-MASTER_PORT:3129
2019-05-28 14:52:07|LOG|terminating all threads
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] X-GP-CSVOPT:m0x111q0n0h0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] X-GP_SEG_PG_CONF:/data/primary/gp_5.16.0_201905270918180/postgresql.conf
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] X-GP_SEG_DATADIR:/data/primary/gp_5.16.0_201905270918180
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] X-GP-DATABASE:gpadmin
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] X-GP-USER:gpadmin
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] X-GP-SEG-PORT:30225
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] X-GP-SESSION-ID:18709
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:6:0:12] joined session (/home/gpadmin/gp_data_ff.txt, 1558945339-0000021280.0.0.1)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:6:0:12] ::ffff:10.193.102.13 GET //home/gpadmin/gp_data_ff.txt - OK
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] ::ffff:10.193.102.19 requests //home/gpadmin/gp_data_ff.txt
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] got a request at port 64282:
2019-05-28 14:52:07|DEBUG|gpfdist:  GET //home/gpadmin/gp_data_ff.txt HTTP/1.1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] request headers:
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] Host:DataLabs-Informatica:8000
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] Accept:*/*
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] X-GP-XID:1558945339-0000021280
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] X-GP-CID:0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] X-GP-SN:0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] X-GP-SEGMENT-ID:5
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] X-GP-SEGMENT-COUNT:8
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] X-GP-LINE-DELIM-LENGTH:-1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] X-GP-PROTO:1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] X-GP-MASTER_HOST:10.193.102.15
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] X-GP-MASTER_PORT:3129
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] X-GP-CSVOPT:m0x111q0n0h0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] X-GP_SEG_PG_CONF:/data/primary/gp_5.16.0_201905270918185/postgresql.conf
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] X-GP_SEG_DATADIR:/data/primary/gp_5.16.0_201905270918185
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] X-GP-DATABASE:gpadmin
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] X-GP-USER:gpadmin
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] X-GP-SEG-PORT:30226
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:0:13] X-GP-SESSION-ID:18709
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:7:5:13] joined session (/home/gpadmin/gp_data_ff.txt, 1558945339-0000021280.0.0.1)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:7:5:13] ::ffff:10.193.102.19 GET //home/gpadmin/gp_data_ff.txt - OK
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 DEBUG [1:1:3:7] F 28 /home/gpadmin/gp_data_ff.txt
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 DEBUG [1:1:3:7] O 0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 DEBUG [1:1:3:7] L 1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 DEBUG [1:1:3:7] D 44
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 DEBUG [1:1:3:7] header size: 64
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 DEBUG [1:1:3:7] send header bytes 0 .. 64 (top 64)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 DEBUG [1:1:3:7] send data bytes off buf 0 .. 44 (top 44)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO session_get_block: end session due to EOF
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO session end.
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:1:3:7] sent EOF: succeed
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:1:3:7] request end
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:1:3:7] detach segment request from session
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 DEBUG [1:1:3:7] SSL cleanup started
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] ::ffff:10.193.102.13 requests //home/gpadmin/gp_data_ff.txt
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] got a request at port 43884:
2019-05-28 14:52:07|DEBUG|gpfdist:  GET //home/gpadmin/gp_data_ff.txt HTTP/1.1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] request headers:
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] Host:DataLabs-Informatica:8000
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] Accept:*/*
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] X-GP-XID:1558945339-0000021280
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] X-GP-CID:0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] X-GP-SN:0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] X-GP-SEGMENT-ID:1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] X-GP-SEGMENT-COUNT:8
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] X-GP-LINE-DELIM-LENGTH:-1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] X-GP-PROTO:1
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] X-GP-MASTER_HOST:10.193.102.15
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] X-GP-MASTER_PORT:3129
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] X-GP-CSVOPT:m0x111q0n0h0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] X-GP_SEG_PG_CONF:/data/primary/gp_5.16.0_201905270918181/postgresql.conf
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] X-GP_SEG_DATADIR:/data/primary/gp_5.16.0_201905270918181
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] X-GP-DATABASE:gpadmin
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] X-GP-USER:gpadmin
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] X-GP-SEG-PORT:30226
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:0:14] X-GP-SESSION-ID:18709
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:1:14] session already ended. return empty response (OK)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:1:14] HTTP EMPTY: ::ffff:10.193.102.13 GET //home/gpadmin/gp_data_ff.txt - OK
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:1:14] sent EOF: succeed
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:1:14] request end
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:1:14] detach segment request from session
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 DEBUG [0:8:1:14] SSL cleanup started
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO session_get_block: end session is_error: 0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO session end.
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:2:2:8] sent EOF: succeed
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:2:2:8] request end
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:2:2:8] detach segment request from session
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 DEBUG [1:2:2:8] SSL cleanup started
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO session_get_block: end session is_error: 0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO session end.
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:3:6:9] sent EOF: succeed
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:3:6:9] request end
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:3:6:9] detach segment request from session
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 DEBUG [1:3:6:9] SSL cleanup started
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO session_get_block: end session is_error: 0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO session end.
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:4:4:10] sent EOF: succeed
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:4:4:10] request end
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:4:4:10] detach segment request from session
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 DEBUG [1:4:4:10] SSL cleanup started
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO session_get_block: end session is_error: 0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO session end.
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:5:7:11] sent EOF: succeed
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:5:7:11] request end
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:5:7:11] detach segment request from session
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 DEBUG [1:5:7:11] SSL cleanup started
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO session_get_block: end session is_error: 0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO session end.
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:6:0:12] sent EOF: succeed
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:6:0:12] request end
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:6:0:12] detach segment request from session
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 DEBUG [1:6:0:12] SSL cleanup started
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO session_get_block: end session is_error: 0
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO session end.
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:7:5:13] sent EOF: succeed
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:7:5:13] request end
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:7:5:13] detach segment request from session
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:7:5:13] session has finished all segment requests
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 DEBUG [1:7:5:13] SSL cleanup started
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:1:3:7] SSL cleanup ended
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:1:3:7] successfully shutdown socket
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:7:5:13] SSL cleanup ended
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:7:5:13] successfully shutdown socket
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:6:0:12] SSL cleanup ended
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:6:0:12] successfully shutdown socket
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:5:7:11] SSL cleanup ended
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:5:7:11] successfully shutdown socket
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:4:4:10] SSL cleanup ended
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:4:4:10] successfully shutdown socket
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:3:6:9] SSL cleanup ended
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:3:6:9] successfully shutdown socket
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:2:2:8] SSL cleanup ended
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:2:2:8] successfully shutdown socket
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:1:14] SSL cleanup ended
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:1:14] failed to shutdown socket, errno: 107, msg: Transport endpoint is not connected
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 WARN [1:1:3:7] gpfdist read unexpected data after shutdown 
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:1:3:7] unsent bytes: 0 (-1 means not supported)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:1:3:7] successfully closed socket
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 WARN [1:7:5:13] gpfdist read unexpected data after shutdown 
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:7:5:13] unsent bytes: 0 (-1 means not supported)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:7:5:13] successfully closed socket
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 WARN [1:6:0:12] gpfdist read unexpected data after shutdown 
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:6:0:12] unsent bytes: 0 (-1 means not supported)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:6:0:12] successfully closed socket
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 WARN [0:8:1:14] gpfdist read unexpected data after shutdown 
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:1:14] unsent bytes: 74 (-1 means not supported)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [0:8:1:14] successfully closed socket
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 WARN [1:5:7:11] gpfdist read unexpected data after shutdown 
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:5:7:11] unsent bytes: 0 (-1 means not supported)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:5:7:11] successfully closed socket
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 WARN [1:3:6:9] gpfdist read unexpected data after shutdown 
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:3:6:9] unsent bytes: 0 (-1 means not supported)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:3:6:9] successfully closed socket
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 WARN [1:2:2:8] gpfdist read unexpected data after shutdown 
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:2:2:8] unsent bytes: 0 (-1 means not supported)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:2:2:8] successfully closed socket
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 WARN [1:4:4:10] gpfdist read unexpected data after shutdown 
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:4:4:10] unsent bytes: 0 (-1 means not supported)
2019-05-28 14:52:07|DEBUG|gpfdist: 2019-05-28 14:52:07 19095 INFO [1:4:4:10] successfully closed socket
2019-05-28 14:52:07|LOG|all threads are terminated
2019-05-28 14:52:07|LOG|removing temporary data
2019-05-28 14:52:07|DEBUG|getting config for password
2019-05-28 14:52:07|DEBUG|trying password
2019-05-28 14:52:07|DEBUG|connection string: user=gpadmin host=mdw_lab2 port=3129 database=gpadmin
2019-05-28 14:52:07|DEBUG|Successfully connected to database
2019-05-28 14:52:07|DEBUG|drop external table if exists ext_gpload_c83e30d0_814f_11e9_9ba4_005056ac8496
2019-05-28 14:52:07|INFO|rows Inserted          = 1
2019-05-28 14:52:07|INFO|rows Updated           = 0
2019-05-28 14:52:07|INFO|data formatting errors = 0
2019-05-28 14:52:07|INFO|gpload succeeded


Powered by Wolken Software