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

["Goden Yao (JIRA)" <ji...@apache.org>]

Goden Yao created HAWQ-54:
-----------------------------

             Summary: 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


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)