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

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

Sorry for the late reply

here is the first 2 lines of gtm.control file

28875757
opensips.public.aliases_id_seq\00       34160   1       1       1
9223372036854775807     f       t       1




On Fri, May 2, 2014 at 1:12 PM, 鈴木 幸市 <ko...@in...> wrote:

>  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...> のメール：
>
>  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
> ------------------------------------------------------------------------------
> "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