BUG #14042: bug, PostgreSQL not cleanup temp table info after crash.

From: digoal(at)126(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14042: bug, PostgreSQL not cleanup temp table info after crash.
Date: 2016-03-24 08:45:08
Message-ID: 20160324084508.2903.55060@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14042
Logged by: digoal
Email address: digoal(at)126(dot)com
PostgreSQL version: 9.5.1
Operating system: CentOS 6.x x64
Description:

When PostgreSQL crashed during database have temp table, database not
cleanup the temp table's info in pg_class.
and there is some bad thing, if no one create the same name temp table after
restart. this temp table will a zombie in pg_class, and vacuum freeze cann't
reduce it's age and database's age.
test:
create temp table t(id int);
don't disconnect this session.

and then:
pg_ctl stop -m immediate

and then
pg_ctl start

and then
select * from pg_namespace;
select age(relfrozenxid),relname from pg_class where relname='t';
select txid_current();
generate some xid;
vauum freeze pg_temp_??.t;
and the table not reduce age.
select age(relfrozenxid),relname from pg_class where relname='t';
and database's age cann't reduce by
vacuum freeze;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message harada.toshi 2016-03-24 09:49:44 BUG #14043: log_line_prefix %h not expand.(RPM only)
Previous Message Haribabu Kommi 2016-03-24 04:59:02 Re: Breakage with VACUUM ANALYSE + partitions