some useless files may be left behind ?

Started by Bo Thorbjørn Jensenalmost 11 years ago1 messagesgeneral

bo@budget123.dk

almost 11 years ago

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