[HAWQ-54] TID for persistent 'Relation File...' tuple is invalid

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: backlog
• Component/s: Catalog
• Assignee: Ming Li
• Reporter: Goden Yao
• Created: 13/Oct/15 18:04
• Updated: 24/Jan/16 02:09

Description

Inserting `\c – Fresh session`:
./cdb-pg/src/test/regress/input/external_oid.source

 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();

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:

============== 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"