Pivotal Knowledge Base

Follow

When connected to GPDB, the DataDirect JDBC 5.1.1/5.1.3 driver generates a huge temp file at /tmp

Environment

Product Version
Pivotal Greenplum (GPDB) 4.3.x
OS RHEL 6.x
Progress DataDirect  5.1.1, 5.1.3

Symptom

When connected to GPDB using the DataDirect JDBC 5.1.1/5.1.3 driver, it will generate a huge temp file at /tmp/ directory. Each file has a size of around 7-10 GB. The temp file name is usually something similar to ddtbxxxx.tmp.

Cause

Temp files ddtb*.tmp are not cleaned up automatically when an application exits. When files are created on large queries where the temp buffer is filled, the overflow is written to disk.

Resolution

According to Progress, this is a known issue and is fixed in the hotfix 5.1.3.000090 and the formal release of version 5.1.4 which can be downloaded from the Pivotal network here.  

For further explanation from Progress, please refer to this link. 

Comments

Powered by Zendesk