[jira] [Assigned] (HAWQ-54) TID for persistent 'Relation File...' tuple is invalid

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

     [ https://issues.apache.org/jira/browse/HAWQ-54?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Lirong Jian reassigned HAWQ-54:
-------------------------------

    Assignee: Lirong Jian

> TID for persistent 'Relation File...' tuple is invalid
> ------------------------------------------------------
>
>                 Key: HAWQ-54
>                 URL: https://issues.apache.org/jira/browse/HAWQ-54
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: Catalog
>            Reporter: Goden Yao
>            Assignee: Lirong Jian
>
> Inserting `\c -- Fresh session`:
> ./cdb-pg/src/test/regress/input/external_oid.source
> {code:sql}
>  57 -- --------------------------------------
>  58 -- Create a tuple with Oid larger than FirstExternalObjectId (4293918720)
>  59 -- --------------------------------------
>  60 SELECT caql_insert_into_heap_pg_class(4293918750, 'table_xl');
>  61
>  62 \c -- Fresh session
>  63 -- NextExternalObjectId is uninitialized
>  64 SELECT next_external_oid();
> {code}
> Causes test to fail (as expected, as I later find out '--' comment does not work for \c), AND puts database 'regression' in a bad state (not expected). When I try to run subsequent tests which attempts to drop database 'regression', the following error prints out:
> {code:sql}
> ============== dropping database "regression"         ==============
> ERROR:  TID for persistent 'Relation File: '131072/54992/167 (segment file #0)'' tuple is invalid (0,0) (index 0, transaction kind 'Commit') (persistentendxactrec.c:249)
> command failed: "/home/gpadmin/greenplum-db-devel/bin/psql" -X -c "DROP DATABASE IF EXISTS \"regression\"" "postgres"
> {code}



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