FAQ
The attached SQL causes a crash in 9.1. It appears to be caused by:

d1001a78ce612a16ea622b558f5fc2b68c45ab4c

The patch tries to copy all of the important data out of the child
context before it's reset; but it doesn't get everything. For instance,
grouping_planner() allocates subroot.glob->paramlist, and uses it in
subsequent iterations; but that isn't copied before the context is
reset. It looks like there are other things that need copying as well,
but it wasn't immediately clear to me what the best fix is.

Regards,
Jeff Davis

Search Discussions

  • Tom Lane at Jan 13, 2011 at 1:26 am

    Jeff Davis writes:
    The attached SQL causes a crash in 9.1. It appears to be caused by:
    d1001a78ce612a16ea622b558f5fc2b68c45ab4c
    The patch tries to copy all of the important data out of the child
    context before it's reset; but it doesn't get everything. For instance,
    grouping_planner() allocates subroot.glob->paramlist, and uses it in
    subsequent iterations; but that isn't copied before the context is
    reset. It looks like there are other things that need copying as well,
    but it wasn't immediately clear to me what the best fix is.
    Ugh. Maybe the best fix is to back that out. I too am now unsure which
    substructures of PlannerGlobal are at risk, and I don't really think
    that hack was worth taking any risk of destabilizing the system for.

    regards, tom lane

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-bugs @
categoriespostgresql
postedJan 12, '11 at 10:59p
activeJan 13, '11 at 1:26a
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Jeff Davis: 1 post Tom Lane: 1 post

People

Translate

site design / logo © 2021 Grokbase