[Postgres-xl-bugs] Missing 3 Attribute(s)

Shaun Thomas sthomas at peak6.com
Fri May 20 06:35:03 PDT 2016


> These two were really nasty bugs. While they were reported by other
> users in the past, we could never establish a reproducible case and our
> efforts to get to the bottom of it mostly met with a dead end.

I got that impression. The weird thing is that I also tried to manually replicate the issue with temp tables and got nothing. But logs didn't lie. Heh.

> I'm not sure if he has completed his tests yet, but I've already committed
> the patch to the git repo. The patch is included in the r1.1 release of
> Postgres-XL 9.5

That's excellent to hear. I've already put in a ticket to restart testing with r1.1 to verify we can at least put it back on the list. I should note that the missing metadata problem affected everything, including the TOAST table. It was able to figure out how to manually steal attributes from another TOAST table. That uncovered missing attributes on the base table, which I also replaced by creating an empty table and inserting into pg_attributes. After that, I got stuck because there was always some other missing attribute I couldn't track down.

I almost started working on a stored proc that would "fix" tables that had this problem by directly manipulating the pg_attribute table, but decided against it for obvious reasons. I just want to make sure you're aware that it wasn't just the base table that broke; everything related to it also vanished into the ether. My new test harness will be be pretty relentless regarding parallel truncation threads, because this is one bug we absolutely cannot afford to trigger once we have 40+TB on the system.

> I would not like to claim that all bugs are fixed in the new r1.1 release, but all
> critical known problems are fixed. I would definitely appreciate if you can test
> and let me know if you still see the last two problems.

I'll be doing that. Out of curiosity, why did you name it r1.1? It's the second release candidate, right? I've never seen anyone point-release an RC before. :p

--
Shaun Thomas
PEAK6 Investments, LP | 141 W. Jackson Blvd | Suite 500 | Chicago IL, 60604
312-444-8105
sthomas at peak6.com

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email


More information about the postgres-xl-bugs mailing list