Unable to drop Diskquota Extension due to no response from Diskquota launcher
search cancel

Unable to drop Diskquota Extension due to no response from Diskquota launcher

book

Article ID: 296719

calendar_today

Updated On:

Products

VMware Tanzu Greenplum

Issue/Introduction

Sometimes when the Diskquota launcher process exits unexpectedly, when this happens attempting to drop the Diskquota Extension can fail with the errors below:
 

2021-12-18 16:52:09.084698 EST,,,p204025,th1810520000,,,,0,con218,cmd1,seg-1,,,,sx1,"ERROR","XX000","[diskquota launcher] start worker process of database(oid:16384) failed",,,,,,,0,,"diskquota.c",645,"Stack trace: 2 0x7ff35e740266 diskquota.so disk_quota_launcher_main + 0x756 2021-12-18 16:52:09.092335 EST,,,p199369,th1810520000,,,,0,,,seg-1,,,,,"LOG","00000","worker process: [diskquota] - launcher (PID 204025) exited with exit code 1",,,,,,,0,,"postmaster.c",3948, 
ERROR: [diskquota launcher] failed to drop diskquota extension: no response from diskquota launcher, check whether launcher process exists (diskquota_utility.c:337)



Environment

Product Version: 6.17

Resolution

1) First, remove "diskquota" from the GUC 'shared_preload_libraries' using gpconfig
2) Restart GPDB
3) After restart some cleanup is needed: 'DROP EXTENSION diskquota;' for each database that contains the extension.
4) Finally run 'DROP DATABASE diskquota;' to fully drop the database associated with the extension