| 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: | Whole Thread | Raw Message | 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;
| 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 |