log_alert_history: new partition overlaps existing partition

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:

Overview

GPCC log will report error as below:

g2018-05-13 17:17:57|:-LOG: check partitions on log_alert_history 
2018-05-13 17:17:57|:-LOG: Add partition table 'alter table log_alert_history add partition start ('2018-06-01 00:00:00'::timestamp without time zone) inclusive end ('2018-07-01 00:00:00'::timestamp without time zone) exclusive; 
2018-05-13 17:17:57|:-WARNING: [gpmondb.c:777] partition add response from server: ERROR: new partition overlaps existing partition 

Checklist

• Check if timezone was changed recently
• Check the existing partition for log_alert_history by the following

SELECT partitionboundary, partitiontablename, partitionname, 
partitionlevel, partitionrank 
FROM pg_partitions 
WHERE tablename='log_alert_history';

Environment

Resolution

Workaround

Follow Guide to split/drop/recreate existing partitions to solve the overlap issue. 

http://gpdb.docs.pivotal.io/570/admin_guide/ddl/ddl-partition.html#topic77