Disk Space is filling up with pgsql_tmp files in the /db/controldb/data/base/ directory

Products

• VMware Smart Assurance

Issue/Introduction

Disk/DB size is getting filed up by pgsql_tmp file rapidly, and lot of temporary file are present in <NCM>/db/controldb/data/base/ directory like below:

-rw------- 1 pgdba pgdba 1073741824 Sep 16 04:10 pgsql_tmp12722.2215
-rw------- 1 pgdba pgdba 1073741824 Sep 16 04:11 pgsql_tmp12722.2216
-rw------- 1 pgdba pgdba 1073741824 Sep 16 04:13 pgsql_tmp12722.2217
-rw------- 1 pgdba pgdba 1073741824 Sep 16 04:14 pgsql_tmp12722.2218
-rw------- 1 pgdba pgdba 1073741824 Sep 16 04:15 pgsql_tmp12722.2219
-rw------- 1 pgdba pgdba 1073741824 Sep 16 04:17 pgsql_tmp12722.2220
-rw------- 1 pgdba pgdba 1073741824 Sep 16 04:18 pgsql_tmp12722.2221
-rw------- 1 pgdba pgdba 1073741824 Sep 16 04:19 pgsql_tmp12722.2222
-rw------- 1 pgdba pgdba 1073741824 Sep 16 04:20 pgsql_tmp12722.2223
-rw------- 1 pgdba pgdba 1073741824 Sep 16 04:21 pgsql_tmp12722.2224
-rw------- 1 pgdba pgdba 1073741824 Sep 16 04:22 pgsql_tmp12722.2225
-rw------- 1 pgdba pgdba 1073741824 Sep 16 04:23 pgsql_tmp12722.2226

Environment

NCM 10.1.X

Cause

pgsql_tmp is a Temporary tablespace. This directory contains temporary files generated by the query executor. 

 

These should be deleted once the query is done.

Resolution

Execute the following command to restart the controldb service, in order to delete these temporary files and free up disk space:

service controldb restart