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

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

The size of the directory is not the matter.  The file 000B cannot be extended in size.   I hope you have plenty of space available in the file system.   You can get this by df command.  If there are sufficient space available, it must not be an issue.

I’m curious why the transaction is writing to quite old clog 000B.    I’m afraid, as suggested, gtm.control is corrupted.   Could you share the first line of gtm.control which suggests restarting GXID value?

Regards;
---
Koichi Suzuki

2014/05/02 15:07、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

astpp=# select count(*) from accounts;
ERROR:  could not access status of transaction 0
DETAIL:  Could not write to file "pg_clog/000B" at offset 40960: No space left on device.

postgres@db02:~/pgxc/nodes/dn_master/pg_clog$ ls
0000  0001  0002  0003  0004  0005  0006  0007  0008  0009  000A  000B  000C  000D  000E  000F  0010  0011  0012  0013  0014  0015  0016  0017  0018  0019  001A

can i remove this file, although size of this directory not to big its just 6.8M


On Fri, May 2, 2014 at 10:36 AM, Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> wrote:
Actually i haven setup anything related to checkpoint_segments manually.



On Fri, May 2, 2014 at 10:31 AM, Michael Paquier <mic...@gm...<mailto:mic...@gm...>> wrote:
On Fri, May 2, 2014 at 11:46 AM, Masataka Saito <pg...@gm...<mailto:pg...@gm...>> wrote:
> 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)
And reducing checkpoint_segments would help. I am fairly guessing that
Juned set it up to an utterly high value to avoid any checkpoints to
be kicked by server during his benchmark tests to avoid I/O spikes
caused by dirty page flushes.
--
Michael



--
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com<http://www.inextrix.com/>



--
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