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

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

Anyone can please help me with this how to solve this issue ?


On Mon, Apr 28, 2014 at 5:01 PM, Juned Khan <jkh...@gm...> wrote:

> in logs i found this
> DETAIL:  The failed archive command was: rsync
> pg_xlog/000000010000001C0000006A postgres@db01
> :/home/postgres/pgxc/nodes/datanode_archlog/000000010000001C0000006A
> rsync: writefd_unbuffered failed to write 4 bytes to socket [sender]:
> Broken pipe (32)
> rsync: write failed on
> "/home/postgres/pgxc/nodes/datanode_archlog/000000010000001C0000006A": No
> space left on device (28)
> rsync error: error in file IO (code 11) at receiver.c(322) [receiver=3.0.9]
> rsync: connection unexpectedly closed (28 bytes received so far) [sender]
> rsync error: error in rsync protocol data stream (code 12) at io.c(605)
> [sender=3.0.9]
> LOG:  archive command failed with exit code 12
>
>
>
> On Mon, Apr 28, 2014 at 4:51 PM, Juned Khan <jkh...@gm...> wrote:
>
>> Hi all,
>>
>> I setup pgxc, but today when i tried fire one manual query i got below
>> message. i am not able to show table descriptions as well.
>>
>> database=# \d
>> 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.
>>
>> sometimes its showing table description in below format.
>>
>> database=# \dt
>> <table border="1">
>>   <caption>List of relations</caption>
>>   <tr>
>>     <th align="center">Schema</th>
>>     <th align="center">Name</th>
>>     <th align="center">Type</th>
>>     <th align="center">Owner</th>
>>   </tr>
>>
>>
>> --
>> Thanks,
>> Juned Khan
>>
>> <http://www.inextrix.com/>
>>
>
>
>
> --
> Thanks,
> Juned Khan
> iNextrix Technologies Pvt Ltd.
> www.inextrix.com
>



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