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

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

here is the logs
coord
LOG:  failed to connect to Datanode
WARNING:  can not connect to node 16384
LOG:  failed to acquire connections
STATEMENT:  LOCK TABLE public.accounts IN ACCESS SHARE MODE
ERROR:  Failed to get pooled connections
STATEMENT:  LOCK TABLE public.accounts IN ACCESS SHARE MODE

datanode:
WARNING:  archive_mode enabled, yet archive_command is not set
WARNING:  archive_mode enabled, yet archive_command is not set
WARNING:  archive_mode enabled, yet archive_command is not set


On Wed, May 7, 2014 at 12:39 PM, 鈴木 幸市 <ko...@in...> wrote:

>  Did you have any more messages to the log file of the node (both
> coordinator and datanode)?  Maybe you have some extra messages in the
> server log at the coordinator.
>
>
> ---
> Koichi Suzuki
>
>  2014/05/07 16:03、Juned Khan <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
>
>
>


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