Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitf9e9525

Browse files
author
Amit Kapila
committed
Revert test added by commitd207038.
This test was trying to test the mechanism to release kernel FDs as neededto get us under the max_safe_fds limit in case of spill files. To do that,it needs to set max_files_per_process to a very low value which doesn'teven permit starting of the server in the case when there are a few alreadyopened files. This test also won't work on platforms where we use one FDper semaphore.Backpatch-through: 10, till where this test was addedDiscussion:https://postgr.es/m/CAA4eK1LHhERi06Q+MmP9qBXBBboi+7WV3910J0aUgz71LcnKAw@mail.gmail.comhttps://postgr.es/m/6485.1578583522@sss.pgh.pa.us
1 parent8c8b456 commitf9e9525

File tree

1 file changed

+1
-38
lines changed

1 file changed

+1
-38
lines changed

‎src/test/recovery/t/006_logical_decoding.pl

Lines changed: 1 addition & 38 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
use warnings;
88
use PostgresNode;
99
use TestLib;
10-
use Test::Moretests=>11;
10+
use Test::Moretests=>10;
1111
use Config;
1212

1313
# Initialize master node
@@ -133,42 +133,5 @@
133133
is($node_master->slot('otherdb_slot')->{'slot_name'},
134134
undef,'logical slot was actually dropped with DB');
135135

136-
# Test to ensure that we don't run out of file descriptors even if there
137-
# are more spill files than maxAllocatedDescs.
138-
139-
# Set max_files_per_process to a small value to make it more likely to run out
140-
# of max open file descriptors.
141-
$node_master->safe_psql('postgres',
142-
'ALTER SYSTEM SET max_files_per_process = 26;');
143-
$node_master->restart;
144-
145-
$node_master->safe_psql(
146-
'postgres',q{
147-
do $$
148-
BEGIN
149-
FOR i IN 1..10 LOOP
150-
BEGIN
151-
INSERT INTO decoding_test(x) SELECT generate_series(1,5000);
152-
EXCEPTION
153-
when division_by_zero then perform 'dummy';
154-
END;
155-
END LOOP;
156-
END $$;
157-
});
158-
159-
$result =$node_master->safe_psql('postgres',
160-
qq[
161-
SELECT data from pg_logical_slot_get_changes('test_slot', NULL, NULL)
162-
WHERE data LIKE '%INSERT%' ORDER BY lsn LIMIT 1;
163-
]);
164-
165-
$expected =q{table public.decoding_test: INSERT: x[integer]:1 y[text]:null};
166-
is($result,$expected,'got expected output from spilling subxacts session');
167-
168-
# Reset back max_files_per_process
169-
$node_master->safe_psql('postgres',
170-
'ALTER SYSTEM SET max_files_per_process = DEFAULT;');
171-
$node_master->restart;
172-
173136
# done with the node
174137
$node_master->stop;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp