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

[Juned K. <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...> wrote:

> Actually i haven setup anything related to checkpoint_segments manually.
>
>
>
> On Fri, May 2, 2014 at 10:31 AM, Michael Paquier <
> mic...@gm...> wrote:
>
>> On Fri, May 2, 2014 at 11:46 AM, Masataka Saito <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
>



-- 
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com