postgres-xc-general

[Postgres-xc-general] Random failure when creating database

[Artur G. <aa...@bo...>]

Hi

I found a strange issue when creating the database in Postgres XC:

postgres=# create database bench2;
WARNING:  unexpected EOF on datanode connection
WARNING:  unexpected EOF on datanode connection
ERROR:  sorry, too many clients already

This happens randomly so I can't easily reproduce this issue but sometimes
after that error, I'm unable to access one of the datanodes because of "too
many clients already" message (even though I'm the only user using these
instances). This may be somehow connected to 


This issue appears on the following version of XC:
psql (PGXC 1.1, based on PG 9.2.4)

I use two datanodes&coordinators on separate machines and additional one
with GTM only

Cheers,
Artur

Re: [Postgres-xc-general] Random failure when creating database

[鈴木 幸市 <ko...@in...>]

Yes, this has already been reported and fix is available at github repo, https://github.com/postgres-x2/postgres-x2

Please try REL1_2_STABLE or REL1_1_STABLE branch.   They are candidate for the next minor release.

Regards;
---
Koichi Suzuki
NTT DATA Intellilink Corp.
ko...@in...

> 2015/07/20 17:43、Artur Graniszewski <aa...@bo...> のメール：
> 
> Hi
> 
> I found a strange issue when creating the database in Postgres XC:
> 
> postgres=# create database bench2;
> WARNING:  unexpected EOF on datanode connection
> WARNING:  unexpected EOF on datanode connection
> ERROR:  sorry, too many clients already
> 
> This happens randomly so I can't easily reproduce this issue but sometimes
> after that error, I'm unable to access one of the datanodes because of "too
> many clients already" message (even though I'm the only user using these
> instances). This may be somehow connected to 
> 
> 
> This issue appears on the following version of XC:
> psql (PGXC 1.1, based on PG 9.2.4)
> 
> I use two datanodes&coordinators on separate machines and additional one
> with GTM only
> 
> Cheers,
> Artur
> 
> ------------------------------------------------------------------------------
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>