Problem creating temporary tables . . . - Mailing list pgsql-admin

From Rubén Crespo Flores
Subject Problem creating temporary tables . . .
Date
Msg-id 6F6C406D-518A-4E6F-ACE9-D234B6EB2418@gmail.com
Whole thread Raw
Responses Re: Problem creating temporary tables . . .  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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
noticedbefore),  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



pgsql-admin by date:

Previous
From: Michael Holt
Date:
Subject: Re: max_locks_per_transaction and partitioned tables
Next
From: Tom Lane
Date:
Subject: Re: Problem creating temporary tables . . .