March 2016 - v1.0

gpcheckintegrity

Utility for Greenplum Database that performs a table integrity exam to verify that all the tables in a specific database can be queried.

Purpose

The purpose of this tool is to be able to detect when any of the segments in Greenplum have a bad copy of a table file(s). This is an issue that can happen when there is disk corruption in any of the nodes of the cluster and a disk repair utility is ran (i.e. xfs_repair, fsck)

How does it work

This tool will go through each and every table of a specific database and perform a PostgreSQL COPY command to in all segments to verify the table can be queried in the whole cluster.

COPY example_table TO '/dev/null'

Usage

gpcheckintegrity [-v | --verbose] [-s | --schema <schema_name> ] {-d | --database} <database> | -A

gpcheckintegrity -h | -? | --help

EXAMPLES

Check all the tables in all databases:

gpcheckintegrity -A

Check the integrity of all the tables in the database 'sales':

gpcheckintegrity -d sales

Check the integrity of all the tables in 'division_1' from DB 'sales':

gpcheckintegrity -s division_1 -d sales

Display help message:

gpcheckintegrity -h