vacuum fails with "could not open statistics file" "Device orresource busy" - Mailing list pgsql-hackers

From Andres Freund
Subject vacuum fails with "could not open statistics file" "Device orresource busy"
Date
Msg-id 20181020021514.jqw4a5vdpntzab2x@alap3.anarazel.de
Whole thread Raw
Responses Re: vacuum fails with "could not open statistics file" "Device orresource busy"  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Re: vacuum fails with "could not open statistics file" "Device orresource busy"  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Hi,

buildfarm member lorikeet had an interesting buildfarm failure in the
logical decoding test. The failure looks unrelated to logical decoding,
but might be more widely relevant:

https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=lorikeet&dt=2018-10-19%2011%3A22%3A34
  VACUUM FULL pg_class;
+ WARNING:  could not open statistics file "pg_stat_tmp/global.stat": Device or resource busy

Now that animal is cygwin based, so maybe it's just some random
weirdness. But ISTM it could also indicate a bug of some sort.

Were it native windows, I'd assume we'd keep a file open with the wrong
flags or such...

Greetings,

Andres Freund


pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: WAL archive (archive_mode = always) ?
Next
From: Michael Paquier
Date:
Subject: Re: pgsql: Add TAP tests for pg_verify_checksums