Re: no space left on device

Hello,

Wait... from the df you provided you have space left on the device:

postgres - DB]$ df -m .
Filesystem 1M-blocks Used Available Use% Mounted on
- 63328 55308 4803 93% /

Perhaps you are out of inodes?

Sincerely,

Josuha D. Drake

Aurangzeb M. Agha wrote:

>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
>:>:>
>:>:>
>:>:
>:>:
>:>:
>:>
>:>
>:
>:
>:
>
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL