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

[Masataka S. <pg...@gm...>]

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
>