Skip site navigation (1) Skip section navigation (2)

Re: DB failure?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Wes <wespvp(at)syntegra(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: DB failure?
Date: 2004-08-31 09:12:50
Message-ID: 20040831091247.GA22446@svana.org (view raw or flat)
Thread:
Lists: pgsql-general
Time to test your memory and harddisk....

On Tue, Aug 31, 2004 at 12:24:53AM -0500, Wes wrote:
> On 8/30/04 11:07 PM, "Wes Palmer" <wespvp(at)syntegra(dot)com> wrote:
> 
> > db=> select count(*) from messages;
> > ERROR:  could not access status of transaction 859000513
> > DETAIL:  could not open file "/db/pgsql/data/pg_clog/0333": No such file or
> > directory
> > 
> > db=> select count(*) from message_recipients;
> > ERROR:  invalid page header in block 1238604 of relation
> > "message_recipients"
> 
> Uh, oh..  This would appear to be a big problem...  I just tried to do a
> pg_dumpall.  The server SEGV'd around a Gig into the pg_dumpall:
> 
> LOG:  server process (PID 12541) was terminated by signal 11
> LOG:  terminating any other active server processes
> WARNING:  terminating connection because of crash of another server process
> DETAIL:  The postmaster has commanded this server process to roll back the
> current transaction and exit, because another server process exited
> abnormally and possibly corrupted shared memory.
> HINT:  In a moment you should be able to reconnect to the database and
> repeat your command.
> LOG:  all server processes terminated; reinitializing
> LOG:  database system was interrupted at 2004-08-31 07:13:31 MEST
> LOG:  checkpoint record is at 6E/13A916C
> LOG:  redo record is at 6E/13A916C; undo record is at 0/0; shutdown FALSE
> LOG:  next transaction ID: 173895; next OID: 243689524
> LOG:  database system was not properly shut down; automatic recovery in
> progress
> LOG:  record with zero length at 6E/13A91AC
> LOG:  redo is not required
> LOG:  recycled transaction log file "0000006E00000000"
> LOG:  database system is ready
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

In response to

pgsql-general by date

Next:From: Thomas ChilleDate: 2004-08-31 10:23:30
Subject: Re: aggregates with complex type as state and init condition
Previous:From: JoelDate: 2004-08-31 08:17:32
Subject: Re: UTF-8 and LIKE vs =

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group