BUG #16750: VACUUM sporadically fails to access pgstat on Cygwin

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: exclusion(at)gmail(dot)com
Subject: BUG #16750: VACUUM sporadically fails to access pgstat on Cygwin
Date: 2020-11-29 05:00:01
Message-ID: 16750-c08c3649092a21c8@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16750
Logged by: Alexander Lakhin
Email address: exclusion(at)gmail(dot)com
PostgreSQL version: 12.5
Operating system: Windows (Cygwin)
Description:

As the buildfarm shows ([1], [2], [3]), VACUUM (and CREATE INDEX) from time
to time can produce the following warnings (that leads to test failures):
https://buildfarm.postgresql.org/cgi-bin/show_stage_log.pl?nm=lorikeet&dt=2020-09-07%2020%3A31%3A16&stg=install-check-C
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=lorikeet&dt=2019-10-27%2009%3A36%3A07

pg_regress/vacuum WARNING: could not open statistics file
"/cygdrive/w/lorikeet/REL_12_STABLE/global.stat": Permission denied
pg_regress/create_index WARNING: could not open statistics file
"/cygdrive/w/lorikeet/REL_13_STABLE/global.stat": Device or resource busy

The issue with the "Permission denied" error is already resolved for Windows
(see bug #16161), but cygwin still suffers from it.

[1]
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=lorikeet&dt=2020-06-04%2003%3A51%3A45
[2]
https://buildfarm.postgresql.org/cgi-bin/show_stage_log.pl?nm=lorikeet&dt=2020-08-17%2008%3A28%3A25&stg=install-check-C
[3]
https://buildfarm.postgresql.org/cgi-bin/show_stage_log.pl?nm=lorikeet&dt=2020-09-02%2008%3A28%3A53&stg=install-check-C

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexander Lakhin 2020-11-29 06:00:00 Re: BUG #16750: VACUUM sporadically fails to access pgstat on Cygwin
Previous Message Tom Lane 2020-11-29 02:59:06 Re: BUG #16746: [PG12.5 psql] Password ignored by connect meta-command