SMARTS NCM: The disk is filling up with pgsql_tmp files in <NCM>/db/controldb/data/base/ directory

Products

• VMware Smart Assurance

Issue/Introduction

Symptoms:


Disk is getting filed up by pgsql_tmp file rapidly

DB size is increasing and lot of temporary file are present in <NCM>/db/controldb/data/base/ directory

-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

VMware Smart Assurance - NCM

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