storage_rca_collector

This tool collects storage-related table data and generates an output file which can be provided to VMware Customer Support for diagnosis of storage-related errors or system failures.

Usage

  1. storage_rca_collector [-db <database> ] [-t <table> ] | -c <ID1,ID2,...> ] [-dir <path> ] [-a] [-translog ]

Options

-db

The database name.

-t

The table name.

-c

Comma separated list of content IDs to collect logs from.

-dir

The output directory. Defaults to the current directory.

-a

Answer Yes to all prompts.

-translog

Specifies that the tool should collect transaction log data.

The tool also collects the following information:

  • Output from:

    • pg_class
    • pg_stat_last_operation
    • gp_distributed_log
    • pg_appendonly

  • Data from transaction logs, if you call this tool with the -translog option

  • AOCO data for a given appendonly, column-oriented table

  • AO data for a given appendonly table

Note

Some commands might not be able to be run if the user does not have correct permissions.

Examples

Collect storage root cause analysis artifacts only for master, database postgres, and table test_table:

  1. gpmt storage_rca_collector -db postgres -t test_table

Collect storage root cause analysis artifacts for primary segment with contentid [0,1], database postgres, and table test_table:

  1. gpmt storage_rca_collector -db postgres -c 0,1 -t test_table

Collect storage root cause analysis artifacts for primary segment with contentid [0,1], database postgres, and table test_table, with prompt deactivated:

  1. gpmt storage_rca_collector -db postgres -c 0,1 -t test_table -a

Collect storage rca artifacts for primary segment with contentid [0,1], database postgres, and table test_table and also collect transaction logs:

  1. gpmt storage_rca_collector -db postgres -c 0,1 -t test_table -transLog

Collect storage rca artifacts for primary segment with contentid [0,1], database postgres and table test_table and output to a specified directory location.

  1. gpmt storage_rca_collector -db postgres -c 0,1 -t test_table -dir <dir>

Note

Output files follow the naming convention <database name>_<dbid>_<artifact name>.