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

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

I know df command but i am not sure about what to remove from which
directory of postgre-xc
as i mentioned in earlier reply , the size of pg_xlog directory is 33G and
yeah still 123G space is available
on DB server.


On Fri, May 2, 2014 at 8:16 AM, Masataka Saito <pg...@gm...> wrote:

> I'm almost sure this issue caused by shot of the storage.
>
> Michael suggested followings.
>  * The partition for XC is full.
>  * df command will help you. (df is basic command enough to assume all
> of Linux engineers knows it)
>
> You could do many things by that suggestion.
> Did you run df command at every server? checked your free area?
> checked quota settings? determine if you can write some data into the
> directory?
>
> And usage of GTM proxy is unusual. I guess that the proxy produced
> enormous error logs about communication with the GTM. As GTM is not
> working well, the log may be no use and you can remove them.
>
> After that you need to recover gtm.control from GTM slave. If slave's
> one is also broken, I think it is difficult to recover the cluster.
>
> Regards.
>
>
> On 1 May 2014 19:02, Juned Khan <jkh...@gm...> wrote:
> > 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