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

[Juned K. <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