pg.ddx.io pgsql-hackers@postgresql.org mailing list archive help / color / mirror / Atom feed From: r.zharkov@postgrespro.ru
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: Badrul Chowdhury <bachow@microsoft.com>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: Intermittent pg_ctl failures on Windows
Date: Fri, 19 Jul 2019 15:35:42 +0700
Message-ID: <9c09a0b8b0effc6d2dd6b4f11d623c7e@postgrespro.ru> (raw )
In-Reply-To: <1580.1563512383@sss.pgh.pa.us >
References: <16922.1520722108@sss.pgh.pa.us >
<DM5PR2101MB0984D3DB39BCCCF189ECD15ED1D30@DM5PR2101MB0984.namprd21.prod.outlook.com >
<0057a0ce5a8893e4713a9a9d7e352162@postgrespro.ru >
<26631.1563371508@sss.pgh.pa.us >
<3b46fc8be044c79b5eff7d26c810d2fd@postgrespro.ru >
<20190718085148.GI1416@paquier.xyz >
<B9F855CF-1756-40FA-B9AF-1F48A9480269@postgrespro.ru >
<20190719030208.GG1859@paquier.xyz >
<1580.1563512383@sss.pgh.pa.us >
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
use strict;
use warnings;
use PostgresNode;
use TestLib;
use Test::More;
use Config;
my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime();
my $node = get_new_node('master');
$node->init();
$node->start;
diag( $node->safe_psql('postgres', 'select version();') . "\n" );
$node->command_ok(
[ qw(pgbench --initialize --scale=10) ],
'pgbench finished without errors');
#$node->stop;
for ( my $i = 0; $i < 100000; $i++ ) {
# $node->start;
# diag( "started $i (1)\n" );
# $node->command_ok(
# [ qw(pgbench --progress=5 --transactions=1000 --jobs=5 --client=5) ],
# 'pgbench finished without errors');
# $node->stop;
# diag( "stopped $i (1)\n" );
# $node->start;
# diag( "started $i (2)\n" );
# $node->command_ok(
# [ qw(pgbench --progress=5 --transactions=10 --jobs=5 --client=5) ],
# 'pgbench finished without errors');
$node->restart;
diag( "restarted $i\n" );
# $node->command_ok(
# [ qw(pgbench --progress=5 --transactions=1000 --jobs=5 --client=5) ],
# 'pgbench finished without errors');
# $node->stop;
# diag( "stopped $i (2)\n" );
($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime();
diag( sprintf("%02d:%02d:%02d", $hour, $min, $sec) );
}
ok( 1 eq 1, 'dummy test' );
done_testing();
# Checking port 65175
# Found port 65175
Name: master
Data directory: C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/t_test_master_data/pgdata
Backup directory: C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/t_test_master_data/backup
Archive directory: C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/t_test_master_data/archives
Connection string: port=65175 host=127.0.0.1
Log file: C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/log/test_master.log
# Running: initdb -D C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/t_test_master_data/pgdata -A trust -N
The files belonging to this database system will be owned by user "Roman".
This user must also own the server process.
The database cluster will be initialized with locale "Russian_Russia.1251".
The default database encoding has accordingly been set to "WIN1251".
The default text search configuration will be set to "russian".
Data page checksums are disabled.
creating directory C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/t_test_master_data/pgdata ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... windows
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Asia/Barnaul
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
Sync to disk skipped.
The data directory might become corrupt if the operating system crashes.
Success. You can now start the database server using:
pg_ctl -D C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/t_test_master_data/pgdata -l logfile start
# Running: C:/HOME/Git/postgrespro/Release/pg_regress/pg_regress --config-auth C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/t_test_master_data/pgdata
### Starting 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 -o --cluster-name=master start
waiting for server to start.... done
server started
# Postmaster PID for node "master" is 15408
# PostgreSQL 12beta2, compiled by Visual C++ build 1800, 64-bit
# Running: pgbench --initialize --scale=10
dropping old tables...
NOTICE: table "pgbench_accounts" does not exist, skipping
NOTICE: table "pgbench_branches" does not exist, skipping
NOTICE: table "pgbench_history" does not exist, skipping
NOTICE: table "pgbench_tellers" does not exist, skipping
creating tables...
generating data...
100000 of 1000000 tuples (10%) done (elapsed 0.03 s, remaining 0.31 s)
200000 of 1000000 tuples (20%) done (elapsed 0.08 s, remaining 0.33 s)
300000 of 1000000 tuples (30%) done (elapsed 0.16 s, remaining 0.37 s)
400000 of 1000000 tuples (40%) done (elapsed 0.20 s, remaining 0.30 s)
500000 of 1000000 tuples (50%) done (elapsed 0.22 s, remaining 0.22 s)
600000 of 1000000 tuples (60%) done (elapsed 0.43 s, remaining 0.29 s)
700000 of 1000000 tuples (70%) done (elapsed 0.46 s, remaining 0.20 s)
800000 of 1000000 tuples (80%) done (elapsed 0.49 s, remaining 0.12 s)
900000 of 1000000 tuples (90%) done (elapsed 0.52 s, remaining 0.06 s)
1000000 of 1000000 tuples (100%) done (elapsed 0.99 s, remaining 0.00 s)
vacuuming...
creating primary keys...
done.
ok 1 - pgbench finished without errors
### 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.... done
server started
# Postmaster PID for node "master" is 4256
# restarted 0
# 13:28:28
### 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.... done
server started
# Postmaster PID for node "master" is 4680
# restarted 1
# 13:28:29
### 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.... done
server started
# Postmaster PID for node "master" is 18312
# restarted 2
# 13:28:30
### 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.... done
server started
# Postmaster PID for node "master" is 6420
# restarted 3
# 13:28:30
### 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.... done
server started
# Postmaster PID for node "master" is 14540
# restarted 4
# 13:28:31
### 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.... done
server started
# Postmaster PID for node "master" is 18392
# restarted 5
# 13:28:32
### 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.... done
server started
# Postmaster PID for node "master" is 13260
# restarted 6
# 13:28:33
### 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.... done
server started
# Postmaster PID for node "master" is 14828
# restarted 7
# 13:28:33
### 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.... done
server started
# Postmaster PID for node "master" is 14972
# restarted 8
# 13:28:34
### 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.... done
server started
# Postmaster PID for node "master" is 13132
# restarted 9
# 13:28:35
### 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.... done
server started
# Postmaster PID for node "master" is 15260
# restarted 10
# 13:28:36
### 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.... done
server started
# Postmaster PID for node "master" is 1144
# restarted 11
# 13:28:37
### 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.... done
server started
# Postmaster PID for node "master" is 17516
# restarted 12
# 13:28:38
### 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.... done
server started
# Postmaster PID for node "master" is 18012
# restarted 13
# 13:28:39
### 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.... done
server started
# Postmaster PID for node "master" is 17608
# restarted 14
# 13:28:40
### 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.... done
server started
# Postmaster PID for node "master" is 13464
# restarted 15
# 13:28:41
### 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.... done
server started
# Postmaster PID for node "master" is 976
# restarted 16
# 13:28:42
### 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.... done
server started
# Postmaster PID for node "master" is 8316
# restarted 17
# 13:28:43
### 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.... done
server started
# Postmaster PID for node "master" is 11776
# restarted 18
# 13:28:44
### 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.... done
server started
# Postmaster PID for node "master" is 14748
# restarted 19
# 13:28:45
### 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.... done
server started
# Postmaster PID for node "master" is 7976
# restarted 20
# 13:28:45
### 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.... done
server started
# Postmaster PID for node "master" is 14596
# restarted 21
# 13:28:46
### 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.... done
server started
# Postmaster PID for node "master" is 14020
# restarted 22
# 13:28:47
### 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.... done
server started
# Postmaster PID for node "master" is 10248
# restarted 23
# 13:28:48
### 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.... done
server started
# Postmaster PID for node "master" is 16264
# restarted 24
# 13:28:49
### 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.... done
server started
# Postmaster PID for node "master" is 2328
# restarted 25
# 13:28:51
### 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.... done
server started
# Postmaster PID for node "master" is 18072
# restarted 26
# 13:28:51
### 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.... done
server started
# Postmaster PID for node "master" is 1000
# restarted 27
# 13:28:53
### 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.... done
server started
# Postmaster PID for node "master" is 14972
# restarted 28
# 13:28:54
### 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.... done
server started
# Postmaster PID for node "master" is 7604
# restarted 29
# 13:28:55
### 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.... done
server started
# Postmaster PID for node "master" is 18336
# restarted 30
# 13:28:56
### 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.... done
server started
# Postmaster PID for node "master" is 8768
# restarted 31
# 13:28:57
### 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.... done
server started
# 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
Attachments:
[text/plain] test.pl (1.2K, ../9c09a0b8b0effc6d2dd6b4f11d623c7e@postgrespro.ru/2-test.pl)
download | inline:
use strict;
use warnings;
use PostgresNode;
use TestLib;
use Test::More;
use Config;
my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime();
my $node = get_new_node('master');
$node->init();
$node->start;
diag( $node->safe_psql('postgres', 'select version();') . "\n" );
$node->command_ok(
[ qw(pgbench --initialize --scale=10) ],
'pgbench finished without errors');
#$node->stop;
for ( my $i = 0; $i < 100000; $i++ ) {
# $node->start;
# diag( "started $i (1)\n" );
# $node->command_ok(
# [ qw(pgbench --progress=5 --transactions=1000 --jobs=5 --client=5) ],
# 'pgbench finished without errors');
# $node->stop;
# diag( "stopped $i (1)\n" );
# $node->start;
# diag( "started $i (2)\n" );
# $node->command_ok(
# [ qw(pgbench --progress=5 --transactions=10 --jobs=5 --client=5) ],
# 'pgbench finished without errors');
$node->restart;
diag( "restarted $i\n" );
# $node->command_ok(
# [ qw(pgbench --progress=5 --transactions=1000 --jobs=5 --client=5) ],
# 'pgbench finished without errors');
# $node->stop;
# diag( "stopped $i (2)\n" );
($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime();
diag( sprintf("%02d:%02d:%02d", $hour, $min, $sec) );
}
ok( 1 eq 1, 'dummy test' );
done_testing();
[image/png] sharing_violation.PNG (242.5K, ../9c09a0b8b0effc6d2dd6b4f11d623c7e@postgrespro.ru/3-sharing_violation.PNG)
download | view image
[image/png] process_tree.PNG (182.3K, ../9c09a0b8b0effc6d2dd6b4f11d623c7e@postgrespro.ru/4-process_tree.PNG)
download | view image
[text/plain] regress_log_test (16.8K, ../9c09a0b8b0effc6d2dd6b4f11d623c7e@postgrespro.ru/5-regress_log_test)
download | inline:
# Checking port 65175
# Found port 65175
Name: master
Data directory: C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/t_test_master_data/pgdata
Backup directory: C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/t_test_master_data/backup
Archive directory: C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/t_test_master_data/archives
Connection string: port=65175 host=127.0.0.1
Log file: C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/log/test_master.log
# Running: initdb -D C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/t_test_master_data/pgdata -A trust -N
The files belonging to this database system will be owned by user "Roman".
This user must also own the server process.
The database cluster will be initialized with locale "Russian_Russia.1251".
The default database encoding has accordingly been set to "WIN1251".
The default text search configuration will be set to "russian".
Data page checksums are disabled.
creating directory C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/t_test_master_data/pgdata ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... windows
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Asia/Barnaul
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
Sync to disk skipped.
The data directory might become corrupt if the operating system crashes.
Success. You can now start the database server using:
pg_ctl -D C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/t_test_master_data/pgdata -l logfile start
# Running: C:/HOME/Git/postgrespro/Release/pg_regress/pg_regress --config-auth C:/HOME/Git/postgrespro/src/test/pg_ctl/tmp_check/t_test_master_data/pgdata
### Starting 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 -o --cluster-name=master start
waiting for server to start.... done
server started
# Postmaster PID for node "master" is 15408
# PostgreSQL 12beta2, compiled by Visual C++ build 1800, 64-bit
# Running: pgbench --initialize --scale=10
dropping old tables...
NOTICE: table "pgbench_accounts" does not exist, skipping
NOTICE: table "pgbench_branches" does not exist, skipping
NOTICE: table "pgbench_history" does not exist, skipping
NOTICE: table "pgbench_tellers" does not exist, skipping
creating tables...
generating data...
100000 of 1000000 tuples (10%) done (elapsed 0.03 s, remaining 0.31 s)
200000 of 1000000 tuples (20%) done (elapsed 0.08 s, remaining 0.33 s)
300000 of 1000000 tuples (30%) done (elapsed 0.16 s, remaining 0.37 s)
400000 of 1000000 tuples (40%) done (elapsed 0.20 s, remaining 0.30 s)
500000 of 1000000 tuples (50%) done (elapsed 0.22 s, remaining 0.22 s)
600000 of 1000000 tuples (60%) done (elapsed 0.43 s, remaining 0.29 s)
700000 of 1000000 tuples (70%) done (elapsed 0.46 s, remaining 0.20 s)
800000 of 1000000 tuples (80%) done (elapsed 0.49 s, remaining 0.12 s)
900000 of 1000000 tuples (90%) done (elapsed 0.52 s, remaining 0.06 s)
1000000 of 1000000 tuples (100%) done (elapsed 0.99 s, remaining 0.00 s)
vacuuming...
creating primary keys...
done.
ok 1 - pgbench finished without errors
### 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.... done
server started
# Postmaster PID for node "master" is 4256
# restarted 0
# 13:28:28
### 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.... done
server started
# Postmaster PID for node "master" is 4680
# restarted 1
# 13:28:29
### 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.... done
server started
# Postmaster PID for node "master" is 18312
# restarted 2
# 13:28:30
### 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.... done
server started
# Postmaster PID for node "master" is 6420
# restarted 3
# 13:28:30
### 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.... done
server started
# Postmaster PID for node "master" is 14540
# restarted 4
# 13:28:31
### 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.... done
server started
# Postmaster PID for node "master" is 18392
# restarted 5
# 13:28:32
### 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.... done
server started
# Postmaster PID for node "master" is 13260
# restarted 6
# 13:28:33
### 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.... done
server started
# Postmaster PID for node "master" is 14828
# restarted 7
# 13:28:33
### 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.... done
server started
# Postmaster PID for node "master" is 14972
# restarted 8
# 13:28:34
### 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.... done
server started
# Postmaster PID for node "master" is 13132
# restarted 9
# 13:28:35
### 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.... done
server started
# Postmaster PID for node "master" is 15260
# restarted 10
# 13:28:36
### 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.... done
server started
# Postmaster PID for node "master" is 1144
# restarted 11
# 13:28:37
### 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.... done
server started
# Postmaster PID for node "master" is 17516
# restarted 12
# 13:28:38
### 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.... done
server started
# Postmaster PID for node "master" is 18012
# restarted 13
# 13:28:39
### 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.... done
server started
# Postmaster PID for node "master" is 17608
# restarted 14
# 13:28:40
### 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.... done
server started
# Postmaster PID for node "master" is 13464
# restarted 15
# 13:28:41
### 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.... done
server started
# Postmaster PID for node "master" is 976
# restarted 16
# 13:28:42
### 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.... done
server started
# Postmaster PID for node "master" is 8316
# restarted 17
# 13:28:43
### 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.... done
server started
# Postmaster PID for node "master" is 11776
# restarted 18
# 13:28:44
### 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.... done
server started
# Postmaster PID for node "master" is 14748
# restarted 19
# 13:28:45
### 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.... done
server started
# Postmaster PID for node "master" is 7976
# restarted 20
# 13:28:45
### 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.... done
server started
# Postmaster PID for node "master" is 14596
# restarted 21
# 13:28:46
### 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.... done
server started
# Postmaster PID for node "master" is 14020
# restarted 22
# 13:28:47
### 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.... done
server started
# Postmaster PID for node "master" is 10248
# restarted 23
# 13:28:48
### 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.... done
server started
# Postmaster PID for node "master" is 16264
# restarted 24
# 13:28:49
### 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.... done
server started
# Postmaster PID for node "master" is 2328
# restarted 25
# 13:28:51
### 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.... done
server started
# Postmaster PID for node "master" is 18072
# restarted 26
# 13:28:51
### 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.... done
server started
# Postmaster PID for node "master" is 1000
# restarted 27
# 13:28:53
### 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.... done
server started
# Postmaster PID for node "master" is 14972
# restarted 28
# 13:28:54
### 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.... done
server started
# Postmaster PID for node "master" is 7604
# restarted 29
# 13:28:55
### 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.... done
server started
# Postmaster PID for node "master" is 18336
# restarted 30
# 13:28:56
### 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.... done
server started
# Postmaster PID for node "master" is 8768
# restarted 31
# 13:28:57
### 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.... done
server started
# 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
view thread (16+ messages)
Message-ID: <9c09a0b8b0effc6d2dd6b4f11d623c7e@postgrespro.ru>
Permalink: ../9c09a0b8b0effc6d2dd6b4f11d623c7e@postgrespro.ru/
Also on: postgresql.org/message-id/9c09a0b8b0effc6d2dd6b4f11d623c7e@postgrespro.ru
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: r.zharkov@postgrespro.ru, tgl@sss.pgh.pa.us, michael@paquier.xyz, bachow@microsoft.com, pgsql-hackers@lists.postgresql.org
Subject: Re: Intermittent pg_ctl failures on Windows
In-Reply-To: <9c09a0b8b0effc6d2dd6b4f11d623c7e@postgrespro.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox