ERROR: missing data for column "loguser"

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:
Unable to query data from hawq_toolkit.hawq_log_database table

Error Message:

gpadmin=# select * from hawq_toolkit.hawq_log_database limit 10;

ERROR:  missing data for column "loguser"
CONTEXT:  External table __hawq_log_master_ext, line nnnnn of execute:cat $GP_SEG_DATADIR/pg_log/*.csv: " "

Environment

Cause

Someone investigated the master's pg_log and has left a blank line with a space as below: 

Someone investigated the master's pg_log and has left a blank line with a space as below. 

Master's pg_log -
:
[ ] <<<=== A blank line with a space character
2016-08-31 00:13:24.948900 EDT,"gpadmin","gpadmin",p23325,th1256007712,"192.168.4.21","37404",2016-08-31 00:13:24 EDT,0,con1,,seg-1,,,,,"LOG","00000","--------------------------",,,,,,,0,,"cdblogsync.c",230,
:

Resolution

From pg_log directory, identify .csv file with the invalid blank line and remove it from the file.