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

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

Could you share gtm.control file which is placed at the same directory as gtm.conf.   I’m afraid this file has been removed or corrupt.    Did it use to work and then happened this problem?   If so, did you met any other issues on the operation?    Do you really have enough file space at the datanode?   Xlog archive consumes much file space.   This is no difference from PostgreSQL.

Did you setup archive_cleanup_command configuration in your recovery.conf file to clean up old archive log?   pg_archivecleanup utility will help.

Regards;
---
Koichi Suzuki

2014/05/01 15:00、Juned Khan <jkh...@gm...<mailto: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...<mailto: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...<mailto: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<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