some useless files may be left behind ? - Mailing list pgsql-general

From Bo Thorbjørn Jensen
Subject some useless files may be left behind ?
Date
Msg-id AD7252BEFBCA3846A8D34ABCDA258D08548DA1DF@EXMBX04.mailcloud.dk
Whole thread Raw
List pgsql-general

Hi All,

 

We have a cluster on windows 2008 server “PostgreSQL 9.1.15, compiled by Visual C++ build 1500, 64-bit”

After trying to create new databases concurrently npgsql endpoint reached default commandtimeout (20 seconds).

 

This results in following log entries on the server:

2015-04-30 08:47:14 CEST WARNING:  could not remove file or directory "base/64111031": Directory not empty

2015-04-30 08:47:14 CEST WARNING:  some useless files may be left behind in old database directory "base/64111031"

2015-04-30 08:47:14 CEST ERROR:  canceling statement due to user request

2015-04-30 08:47:14 CEST STATEMENT:  CREATE DATABASE database WITH ENCODING='UTF8' OWNER=owner TEMPLATE=custom_template

 

The directory is empty now.

Question is, will auto vacuum clean this up eventually?

Should I be concerned ?

 

Any thoughts or comments are appreciated. Thanks!

 

Bo Thorbjørn Jensen

pgsql-general by date:

Previous
From: Mitu Verma
Date:
Subject: Re: clearing of the transactions shown in pg_locks
Next
From: Fabio Ugo Venchiarutti
Date:
Subject: Re: PostgreSQL HA config recommendations