From: Thomas Markus <t.markus@proventis.net>
To: pgsql-admin@postgresql.org
Subject: Re: problems with access into system catalogs
Date: Thu, 26 Jul 2012 10:39:55 +0200
Message-ID: <5011025B.7050003@proventis.net> (raw)
In-Reply-To: <5010FEF2.3050901@ringerc.id.au>
References: <5010F555.9020209@proventis.net>
<5010FEF2.3050901@ringerc.id.au>
Hi,
see below
Am 26.07.2012 10:25, schrieb Craig Ringer:
> First, thank-you for an excellent complete question with versions,
> EXPLAIN ANALYZE, and exact messages.
;)
>
> - Do you have any uncommitted two phase transactions? Run:
> SELECT * from pg_prepared_xacts ;
hm yes, i stopped all applications this morning but this query shows:
transaction | gid |
prepared | owner | database
-------------+----------------------------------------------------------------------------------------------+-------------------------------+--------+-----------
49737548 |
131075_MS03ZjAwMDAwMTpjZmVlOjRlZDg3MTk2OjY4NGJlN2I=_N2YwMDAwMDE6Y2ZlZTo0ZWQ4NzE5Njo2ODRiZTdm
| 2012-01-05 07:49:30.78583+01 | xxx | db1
49737549 |
131075_MS03ZjAwMDAwMTpjZmVlOjRlZDg3MTk2OjY4NGJlN2I=_N2YwMDAwMDE6Y2ZlZTo0ZWQ4NzE5Njo2ODRiZTg0
| 2012-01-05 07:49:30.789382+01 | xxx | db2
system time is valid (Thu Jul 26 10:38:12 CEST 2012). so may 1st is
really old
Should I restart the instance?
>
> - Do you have any long-lived 'IDLE IN TRANSACTION' connections ? Try:
> SELECT * FROM pg_stat_activity WHERE current_query = '<IDLE> in
> transaction' AND xact_start > current_timestamp - '1 minute'::interval;
none, and there was a disconnect from all clients this morning
>
> Either of those can prevent vacuum from cleaning things up.
>
> Do you very frequently create and drop tables, indexes, etc? Say,
> using a database unit testing framework?
no, its a live system with normal olap access
Thomas
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: t.markus@proventis.net
Subject: Re: problems with access into system catalogs
In-Reply-To: <5011025B.7050003@proventis.net>
* 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