Master Panics after enabling SSL on Greenplum 7.3 on RHEL 9.5

Products

• VMware Tanzu Greenplum
• Greenplum

Issue/Introduction

After  enabling SSL on Greenplum 7.3  and restarting the Database the master Panics.  

Environment

RHEL 9.5 comes with OpenSSL 3.2.2, 

Will not Occur on RHEL 9.0 as this provides OpenSSL 3.0.1 

Cause

 SSL = ON in postgresql.conf in Greenplum 7.3.2. on RHEL9:

 

1.After enabling SSL in Greenplum 7, The master panicked with the following error 

2024-11-25 14:33:25.988047 CET,,,p302503,th-1558148928,"127.0.0.1","30610",2024-11-25 14:33:25 CET,0,,,seg-1,,,,,"LOG","XX000","could not accept SSL connection: Socket operation on non-socket",,,,,,,0,,"be-secure-openssl.c",457,

2024-11-25 14:33:25.990262 CET,,,p302504,th-1558148928,"127.0.0.1","30624",2024-11-25 14:33:25 CET,0,,,seg-1,,,,,"FATAL","28000","no PostgreSQL user name specified in startup packet",,,,,,,0,,"postmaster.c",2662,

2024-11-25 14:33:40.971855 CET,,,p302515,th-1558148928,,,,0,con6,,seg-1,,,,sx1,"FATAL","57P03","the database system is in recovery mode","waiting for distributed transaction recovery to complete",,,,,,0,,"cdbutil.c",1239,

 

Resolution

Workaround downgrade from OpenSSL 3.2.2-6 to 3.0.7-28.

Fix will be in 7.4.0. 

Additional Information

This requires a small code change to resolve, This was only highlighted when OpenSSL changed to 3.2.2.