Re: [Postgres-xc-general] Problem with executing any query (No space left on )

[Juned K. <jkh...@gm...>]

Hi Koichi,

I tried to follow the steps removing datanode slave and adding it again but
i no success. even earlier only datanode slave was not working but now gtm
slave, gtm_pxy2, coord2 and dn_slave is not starting up. I have removed GTM
slave and datanode slave

here is my current status of pgxc
PGXC monitor all
Running: gtm master
Running: gtm proxy gtm_pxy1
Not running: gtm proxy gtm_pxy2
Running: coordinator master coord1
Not running: coordinator master coord2
Running: datanode master datanode1

Now each time i have to connect on db02 only( i.e PGXC Psql -h db02 -d
mydatabase) but its not allowing me to modify table structure. and giving
me below error.

mydatabase=#  alter table invoice_summary_data add countrycode text not
null default ''::character(1);
ERROR:  Failed to get pooled connections
CONTEXT:  SQL statement "EXECUTE DIRECT ON (coord2) 'SELECT
pg_catalog.pg_try_advisory_xact_lock_shared(65535, 0)'"

So as of now i am planning to remove those components which are not working
(gtm_pxy2,coord2 ). so it will not go to connect cood2 which is down.

what will be the impact of this, i don't want to loost database access
completely.

Please suggest.

Regards
Juned Khan