pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Enzo Daddario <enzo@pienetworks.com>
To: PGADMIN <pgsql-admin@postgresql.org>
Subject: Just checking...
Date: Fri, 07 Jul 2006 08:23:17 +0800
Message-ID: <1152231797.2849.19.camel@localhost.localdomain> (raw)

Hi All,

This morning our DB server (running postgres 8.1.4) went down
unexpectedly during a pg_dump(definitely not saying that this was the
cause)  and the server required a hard reboot (unfortunately I was left
with no other choice)...

When I restarted, everything seemed to be OK, however I noticed a couple
of messages in the postgres logs that I am unsure of. The log is as
follows:

<snip>
ERROR: relation pg_toast_17183 does not exist

...
...
...

LOG:  database system was interrupted at 2006-07-07 04:38:11 WST
LOG:  checkpoint record is at 41/35458E18
LOG:  redo record is at 41/35458E18; undo record is at 0/0; shutdown
FALSE
LOG:  next transaction ID: 312814968; next OID: 141469
LOG:  next MultiXactId: 34508; next MultiXactOffset: 71080
LOG:  database system was not properly shut down; automatic recovery in
progress
LOG:  redo starts at 41/35458E5C
LOG:  record with zero length at 41/355743DC
LOG:  redo done at 41/355743B4
LOG:  could not truncate directory "pg_multixact/members": apparent
wraparound
LOG:  database system is ready
LOG:  transaction ID wrap limit is 1374623292, limited by database
"piearchive"

</snip>

I am particularly concerned with a couple of lines:

LOG:  could not truncate directory "pg_multixact/members": apparent
wraparound

ERROR: relation pg_toast_17183 does not exist

Should I be concerned about either of the above messages, and if so,
what should I do???

--------------------------------------------------------------------

On another note, as part of regular VACUUMING should I also be doing the
template0, template1 & postgres databases???

--------------------------------------------------------------------

Thanks in advance...

Enzo...   






Message-ID: <1152231797.2849.19.camel@localhost.localdomain>
Permalink:  ../1152231797.2849.19.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1152231797.2849.19.camel@localhost.localdomain

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: enzo@pienetworks.com
  Subject: Re: Just checking...
  In-Reply-To: <1152231797.2849.19.camel@localhost.localdomain>
  References: <1152231797.2849.19.camel@localhost.localdomain>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox