From: Andreas Seltenreich <andreas.seltenreich@credativ.de>
To: Michael Paquier <michael.paquier@gmail.com>
Cc: Bernd Helmle <mailings@oopsware.de>,  Peter Geoghegan <pg@bowt.ie>,
  PostgreSQL mailing lists <pgsql-bugs@postgresql.org>
Subject: Re: PostgreSQL crashes with SIGSEGV
References: <1512661638.9720.34.camel@oopsware.de>
	<CAH2-WznDBGQXBE=n3vXWLDomjAbJQz15xK3+hxh-Y92F0eTaBg@mail.gmail.com>
	<1512724784.9720.39.camel@oopsware.de>
	<CAB7nPqTq8tVXGLQvTBJTYC5u8k__AF6nDNNNxOS=hP+tpCKxsQ@mail.gmail.com>
Date: Thu, 14 Dec 2017 19:47:08 +0100
In-Reply-To: 
 <CAB7nPqTq8tVXGLQvTBJTYC5u8k__AF6nDNNNxOS=hP+tpCKxsQ@mail.gmail.com>
	(Michael Paquier's message of "Tue, 12 Dec 2017 12:03:23 +0900")
Message-ID: <87po7hm9jn.fsf@credativ.de>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.2 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain
Precedence: bulk

Michael Paquier writes:

> Not sure if you can provide this information, but what does the plan
> of the query look like?

We did some more reducing work on the original query and data.  The
following testcase reproduces the double free reported by valgrind for
me when run against a vanilla REL9_6_STABLE build.

regards,
Andreas

--8<---------------cut here---------------start------------->8---
drop table if exists bug;
create table bug (n text, v text, b text, t text);
insert into bug
   select i%9, i%9, i%16 ,i%4096 from generate_series(1,100000) g(i);
analyze bug;

explain select * from (
select thecube.nv
   from ( select
            (n || ' ') || coalesce(v, '') as nv
           from bug
           group by ((n || ' ') || coalesce(v, '')) ,cube(b, t)
	  ) thecube
	 where nv = '8 8'
) sub limit 7000;
--8<---------------cut here---------------end--------------->8---

                                            QUERY PLAN
---------------------------------------------------------------------------------------------------
 Limit  (cost=13422.32..15747.28 rows=7000 width=32)
   ->  Subquery Scan on thecube  (cost=13422.32..27622.49 rows=42754 width=32)
         ->  GroupAggregate  (cost=13422.32..27194.95 rows=42754 width=38)
               Group Key: (((bug.n || ' '::text) || COALESCE(bug.v, ''::text))), bug.b, bug.t
               Group Key: (((bug.n || ' '::text) || COALESCE(bug.v, ''::text))), bug.b
               Group Key: (((bug.n || ' '::text) || COALESCE(bug.v, ''::text)))
               Sort Key: (((bug.n || ' '::text) || COALESCE(bug.v, ''::text))), bug.t
                 Group Key: (((bug.n || ' '::text) || COALESCE(bug.v, ''::text))), bug.t
               Filter: ((((bug.n || ' '::text) || COALESCE(bug.v, ''::text))) = '8 8'::text)
               ->  Sort  (cost=13422.32..13672.32 rows=100000 width=42)
                     Sort Key: (((bug.n || ' '::text) || COALESCE(bug.v, ''::text))), bug.b, bug.t
                     ->  Seq Scan on bug  (cost=0.00..2041.00 rows=100000 width=42)