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

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

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