Re: [HACKERS] panic on 7.3

2006-01-20 Thread Rick Gigger
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 th

Re: [HACKERS] panic on 7.3

2006-01-20 Thread Tom Lane
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 likel

Re: [HACKERS] panic on 7.3

2006-01-20 Thread Rick Gigger
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 probl

Re: [HACKERS] panic on 7.3

2006-01-20 Thread Rick Gigger
=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 wi

Re: [HACKERS] panic on 7.3

2006-01-20 Thread Rick Gigger
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 7.3.13

Re: [HACKERS] panic on 7.3

2006-01-20 Thread Tom Lane
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 th

Re: [HACKERS] panic on 7.3

2006-01-20 Thread Tom Lane
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 to

Re: [HACKERS] panic on 7.3

2006-01-20 Thread Andrew Dunstan
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 stri

Re: [HACKERS] panic on 7.3

2006-01-20 Thread Rick Gigger
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 wh

Re: [HACKERS] panic on 7.3

2006-01-20 Thread Bruce Momjian
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 26

Re: [HACKERS] panic on 7.3

2006-01-20 Thread Rick Gigger
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 -rw--

Re: [HACKERS] panic on 7.3

2006-01-20 Thread Tom Lane
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 di

[HACKERS] panic on 7.3

2006-01-20 Thread Rick Gigger
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' t