Re: no space left on device - Mailing list pgsql-general

No, I've not added any new DB's.  In fact, what's puzzling is that this DB
has been running without issue (except for one server restart) for the
last nine months.  Now, all of a sudden, with no DB changes, additions,
etc... I'm getting this problem.

Do you suggest that I still run a vacuumdb?

Rgs,

Zeb



On Fri, 9 Jan 2004, Joshua D. Drake wrote:

:Aurangzeb M. Agha wrote:
:
:>I've not run a vacuum in quite some time, and that's because I've only
:>been doing reads from this DB.  I was under the impression that I should
:>run vacuum when tables are heavily modified:
:>
:>
:
:That would be accurate. Did you recently add a second database?
:
:Sincerely,
:
:Joshua D. Drake
:
:
:>http://www.postgresql.org/docs/aw_pgsql_book/node110.html
:>
:>I guess I must have been mistaken?
:>
:>I'm looking through the docs now, but am having trouble finding this: how
:>can I vacuum the entire DB at once?
:>
:>Thx,
:>
:>Zeb
:>
:>On Fri, 9 Jan 2004, Joshua D. Drake wrote:
:>
:>:
:>:>
:>:>Note that the pg_xlog dir is huge!  Here's its contents:
:>:>
:>:>[postgres - DB/pg_xlog]$ ls -al
:>:>total 32816
:>:>drwx------    2 postgres admin        4096 Mar 29  2003 .
:>:>drwx------    6 postgres admin        4096 Jan  9 15:04 ..
:>:>-rwx------    1 postgres admin    16777216 Jan  9 15:09 0000000000000001
:>:>-rwx------    1 postgres admin    16777216 Mar 29  2003 0000000000000002
:>:>
:>:>What are these files, and what can I do to resolve this issue?
:>:>
:>:>
:>:The are check_point files. You need them. Have you ran a vacuum recently?
:>:
:>:Sincerely,
:>:
:>:Joshua D. Drake
:>:
:>:
:>:
:>:>Thx,
:>:>
:>:>Zeb
:>:>
:>:>
:>:>--
:>:>DEBUG:  statistics collector process (pid 2523) exited with exit code 1
:>:>PGSTAT: Error closing temp stats file
:>:>PGSTAT: /usr/local/G101/App/DB/./global/pgstat.tmp.7823: No space left on
:>:>device
:>:>PGSTAT: AbDEBUG:  statistics collector process (pid 2979) exited with exit
:>:>code
:>:>1
:>:>FATAL 2:  write of clog file 43, offset 188416 failed: No space left on
:>:>device
:>:>DEBUG:  server process (pid 3741) exited with exit code 2
:>:>DEBUG:  terminating any other active server processes
:>:>NOTICE:  Message from PostgreSQL backend:
:>:>        The Postmaster has informed me that some other backend
:>:>        died abnormally and possibly corrupted shared memory.
:>:>        I have rolled back the current transaction and am
:>:>        going to terminate your database system connection and exit.
:>:>        Please reconnect to the database system and repeat your query.
:>:>NOTICE:  Message from PostgreSQL backend:
:>:>        The Postmaster has informed me that some other backend
:>:>        died abnormally and possibly corrupted shared memory.
:>:>        I have rolled back the current transaction and am
:>:>        going to terminate your database system connection and exit.
:>:>        Please reconnect to the database system and repeat your query.
:>:>NOTICE:  Message from PostgreSQL backend:
:>:>        The Postmaster has informed me that some other backend
:>:>        died abnormally and possibly corrupted shared memory.
:>:>        I have rolled back the current transaction and am
:>:>        going to terminate your database system connection and exit.
:>:>        Please reconnect to the database system and repeat your query.
:>:>DEBUG:  all server processes terminated; reinitializing shared memory and
:>:>semaph
:>:>ores
:>:>DEBUG:  database system was interrupted at 2004-01-09 05:22:52 EST
:>:>DEBUG:  checkpoint record is at 0/138CFD4
:>:>DEBUG:  redo record is at 0/138CFD4; undo record is at 0/0; shutdown FALSE
:>:>DEBUG:  next transaction id: 45811837; next oid: 65205
:>:>DEBUG:  database system was not properly shut down; automatic recovery in
:>:>progre
:>:>ss
:>:>DEBUG:  redo starts at 0/138D014
:>:>FATAL 2:  write of clog file 43, offset 188416 failed: No space left on
:>:>device
:>:>DEBUG:  startup process (pid 3785) exited with exit code 2
:>:>DEBUG:  aborting startup due to startup process failure
:>:>
:>:>---------------------------(end of broadcast)---------------------------
:>:>TIP 6: Have you searched our list archives?
:>:>
:>:>               http://archives.postgresql.org
:>:>
:>:>
:>:
:>:
:>:
:>
:>
:
:
:

--
Aurangzeb M. Agha     | Email : ama@mltp.com
                      | Home  : +1 413 586.4863
                      | Pager : +1 413 785.7568
                      |       : 4137857568@myairmail.com
73 Bridge St. #15     | Mobile: <coming soon>
Northampton, MA 01060 | e-Fax : +1 978 246.0770
USA                   | PGP id: <coming soon>