worker process: dtx recovery process exited with exit code 1

Products

• VMware Tanzu Greenplum
• VMware Tanzu Greenplum / Gemfire
• VMware Tanzu Data Suite
• VMware Tanzu Data Suite

Issue/Introduction

The worker processes report that they are exiting frequently. Messages like the following are seen regularly:

2025-11-03 08:52:19.041566 GMT,,,p1931148,th-1114422656,,,,0,,,seg-1,,,,,"LOG","00000","worker process: dtx recovery process (PID 2580749) exited with exit code 1",,,,,,,0,,"postmaster.c",3997,
2025-11-03 08:52:19.041643 GMT,,,p1931148,th-1114422656,,,,0,,,seg-1,,,,,"LOG","00000","worker process: ftsprobe process (PID 2581060) exited with exit code 1",,,,,,,0,,"postmaster.c",3997,
2025-11-03 08:52:19.043454 GMT,,,p1931148,th-1114422656,,,,0,,,seg-1,,,,,"LOG","00000","worker process: ic proxy process (PID 2381690) exited with exit code 1",,,,,,,0,,"postmaster.c",3997,
2025-11-03 08:52:19.048863 GMT,,,p1931148,th-1114422656,,,,0,,,seg-1,,,,,"LOG","00000","worker process: sweeper process (PID 2381691) exited with exit code 1",,,,,,,0,,"postmaster.c",3997,

Cause

The processes are most likely being killed by the "kill" command and they are being restarted automatically by postgres.

There may be a script that is trying to clean up old connections or processes and it is killing the worker processes incorrectly.

Resolution

You need to find the script/cronjob or user that is killing the processes and correct the script to avoid kill the worker processes.