"Keaton Adams" <[EMAIL PROTECTED]> writes:
> Auto vacuum is not enabled:
Hmph. That shoots down the one semi-plausible idea I had about how you
got into this state. It seems that the unexpected limit_datname value
must have come from flatfiles.c, but that *certainly* won't pick up
any database w
1497605405
So before it grows into the 2.1 billion value we'll need to do a manual
reset of the FrozenXID on this DB as well.
Of course, we are looking into an 8.1.9 upgrade to avoid this problem in
the future.
Thanks,
Keaton
-Original Message-
From: Tom Lane [mailto:[EMAIL P
"Keaton Adams" <[EMAIL PROTECTED]> writes:
> Do I have this right?
It's not clear. You didn't answer the question about whether you were
running autovac, but even if you were I'm not sure why you got the
complaint about template0. AFAICS the only way for template0 to be
installed as oldest_datna
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, August 06, 2007 11:02 AM
To: Joshua D. Drake
Cc: Keaton Adams; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Template zero xid issue
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> 2. IIRC there is a bug in 8.1.4 that c
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> 2. IIRC there is a bug in 8.1.4 that causes template0 to increment when
> it shouldn't. Update the template0 to allow connections, vacuum full,
> dissallow connections, and then upgrade.
That should be "vacuum freeze" but otherwise this is the correc
"Keaton Adams" <[EMAIL PROTECTED]> writes:
> Sorry, I should have mentioned that to begin with: psql 8.1.4
Hmm, you know that's pretty old don't you? The latest release in
that branch is 8.1.9 (and there'll be an 8.1.10 before long).
> It's set to false.
> mxl=3D# \c template0;
> FATAL: databa
ne [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 06, 2007 10:30 AM
> To: Keaton Adams
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Template zero xid issue
>
> "Keaton Adams" <[EMAIL PROTECTED]> writes:
>> Our production DB shut down b
"Keaton Adams" <[EMAIL PROTECTED]> writes:
> So it is odd that over 14,000 XIDs are being consumed on template zero
> in just over one minute?
You misunderstand what you are looking at --- that's the cluster-wide
XID consumption rate, not any one database's.
regards, tom l
FATAL: database "template0" is not currently accepting connections
Previous connection kept
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, August 06, 2007 10:30 AM
To: Keaton Adams
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Template zero xid
"Keaton Adams" <[EMAIL PROTECTED]> writes:
> Our production DB shut down because of it:
[ squint... ] Which PG version is this exactly? Is template0 marked as
datallowconn in pg_database, or not?
regards, tom lane
---(end of broadcast)---
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Keaton Adams
Sent: Monday, August 06, 2007 10:14 AM
To: Tom Lane
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Template zero xid issue
Our production DB shut down because of it:
<2007-08-06
6 09:44:08 MDT>FATAL: the database system is shutting down
<2007-08-06 09:44:08 MDT>FATAL: the database system is shutting down
<2007-08-06 09:44:08 MDT>LOG: database system is shut down
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Mon
"Keaton Adams" <[EMAIL PROTECTED]> writes:
> Our template 0 database has an XID issue:
No, it doesn't. template0 never needs vacuuming.
regards, tom lane
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
13 matches
Mail list logo
