From: | Gordon Runkle <gar(at)integrated-dynamics(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | pg_clog troubles |
Date: | 2002-03-20 04:25:46 |
Message-ID: | 1016598347.28098.57.camel@spiff.runkleinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi folks,
I'm dead in the water with pg_clog errors:
Mar 19 18:25:05 nexus postgres[28736]: [6] FATAL 2: open of
/data00/pgdata/pg_clog/007D failed: No such file or directory
Mar 19 18:25:06 nexus postgres[22250]: [1] DEBUG: server process (pid
28736) exited with exit code 2
Mar 19 22:06:53 nexus postgres[29389]: [9] FATAL 2: open of
/data00/pgdata/pg_clog/0414 failed: No such file or directory
Mar 19 22:06:53 nexus postgres[22250]: [4] DEBUG: server process (pid
29389) exited with exit code 2
Mar 19 22:11:04 nexus postgres[29491]: [12] FATAL 2: open of
/data00/pgdata/pg_clog/0353 failed: No such file or directory
Mar 19 22:11:04 nexus postgres[22250]: [7] DEBUG: server process (pid
29491) exited with exit code 2
Mar 19 22:13:34 nexus postgres[29716]: [6] FATAL 2: open of
/data00/pgdata/pg_clog/0353 failed: No such file or directory
Mar 19 22:13:34 nexus postgres[29700]: [1] DEBUG: server process (pid
29716) exited with exit code 2
There aren't any other error messages, just DEBUG messages about how
PostgreSQL is cleaning up after itself.
These occur running a complex-ish query, but no more complex than
others,
and less complex than many. The query runs for about 20 seconds, then
the error occurs.
Between attempts, I shut down postgresql and ran 'ipcclean'. No joy
there.
Here's what's in my pg_clog directory:
[postgres(at)nexus postgres]$ l /data00/pgdata/pg_clog/
total 8
-rw------- 1 postgres postgres 8192 Mar 19 22:05 0000
I'm running version 7.2, with Tom's vacuum analyze patch.
I searched the postgresql.org website for 'pg_clog', came up dry. Found
some stuff in the newsgroup archives that looked similar but different
(more errors than I'm getting), and that I didn't really understand.
Any help appreciated, as always...
Gordon.
--
"Far and away the best prize that life has to offer
is the chance to work hard at work worth doing."
-- Theodore Roosevelt
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2002-03-20 04:43:49 | Re: Again, sorry, caching. |
Previous Message | Gordon Runkle | 2002-03-20 03:40:18 | pg_clog troubles |