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

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

nope it didn't

astpp=# SELECT pgxc_pool_reload();
 pgxc_pool_reload
------------------
 t
(1 row)

astpp=# \q
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 12:29 PM, 鈴木 幸市 <ko...@in...> wrote:

>  Hmm, did pgxc_pool_reload() work?
> ---
> Koichi Suzuki
>
>  2014/05/07 14:33、Juned Khan <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...> wrote:
>
>> What error did you have?
>> ---
>> Koichi Suzuki
>>
>>  2014/05/07 14:18、Juned Khan <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...> 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...> のメール：
>>>
>>>   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
>
>
>


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