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

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

Hmm, did pgxc_pool_reload() work?
---
Koichi Suzuki

2014/05/07 14:33、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

PGXC pg_dumpall -h db02 > dumpall.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
pg_dumpall: pg_dump failed on database "astpp", exiting



On Wed, May 7, 2014 at 10:56 AM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
What error did you have?
---
Koichi Suzuki

2014/05/07 14:18、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

yeah i tried to restart the coord2 and gtm_pxy2 but no success.
I have tried to take pg_dumpall but its giving me same error.

please suggest.

Regards
Juned Khan

On Wed, May 7, 2014 at 6:31 AM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
Did you try to restart the coord2 and gtm_pxy2?     Also, I advise to use pg_dumpall, not pg_dump unless you’re backing up single database.    I’m afraid coord2 had had some issue.

Regards;
---
Koichi Suzuki

2014/05/06 21:50、Juned Khan <jkh...@gm...<mailto: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...<mailto: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...<mailto: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...<mailto:Pos...@li...>
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>






--
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com<http://www.inextrix.com/>