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)
