Re: 8.2 instance that won't come up after shutdown

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: 8.2 instance that won't come up after shutdown
Date: 2009-06-22 15:45:17
Message-ID: dcc563d10906220845n7e832ca9l3e8821a4121f578d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jun 22, 2009 at 7:17 AM, Abraham, Danny<danny_abraham(at)bmc(dot)com> wrote:
> Hi
>
> We have a PG version 8.2  instance that won't come up after shutdown. The log shows the following:
>
> 2009-06-12 21:39:02.669 MDTLOG:  database system was shut down at 2009-06-12 20:56:51 MDT
> 2009-06-12 21:39:02.748 MDTLOG:  checkpoint record is at 9/D712F330
> 2009-06-12 21:39:02.748 MDTLOG:  redo record is at 9/D712F330; undo record is at 0/0; shutdown TRUE
> 2009-06-12 21:39:02.748 MDTLOG:  next transaction ID: 0/8239765; next OID: 25433
> 2009-06-12 21:39:02.748 MDTLOG:  next MultiXactId: 1; next MultiXactOffset: 0
> 2009-06-12 21:39:02.838 MDTLOG:  database system is ready
> 2009-06-12 21:39:02.846 MDTFATAL:  invalid memory alloc request size 8455717278
> 2009-06-12 21:39:02.862 MDTLOG:  startup process (PID 6198) exited with exit code 1
> 2009-06-12 21:39:02.864 MDTLOG:  aborting startup due to startup process failure
> 2009-06-12 21:39:02.928 MDTLOG:  logger shutting down
>
> We tried to set the autovacuum parameter value to off but unfortunately it did not help
>
> 1. Is this bug defined for the 8.2.4 code line also (We know that it is defined for 8.1.X) 2. How can we recreate the problem?
> 3. Is there a fix for that bug?
>
> Any help will be appreciated.

I'd update to 8.2.latest and see if it then comes up.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-06-22 15:54:19 Re: Select ranges based on sequential breaks
Previous Message DaNieL 2009-06-22 15:43:43 Why my queryes doesnt not use indexes?