[
https://issues.apache.org/jira/browse/HAWQ-147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lirong Jian updated HAWQ-147:
-----------------------------
Description:
Follow are the steps to reproduce this issue:
$ psql -d template1
psql (8.2.15)
Type "help" for help.
template1=# CREATE TABLE foo (
template1(# a INT)
template1-# WITH (appendonly=true, orientation=parquet);
CREATE TABLE
template1=# INSERT INTO foo VALUES(1);
INSERT 0 1
template1=# CREATE DATABASE gptest;
ERROR: Append-Only relation 'foo' gp_relation_node entry for segment file #1
without an aoseg entry (case #2) (cdbdatabaseinfo.c:1554)
template1=#
was:
When run commands below:
mkdir cdbfast_pgbkup
psql -d postgres
{code}
\c template1
CREATE TABLE mpp7191 (a int, b date, c char,
d char(4), e varchar(20), f timestamp)
WITH (orientation=parquet,appendonly=true)
partition by range (b)
subpartition by list (a)
subpartition template (
subpartition l1 values (1,2,3,4,5),
subpartition l2 values (6,7,8,9,10) ),
subpartition by list (e)
subpartition template (
subpartition ll1 values ('Engineering'),
subpartition ll2 values ('QA') ),
subpartition by list (c)
subpartition template (
subpartition lll1 values ('M'),
subpartition lll2 values ('F') )
(
start (date '2007-01-01')
end (date '2010-01-01') every (interval '1 year')
);
insert into mpp7191 VALUES (1,'2007-01-01','M','11','QA','2001-02-16 20:38:40');
{code}
pg_dumpall > ./cdbfast_pgbkup/bkupall
psql -d gptest -f ./cdbfast_pgbkup/bkupall
ERROR: Append-Only relation 'mpp7191' gp_relation_node entry for segment file
#1 without an aoseg entry (case #2) (cdbdatabaseinfo.c:1537)
> Create Parquet table and insert data in template1 would cause CREATE DATABASE
> fail.
> -----------------------------------------------------------------------------------
>
> Key: HAWQ-147
> URL: https://issues.apache.org/jira/browse/HAWQ-147
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Command Line Tools
> Reporter: Dong Li
> Assignee: Lirong Jian
>
> Follow are the steps to reproduce this issue:
> $ psql -d template1
> psql (8.2.15)
> Type "help" for help.
> template1=# CREATE TABLE foo (
> template1(# a INT)
> template1-# WITH (appendonly=true, orientation=parquet);
> CREATE TABLE
> template1=# INSERT INTO foo VALUES(1);
> INSERT 0 1
> template1=# CREATE DATABASE gptest;
> ERROR: Append-Only relation 'foo' gp_relation_node entry for segment file #1
> without an aoseg entry (case #2) (cdbdatabaseinfo.c:1554)
> template1=#
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
