Re: Postmaster crashes after upgrade to 8.1.4!

From: CG <cgg007(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: postgresql listserv <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postmaster crashes after upgrade to 8.1.4!
Date: 2006-05-25 17:24:27
Message-ID: 20060525172427.57936.qmail@web37904.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Okay, there was no core dump to be found.

I had to revert back to 8.1.3 which seems to be running fine. I am /extremely/
thankful that there was no data corruption.

I took a 24 hour old dumpfile of the database it was crashing on and I restored
it to a similar AMD64 box (SunFire x2100 instead of SunFire x4100) running
8.1.4 and tried to crash it as the other was crashing. No joy. It seems to run.
I'll leave it running and try to put a decent load on the box to get it to
crash.

Since I would have to down the production database to get a working copy, I
won't be able to copy the offending data directory over to the test
installation until my next maint window rolls around in a few weeks. That, or
we have another outage of some type which would give me the ability to down the
database and copy the tree over.

I wish I could've done more analysis while the server was crippled. I'll keep
trying.

CG

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> CG <cgg007(at)yahoo(dot)com> writes:
> > 2006-05-25 08:30:50.076 EDT LOG: server process (PID 32140) was
> terminated
> > by signal 11
>
> That should be leaving a core dump file (if not, restart the postmaster
> under "ulimit -c unlimited"). Get a stack trace with gdb to get some
> more info about what's going on.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rafal Pietrak 2006-05-25 17:52:15 Re: background triggers?
Previous Message Michael Dean 2006-05-25 17:10:53 gentoo and 8.x