[ https://issues.apache.org/jira/browse/HAWQ-117?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lirong Jian resolved HAWQ-117. ------------------------------ Resolution: Fixed > 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)