From: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Something broken around FDW connection close |
Date: | 2017-03-30 23:28:45 |
Message-ID: | CAKJS1f-vw4coMu5aDWiZ3wGOCgbT3tKfzAS9ZhLMxB77kwXcbA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Neha Khatri | 2017-03-31 00:13:17 | Re: strange parallel query behavior after OOM crashes |
Previous Message | Robert Haas | 2017-03-30 22:23:04 | release notes for v10 |