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

[Koichi S. <koi...@gm...>]

Did you make any test before you did any action on your database?
Also could you share what you did to have this situation?   Anyway,
with this situation, I believe no DDL has been handled except for
temporary object, which is session specific.

So I believe you can restart GTM proxy gtm_pxy2  (you don't have to
reinitialize it as long as you maintain gtm_proxy.conf) and coord2.

Anyway, it is very essential to record and share what you did, and
more important thing is to test it with non-product environment and
see what goes on, and then review any step you are taking before you
do.

Hope to have more info on this.

Best Regards;
---
Koichi Suzuki


2014-05-03 14:31 GMT+09:00 Juned Khan <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
>
> ------------------------------------------------------------------------------
> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
> Instantly run your Selenium tests across 300+ browser/OS combos.  Get
> unparalleled scalability from the best Selenium testing platform available.
> Simple to use. Nothing to install. Get started now for free."
> http://p.sf.net/sfu/SauceLabs
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>