Re: Intermittent pg_ctl failures on Windows

From: r(dot)zharkov(at)postgrespro(dot)ru
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Badrul Chowdhury <bachow(at)microsoft(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Intermittent pg_ctl failures on Windows
Date: 2019-07-19 08:35:42
Message-ID: 9c09a0b8b0effc6d2dd6b4f11d623c7e@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

I have reproduced the CMD.EXE error "The process cannot access the file
because it is being used by another process" the REL_12_STABLE.
I simply launched my dummy TAP test and I got «Процесс не может получить
доступ к файлу, так как этот файл занят другим процессом.»
( “The process cannot access the file because it is being used by
another process” in english Windows version )

The pictures in the attachment illustrate the SHARING_VIOLATION error.

-------------------------------------------
# Postmaster PID for node "master" is 10456
# restarted 32
# 13:28:58
### Restarting node "master"
# Running: pg_ctl -D
C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/t_test_master_data/pgdata
-l C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/log/test_master.log
restart
waiting for server to shut down.... done
server stopped
waiting for server to start....Процесс не может получить доступ к файлу,
так как этот файл занят другим процессом.
stopped waiting
pg_ctl: could not start server
Examine the log output.
Bail out! system pg_ctl failed
### Stopping node "master" using mode immediate
# Running: pg_ctl -D
C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/t_test_master_data/pgdata
-m immediate stop
pg_ctl: PID file
"C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/t_test_master_data/pgdata/postmaster.pid"
does not exist
Is server running?
Bail out! system pg_ctl failed
------------------------------------------

--
regards, Roman

Attachment Content-Type Size
test.pl text/plain 1.2 KB
sharing_violation.PNG image/png 242.5 KB
process_tree.PNG image/png 182.3 KB
regress_log_test text/plain 16.8 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2019-07-19 08:52:20 Re: partition routing layering in nodeModifyTable.c
Previous Message r.zharkov 2019-07-19 08:24:25 Re: Intermittent pg_ctl failures on Windows