diskquota does not load and the database failed to start

Products

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

Issue/Introduction

When installing diskquota, after the third step of adding the diskquota shared library:

$ gpconfig -s shared_preload_libraries
Values on all segments are consistent
GUC              : shared_preload_libraries
Coordinator value: auto_explain
Segment     value: auto_explain
$ gpconfig -c shared_preload_libraries -v 'auto_explain,diskquota-2.3'
$ gpstop -ar

 

When starting the database the following error reports:

"FATAL","XX000","incompatible library ""/usr/local/greenplum-db/lib/postgresql/diskquota-2.3.so"": version mismatch","Server is version Greenplum 7, library is version Greenplum 7.5.",,,,,,,"incompatible_module_error","dfmgr.c",378,1    0xd117bc postgres errstart (elog.c:494)

Resolution

Workaround

Remove "diskquota-2.3' from the postgresql.conf file on coordinator and all segments with the following steps:

Edit the file $COORDINATOR_DATA_DIRECTORY/postgresql.conf and remove the library from the line:

shared_preload_libraries = 'auto_explain,diskquota-2.3'

Change shared_preload_libraries to the original setting, example:

shared_preload_libraries = 'auto_explain'

Start the db in master only mode:

gpstart -ma

Change the parameter to its original setting on all segments:

gpconfig -c shared_preload_libraries -v 'auto_explain' 

Restart the database into normal mode:

gpstop -arf

Fix

This is a known issue that is fixed in Greenplum Database version 7.5.3

N/A
Resolves a library version mismatch issue in diskquota that prevented the extension from loading into the database.