From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>, Thom Brown <thom(at)linux(dot)com>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>, coelho(at)cri(dot)ensmp(dot)fr |
Subject: | Re: Breakage with VACUUM ANALYSE + partitions |
Date: | 2016-03-25 12:41:51 |
Message-ID: | CAB7nPqSBFmh5cQjpRbFBp9Rkv1nF=Nh2o1FxKkJ6yvOBtvYDBA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
On Thu, Mar 24, 2016 at 9:40 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> 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.
I could reproduce the failure on Linux, not on OSX, and bisecting the
failure, the first bad commit is this one:
commit: 428b1d6b29ca599c5700d4bc4f4ce4c5880369bf
author: Andres Freund <andres(at)anarazel(dot)de>
date: Thu, 10 Mar 2016 17:04:34 -0800
Allow to trigger kernel writeback after a configurable number of writes.
The failure is a little bit sporadic, based on my tests 1/2 runs out
of 10 could pass, so one good commit was recognized as such after
passing the SQL sequence sent by Thom 5 times in a row. I also did
some manual tests and those are pointing to this commit as well.
I am adding Fabien and Andres in CC for some feedback.
--
Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2016-03-25 13:25:41 | Re: Breakage with VACUUM ANALYSE + partitions |
Previous Message | srivathson.k | 2016-03-25 10:26:42 | BUG #14047: Problem while initdb - 0xC000001D |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2016-03-25 12:48:02 | Re: VS 2015 support in src/tools/msvc |
Previous Message | Michael Paquier | 2016-03-25 12:37:01 | Re: Small patch: Change calling convention for ShmemInitHash (and fix possible bug) |