Greenplum Streaming Server job reading from RabbitMQ is not working but not marked as failed.

Products

• VMware Tanzu Greenplum
• Greenplum
• VMware Tanzu Data Suite
• VMware Tanzu Data Suite

Issue/Introduction

If the connection between Greenplum Streaming Server(GPSS) and a RabbitiMQ stream breaks while the job is running, the GPSS server might not detect that the connection has stopped working and the job does not get marked as failed.

The GPSS job will just continue to wait for new messages and show as "JOB_RUNNING" in the "gpsscli list" output.

$ gpsscli list --all
JobName                              JobID                                GPHost           GPPort   DataBase         Schema           Table                            Topic            Status  
rabbitJob                            da47273bc36821c6ad515736cbdb0b4c     cdw              5432     mydb             public           gpss_test_int_int_text                            JOB_RUNNING(on job is running)

Cause

The GPSS job just waits for new messages from RabbitMQ and never checks if the connection between GPSS and RabbitMQ stream is still operational or if it has been closed.

Resolution

Workaround

Restart the GPSS job.

Fix

As of March 2025, a code fix is being developed and will be delivered in a maintenance release.