GreenPlum 6.26新增gpmt排查工具

AiDBA宝典

发布于 2023-12-26 11:24:29

2310

发布于 2023-12-26 11:24:29

文章被收录于专栏：小麦苗的DB宝专栏

简介

在GP 6.26中的新增工具gpmt，GPMT (Greenplum Magic Tool)提供了一套诊断应用工具来排查和解决常见的可支持性问题，并提供了一种一致的方法来收集VMware支持所需的信息。

gpdb 6.26.1环境

docker rm -f gpdb6261
docker run -itd --name gpdb6261 -h gpdb6261 \
  -p 5631:5432 -p 26088:28080  \
  -v /sys/fs/cgroup:/sys/fs/cgroup \
  --privileged=true lhrbest/greenplum:6.26.1 \
  /usr/sbin/init

docker exec -it gpdb6261 bash

su - gpadmin


gpstart -a
gpcc start

帮助

[gpadmin@gpdb6261 ~]$ gpmt -h

USAGE:
    gpmt tool [ tool_options... ]
        [ -hostfile FILE ] [ -help ] [ -verbose ]

TOOLS:
    GPDB
        analyze_session          Collect information from a hung GPDB session for remote analysis 
        catalogbackup            Backup catalog prior to performing catalog repairs
        gp_log_collector         Basic GPDB log collection utility
        gpcheckcat               GPDB gpcheckcat log analysis
        gpcheckup                GPDB Health Check
        gpstatscheck             Check for missing stats on objects used in a query
        packcore                 Package core files into single tarball for remote analysis
        primarymirror_lengths    Check if primary and mirror AO and AOCO relfiles are the correct lengths
        storage_rca_collector    Storage rca artifacts collection utility
        tablecollect             Collect data and index files for data corruption RCA

    MISC
        hostfile                 Generate hostfiles for use with gpmt, gpssh, etc...
        replcheck                Check if tool is replicated to all hosts
        replicate                Replicate tool to all hosts
        version                  Displays GPMT version

GLOBAL OPTIONS:
    -hostfile       Hostfile
    -help           Show help
    -verbose        Verbose

EXAMPLES:
    Display gpmt version:
        gpmt version

    Collect a core file:
        gpmt packcore -cmd collect -core core.1234

    Show help for a specific tool:
        gpmt gp_log_collector -help

[gpadmin@gpdb6261 ~]$