I got this message:
2006-01-20 11:50:51 PANIC: creation of file /var/lib/pgsql/data/
pg_clog/0292 failed: File exists
In 7.3. It caused the server to restart.
Can anyone tell me what it means?
---(end of broadcast)---
TIP 2: Don't 'kill -9'
Rick Gigger [EMAIL PROTECTED] writes:
I got this message:
2006-01-20 11:50:51 PANIC: creation of file /var/lib/pgsql/data/
pg_clog/0292 failed: File exists
In 7.3. It caused the server to restart.
Can anyone tell me what it means?
7.3.what?
What file names exist in the pg_clog
Postgres version 7.3.4
... a whole bunch of other files
-rw--- 1 postgres postgres 262144 Jan 18 22:42 027D
-rw--- 1 postgres postgres 262144 Jan 19 07:38 027E
-rw--- 1 postgres postgres 262144 Jan 19 08:25 027F
-rw--- 1 postgres postgres 262144 Jan 19 09:07 0280
Rick Gigger wrote:
Postgres version 7.3.4
... a whole bunch of other files
-rw--- 1 postgres postgres 262144 Jan 18 22:42 027D
-rw--- 1 postgres postgres 262144 Jan 19 07:38 027E
-rw--- 1 postgres postgres 262144 Jan 19 08:25 027F
-rw--- 1 postgres postgres 262144
It is the version that shipped with fedora core 1. The version
string from psql is (PostgreSQL) 7.3.4-RH. I assume that it must
have been the first bug since I had plenty of disk space.
On Jan 20, 2006, at 5:35 PM, Bruce Momjian wrote:
Rick Gigger wrote:
Postgres version 7.3.4
... a
Updates for FC1 are available here:
http://download.fedoralegacy.org/fedora/1/updates/i386/
they have 7.3.9 dated in March last year.
Or grab the source for 7.3.13 and build it yourself.
cheers
andrew
Rick Gigger wrote:
It is the version that shipped with fedora core 1. The version
Rick Gigger [EMAIL PROTECTED] writes:
Postgres version 7.3.4
You realize of course that that's pretty old ...
That is right now. Right after it started up it went up to 0292.
So it was the latest file eh? I thought maybe you had some problem
with a corrupted XID leading to trying to touch
I wrote:
If this theory is correct, the bug has been there since the clog code
was first written. But the conditions for having it happen are narrow
enough that it's not too surprising we haven't seen it before.
Actually, there seem to be a couple of unresolved bug reports that look
like the
Thanks. I'm not quite sure what version I am going to upgrade to yet.
Rick
On Jan 20, 2006, at 5:59 PM, Andrew Dunstan wrote:
Updates for FC1 are available here:
http://download.fedoralegacy.org/fedora/1/updates/i386/
they have 7.3.9 dated in March last year.
Or grab the source for
=Rick Gigger [EMAIL PROTECTED] writes:
Postgres version 7.3.4
You realize of course that that's pretty old ...
Yes. I will be upgrading immediately.
That is right now. Right after it started up it went up to 0292.
So it was the latest file eh? I thought maybe you had some problem
On Jan 20, 2006, at 6:02 PM, Tom Lane wrote:
Rick Gigger [EMAIL PROTECTED] writes:
Postgres version 7.3.4
You realize of course that that's pretty old ...
That is right now. Right after it started up it went up to 0292.
So it was the latest file eh? I thought maybe you had some
Rick Gigger [EMAIL PROTECTED] writes:
I don't know if 2K could have passed since the last checkpoint.
...
now that I think about it I was getting about 400 pages requests /
minute and each of those would have have been doing at least 2
transactions so yes, I guess that is very likely.
Thanks very much!
I've decided to go straight to 8.1 though. There are just too many
performance improvements at this point that I might regret not having
and I don't want to do a dump reload again. I am about to compile it
now. If it isn't a panic grade failure in the latest 8.1 code
13 matches
Mail list logo
