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

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

you mean i should try to restart gtm_pxy2 and coord2. but i have already
tried to restart this components but it didn't start at all. and it also
caused other components to stop functioning. so i am very scared to do
anything with live pgxc environment.


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

>  Oh, your datanode has inconsistency.   I wonder how come.   The reason
> why your datanode slave does not work will be this.
>
>  From your result of pyxc_ctl monitor all command result, your datanode
> is still running.
>
>  What you can do is to restart stopping gtm_pxy2 and coord2.   This will
> not be harmful.   Please try and let me know what’s going on.   If you have
> a problem, please share what you get from the server log.
>
>  Regards;
>
> ---
> Koichi Suzuki
>
>  2014/05/07 16:25、Juned Khan <jkh...@gm...> のメール：
>
>   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
>
>
>


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