| From: | Bo Thorbjørn Jensen <bo(at)budget123(dot)dk> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | some useless files may be left behind ? |
| Date: | 2015-04-30 11:13:36 |
| Message-ID: | AD7252BEFBCA3846A8D34ABCDA258D08548DA1DF@EXMBX04.mailcloud.dk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabio Ugo Venchiarutti | 2015-04-30 13:02:15 | Re: PostgreSQL HA config recommendations |
| Previous Message | Mitu Verma | 2015-04-30 10:58:27 | Re: clearing of the transactions shown in pg_locks |