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

[鈴木 幸市 <ko...@in...>]

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...<mailto: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...<mailto:mic...@gm...>> wrote:
On Mon, Apr 28, 2014 at 8:31 PM, Juned Khan <jkh...@gm...<mailto: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<http://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