Skip to content

pg_probackup hangs on validating backups #272

Closed
@juergennagel

Description

@juergennagel

When running "pg_probackup validate" the process hangs with 100% cpu usage after validating a couple of backups.

# pg_probackup-12 version
pg_probackup-12 2.4.4 (PostgreSQL 12.4)
# pg_probackup-12 validate  -B /mnt/backups/pg_probackup/ --instance asp5-intrafox-cluster --pgdatabase=postgres --progress -j 2
....
INFO: Progress: (9807/9808). Validate file "backup_label"
INFO: Progress: (9808/9808). Validate file "database_map"
INFO: Backup QIQN21 data files are valid
INFO: Backup QIQN21 WAL segments are valid
PID     USER      PRI  NI  VIRT   RES   SHR S CPU% MEM%    DISK R/W   TIME+  Command
1325575 root       20   0  198M  1112  1112 R 100.  0.0    0.00 B/s 25h14:41 pg_probackup-12 validate -B /mnt/backups/pg_probackup/ --instance asp5-intrafox-cluster --pgdatabase=postgres --progress -j 2
Snapshot of files open in process 1325575 - pg_probackup-12 validate -B /mnt/backups/pg_probackup/ --instance asp5-intrafox-cluster --pgdatabase=postgres --progress -j 2
   FD TYPE     DEVICE       SIZE       NODE NAME
    0     CHR       0x17                     7 /dev/pts/4
    1     CHR       0x17                     7 /dev/pts/4
    2     CHR       0x17                     7 /dev/pts/4
  cwd     DIR      0x801       4096         23 /root
  mem     REG      0x801      16320       5245 /usr/lib64/libkeyutils.so.1.6
  mem     REG      0x801      17336       4551 /usr/lib64/libcom_err.so.2.1
  mem     REG      0x801      36824       3666 /usr/lib64/libdl-2.28.so
  mem     REG      0x801      71648       9917 /usr/lib64/libkrb5support.so.0.1
  mem     REG      0x801      95400       4506 /usr/lib64/libz.so.1.2.11
  mem     REG      0x801      97048       9506 /usr/lib64/liblber-2.4.so.2.10.9
  mem     REG      0x801      98680       3682 /usr/lib64/librt-2.28.so
  mem     REG      0x801     117216       9909 /usr/lib64/libk5crypto.so.3.1
  mem     REG      0x801     130176       9493 /usr/lib64/libsasl2.so.3.0.0
  mem     REG      0x801     142528       3680 /usr/lib64/libresolv-2.28.so
  mem     REG      0x801     144568       4605 /usr/lib64/libcrypt.so.1.1.0
  mem     REG      0x801     302552       3657 /usr/lib64/ld-2.28.so
  mem     REG      0x801     304848       3260 /usr/lib64/libselinux.so.1
  mem     REG      0x801     330624     263584 /usr/pgsql-12/lib/libpq.so.5.12
  mem     REG      0x801     335032       9905 /usr/lib64/libgssapi_krb5.so.2.2
  mem     REG      0x801     470312       3678 /usr/lib64/libpthread-2.28.so
  mem     REG      0x801     529912       9510 /usr/lib64/libldap_r-2.4.so.2.10.9
  mem     REG      0x801     553480       3246 /usr/lib64/libpcre2-8.so.0.7.1
  mem     REG      0x801     615504      10855 /usr/lib64/libssl.so.1.1.1c
  mem     REG      0x801     997600       9915 /usr/lib64/libkrb5.so.3.3
  mem     REG      0x801    3058736      10853 /usr/lib64/libcrypto.so.1.1.1c
  mem     REG      0x801    4176104       3664 /usr/lib64/libc-2.28.so
  rtd     DIR      0x801       4096          2 /
  txt     REG      0x801     416576       5723 /usr/bin/pg_probackup-12

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions