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

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

nope i mean pg_xlog at datanode master, datanode slave is already down due
to some connection related
problem<http://sourceforge.net/p/postgres-xc/mailman/message/32232987/>
.

My current database status is
PGXC monitor all
Running: gtm master
Running: gtm slave
Running: gtm proxy gtm_pxy1
Running: gtm proxy gtm_pxy2
Running: coordinator master coord1
Running: coordinator master coord2
Running: datanode master datanode1
Not running: datanode slave datanode1

only datanode master is up as of now, i can not stop my database to check
such things.
Also while restarting components if something wrong will happen then my
whole system will go down, so i can not take change at this movement. hope
you understand.



On Thu, May 1, 2014 at 4:19 PM, 鈴木 幸市 <ko...@in...> wrote:

>  Do you mean pg_xlog at the slave?   Because pg_xlog contains all the redo
> logs needed to recovery, it is quite harmful to do so.   If you are
> removing pg_xlog at the slave, it is also harmful too.   Pgxc_ctl
> configures the  slave to remove unnecessary files under pg_xlog
> automatically.
>
>  Anyway, the problem looks to be caused by missing gtm.control.   Do you
> have any indication how it’s been gone?   And what is your current status
> of the database?   Do you have any chance to stop the database, take
> backups and see what’s going on?
>
>  Regards;
> ---
> Koichi Suzuki
>
>  2014/05/01 19:45、Juned Khan <jkh...@gm...> のメール：
>
>  what will be the impact if i remove files under pg_xlog directory ?
>
> root@db02:/home/postgres/pgxc/nodes/dn_master/pg_xlog# du -sh
> 33G     .
>
>
>
> On Thu, May 1, 2014 at 4:05 PM, Juned Khan <jkh...@gm...> wrote:
>
>>  As of now i am attaching my pgxc_ctl.conf file, i have setup everything
>> using pgxc_ctl. this database is in production. to perform all above steps
>> i need to set downtime. so when i get a change i ll perform this steps .
>>   please tell me if i have done any misconfiguration in this file. so i
>> can update this at that time.
>>
>>
>>
>>
>> On Thu, May 1, 2014 at 3:50 PM, 鈴木 幸市 <ko...@in...> wrote:
>>
>>> I needd an info how you configured your cluster, manually or pgxc_ctl.
>>> If pgxc_ctl, I need your configuration file.
>>>
>>>  Also, it’s very funny that gtm.control is missing.     If so, next
>>> thing you can do is:
>>>
>>>  1) Stop all the coordinators/datanodes/gtm, master and slave.
>>> 2) Bake file-level backup of all the resources (cold backup)
>>> 3) Detach coordinator/datanode slaves and see if masters run normally.
>>> 4) If so, then reconstruct slaves.
>>> 5) If masters does not work correctly, you need to hack each node’s
>>> pg_control to see current GXID value and restore gtm.control with this
>>> value to restart gtm.
>>>
>>>  Even if gtm fails, gtm.control is available to indicate a safe restart
>>> point.   Do you have any idea how it’s been gone?
>>>
>>>  Regards;
>>>  ---
>>> Koichi Suzuki
>>>
>>>  2014/05/01 19:02、Juned Khan <jkh...@gm...> のメール：
>>>
>>>   I am not sure but may be datanode_archlog directory is not exists in
>>> my case. may be its have different name.
>>>  however size of /home/postgres/pgxc/nodes/dn_master directory is *42G*and /home/postgres/pgxc/nodes/gtm_pxy is of
>>> *31G*.
>>>
>>>  Please suggest.
>>>
>>>
>>> On Thu, May 1, 2014 at 12:50 PM, Michael Paquier <
>>> mic...@gm...> wrote:
>>>
>>>> On Mon, Apr 28, 2014 at 8:31 PM, Juned Khan <jkh...@gm...>
>>>> wrote:
>>>> >
>>>> "/home/postgres/pgxc/nodes/datanode_archlog/000000010000001C0000006A": No
>>>> > space left on device (28)
>>>>  This means that the partition containing folder
>>>> /home/postgres/pgxc/nodes/datanode_archlog/ is full. Try to do some df
>>>> and monitor the size of this partition/disk that you are using for
>>>> your archive files.
>>>> --
>>>> Michael
>>>>
>>>
>>>
>>>
>>> --
>>> Thanks,
>>> Juned Khan
>>> iNextrix Technologies Pvt Ltd.
>>> www.inextrix.com
>>>
>>> ------------------------------------------------------------------------------
>>> "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