Problem creating temporary tables . . .

From: Rubén Crespo Flores <ruben(dot)crespo1(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Problem creating temporary tables . . .
Date: 2012-09-19 21:21:32
Message-ID: 6F6C406D-518A-4E6F-ACE9-D234B6EB2418@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi, I'm using PostgreSQL 9.0.4, with the replication activated to one server.

About 3 weeks ago, we have a disk space problem on both servers. I recovered the DB but since then (or at least had not noticed before), in 10 executions of functions that generate temporary tables, 3 returns the following error message:

ERROR: could not find tuple for attrdef 299038853
SQL state: XX000
Context: SQL statement "create temporary table tmp_tablatotlin15 (...

We apply vaccum analize to pg_class, pg_attribute, pg_attrdef and pg_depends, but did not help much.

I appreciate your attention. Any suggestions are welcome.

regards and thanks

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2012-09-19 21:30:18 Re: Problem creating temporary tables . . .
Previous Message Michael Holt 2012-09-19 21:17:45 Re: max_locks_per_transaction and partitioned tables