Something broken around FDW connection close - Mailing list pgsql-hackers

From David Rowley
Subject Something broken around FDW connection close
Date
Msg-id CAKJS1f-vw4coMu5aDWiZ3wGOCgbT3tKfzAS9ZhLMxB77kwXcbA@mail.gmail.com
Whole thread Raw
Responses Re: Something broken around FDW connection close  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
List pgsql-hackers
create table t (a int, b int);
insert into t1 select x/100,x/100 from  generate_series(1,100000) x;
create extension if not exists postgres_fdw;
create server test_server foreign data wrapper postgres_fdw options (host 'localhost', port '5432', dbname 'postgres');
create foreign table ft_t (a int,b int) server test_server;
select 'create user mapping for current_user server test_server options(user ''' || current_user || ''');';
\gexec
select count(*) from pg_stat_Activity; -- > 6
analyze ft_t;
ERROR:  could not connect to server "test_server"
DETAIL:  FATAL:  sorry, too many clients already
CONTEXT:  Remote SQL command: DECLARE c1 CURSOR FOR SELECT a, b FROM public.ft_t
Remote SQL command: SELECT a, b FROM public.ft_t
Remote SQL command: SELECT a, b FROM public.ft_t
Remote SQL command: SELECT a, b FROM public.ft_t
(lots of these)

select count(*) from pg_stat_Activity; --> 105

I've not had a moment to check into what's going on. 
Adding to open items...

--
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: release notes for v10
Next
From: Neha Khatri
Date:
Subject: Re: strange parallel query behavior after OOM crashes