[jira] [Commented] (HAWQ-117) Alter a newly created tablespace table in kerberos mode would cause "ERROR: Append-Only Storage Read could not open segment file"

["Lirong Jian (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HAWQ-117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14989167#comment-14989167 ] 

Lirong Jian commented on HAWQ-117:
----------------------------------

The root cause of this issue is that:
On the segments, the filesystem credential is not found. This is because in that case (split partition) the filesystem credential is not dispatched from the master.

The proposed solution is that:
1. Add some checking before dispatching metadata from master to segment, to make sure all needed information is ready;
2. Based on (1), fix all the paths through which the similar issue occurs.

> Alter a newly created tablespace table in kerberos mode would cause "ERROR:  Append-Only Storage Read could not open segment file"
> ----------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: HAWQ-117
>                 URL: https://issues.apache.org/jira/browse/HAWQ-117
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: Storage
>            Reporter: Lirong Jian
>            Assignee: Lirong Jian
>
> create tablespace ts_a4 filespace cdbfast_fs_a;
> create tablespace ts_b4 filespace cdbfast_fs_b;
> create table fsts_split_list1 (i int)  tablespace ts_a4 partition by list(i) (
> partition a values(1, 2, 3, 4) WITH (appendonly=true,checksum=true,blocksize=819200,compresslevel=8),
> partition b values(5, 6, 7, 8),
> default partition default_part);
> CREATE TABLE
> -- Insert few records into the table
> insert into fsts_split_list1 values (generate_series(1,10));
> select count(*) from fsts_split_list1;
> -- split partition
> alter table fsts_split_list1 split partition for(1) at (1,2) into (partition f1a, partition f1b);
> psql:/data/gpadmin/pulse2-agent/agents/agent1/work/HAWQ-main-FeatureTest-opt-security-FIPS/FIPS-GPSQL-schedule_kerberos/cdbunit/cdbfast/storage/tablespace_filespace/gp_filespace_tablespace/transaction_rollback.sql:17: NOTICE:  exchanged partition "a" of relation "fsts_split_list1" with relation "pg_temp_29565"
> psql:/data/gpadmin/pulse2-agent/agents/agent1/work/HAWQ-main-FeatureTest-opt-security-FIPS/FIPS-GPSQL-schedule_kerberos/cdbunit/cdbfast/storage/tablespace_filespace/gp_filespace_tablespace/transaction_rollback.sql:17: NOTICE:  dropped partition "a" for relation "fsts_split_list1"
> psql:/data/gpadmin/pulse2-agent/agents/agent1/work/HAWQ-main-FeatureTest-opt-security-FIPS/FIPS-GPSQL-schedule_kerberos/cdbunit/cdbfast/storage/tablespace_filespace/gp_filespace_tablespace/transaction_rollback.sql:17: NOTICE:  CREATE TABLE will create partition "fsts_split_list1_1_prt_f1a" for table "fsts_split_list1"
> psql:/data/gpadmin/pulse2-agent/agents/agent1/work/HAWQ-main-FeatureTest-opt-security-FIPS/FIPS-GPSQL-schedule_kerberos/cdbunit/cdbfast/storage/tablespace_filespace/gp_filespace_tablespace/transaction_rollback.sql:17: NOTICE:  CREATE TABLE will create partition "fsts_split_list1_1_prt_f1b" for table "fsts_split_list1"
> psql:/data/gpadmin/pulse2-agent/agents/agent1/work/HAWQ-main-FeatureTest-opt-security-FIPS/FIPS-GPSQL-schedule_kerberos/cdbunit/cdbfast/storage/tablespace_filespace/gp_filespace_tablespace/transaction_rollback.sql:17: WARNING:  failed to get filesystem credential.  (seg0 rhel64-2:21100 pid=482506)
> DETAIL:  Success



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)