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

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

nope i have directly did those steps on live server. I don't know exactly
what cause that problem. one day i just tried to run some queries manually
and got those errors.

I have tried to restart all components several times without success.

now another problem is i am not able to take dump of database. i am getting
this error.

postgres@db02:~$  pg_dump -h db02 --exclude-table=cdrs db -f db.sql
pg_dump: [archiver (db)] query failed: ERROR:  Failed to get pooled
connections
pg_dump: [archiver (db)] query was: LOCK TABLE public.accounts IN ACCESS
SHARE MODE

Please suggest.



On Sun, May 4, 2014 at 4:10 PM, Koichi Suzuki <koi...@gm...> wrote:

> 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
> >
>



-- 
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com