| From: | Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Orphaned temp table |
| Date: | 2012-02-27 19:31:00 |
| Message-ID: | CANPAkgsswO4XP6wJ17dCK9tEYpRvbkJ9R4yCTBGAxjfEgzNYhw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Autovacuum is complaining about an orphaned temp table. I believe this was
created just before a recent PostgreSQL crash. Is there something I should
do to clean it up?
2012-02-27 13:05:35 CST [18400]: [1-1] @ LOG: 00000: autovacuum: found
orphan temp table "pg_temp_7"."tmp_order_ids" in database "mydb"
2012-02-27 13:05:35 CST [18400]: [2-1] @ LOCATION: do_autovacuum,
autovacuum.c:2022
__________________________________________________________________________________
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike(dot)Blackwell(at)rrd(dot)com
http://www.rrdonnelley.com
<http://www.rrdonnelley.com/>
* <Mike(dot)Blackwell(at)rrd(dot)com>*
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James B. Byrne | 2012-02-27 19:44:09 | Re: Having a problem with RoR-3.1.1 and Pg-9.1 |
| Previous Message | Adrian Klaver | 2012-02-27 19:30:53 | Re: Having a problem with RoR-3.1.1 and Pg-9.1 |