| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com> |
| Cc: | Thom Brown <thom(at)linux(dot)com>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: Breakage with VACUUM ANALYSE + partitions |
| Date: | 2016-03-24 21:40:03 |
| Message-ID: | CA+TgmoZiF3_hG8-M6hq_Z-O=VoyNd9FtbmVTw+YcM+Fn-m_rfw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On Thu, Mar 24, 2016 at 12:59 AM, Haribabu Kommi
<kommi(dot)haribabu(at)gmail(dot)com> wrote:
> So further operations on the table uses the already constructed smgr relation
> and treats that there are RELSEG_SIZE number of blocks in the page and try
> to do the scan. But there are 0 pages in the table thus it produces the error.
>
> The issue doesn't occur from another session. Because of this reason only
> if we do only vacuum operation, the error not occurred.
Yeah, I had a suspicion that this might have to do with invalidation
messages based on Thom's description, but I think we still need to
track down which commit is at fault.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Toshi Harada | 2016-03-24 23:55:01 | Re: BUG #14043: log_line_prefix %h not expand.(RPM only) |
| Previous Message | Alvaro Herrera | 2016-03-24 21:22:49 | Re: Re: [HACKERS] BUG #13854: SSPI authentication failure: wrong realm name used |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2016-03-24 22:12:45 | Re: [WIP] Effective storage of duplicates in B-tree index. |
| Previous Message | Robert Haas | 2016-03-24 21:34:51 | Re: Relation extension scalability |