Re: pg11.1 jit segv

On Thu, Nov 15, 2018 at 03:14:01PM -0800, Andres Freund wrote:
> Huh, that's the same crash? Because I don't see any evalexpr functions
> in the stack, and without those the above bt should have worked...

TTBOMK it's the same ..

Is it odd if i'm seeing this: (odd because of "ANOTHER") ?
I guess that's maybe because it's running parallel query ?
psql:tmp/sql-jit-crash-2018-11-15.jtp:16: WARNING:  terminating connection because of crash of another server process

I'm started trying to minimize the query.  Here's what's left:

SELECT * FROM
daily_eric_umts_rnc_utrancell_view t2
JOIN (SELECT * FROM eric_umts_rbs_sector_carrier_view t1 WHERE t1.start_time >= '2018-07-01 00:00:00' AND t1.start_time
<'2018-07-09 00:00:00') AS t1 
USING(start_time)
WHERE (t2.start_time >= '2018-07-01 00:00:00' AND t2.start_time < '2018-07-09 00:00:00')

Verbose plan, munged for brevity/sanity due to joining wide tables, and
redacted since the view probably has to be considered proprietary.  Hopefully
the remaining bits are still useful.  I replaced column names with x.

 Gather  (cost=481961.60..482102.41 rows=1180 width=8068)
   Output: [ there are 1700+ columns here... ]
   Workers Planned: 3
   ->  Merge Join  (cost=480961.60..480984.41 rows=381 width=8068)
         Output:  ARRAY[x, x, ..., COALESCE(x, 0), COALESCE(x, 0)], ARRAY[..., COALESCE(x, 0), COALESCE(x, 0),
COALESCE(x,0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COA 
LESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0),
COALESCE(x,0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALE 
SCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x,
0),COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESC 
E(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x,
0),COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0), COALESCE(x, 0)], ((x)::numeric / 10.0), CASE WHEN (x
ISNULL) THEN ARRAY[..., eric_umts_rbs_sector_carrier_201807.pmaveragerssi_064] ELSE ARRAY[...] END, CASE WHEN (x IS
NULL)THEN
'{-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-60.0}'::numeric[]
ELSE
'{-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-x,-39.5}'::numeric[]
END,ARRAY[x], x, x 
         Merge Cond: (eric_umts_rbs_sector_carrier_201807.start_time = t2.start_time)
         ->  Sort  (cost=480421.29..480428.89 rows=3039 width=1652)
               Output: [...]
               Sort Key: eric_umts_rbs_sector_carrier_201807.start_time
               ->  Parallel Append  (cost=0.00..480245.49 rows=3039 width=1652)
                     ->  Parallel Seq Scan on child.eric_umts_rbs_sector_carrier_201807  (cost=0.00..480230.30
rows=3039width=1652) 
                           Output: [...]
                           Filter: ((eric_umts_rbs_sector_carrier_201807.start_time >= '2018-07-01
00:00:00-07'::timestampwith time zone) AND (eric_umts_rbs_sector_carrier_201807.start_time < '2018-07-09
00:00:00-07'::timesta
mp with time zone))
         ->  Sort  (cost=540.31..540.65 rows=139 width=7760)
               Output: [...]
               Sort Key: t2.start_time
               ->  Append  (cost=0.00..535.36 rows=139 width=7760)
                     ->  Seq Scan on public.daily_eric_umts_rnc_utrancell_view t2  (cost=0.00..0.00 rows=1 width=7760)
                           Output: [...]
                           Filter: ((t2.start_time >= '2018-07-01 00:00:00'::timestamp without time zone) AND
(t2.start_time< '2018-07-09 00:00:00'::timestamp without time zone)) 
                     ->  Bitmap Heap Scan on child.daily_eric_umts_rnc_utrancell_view_201807 t2_1  (cost=9.83..534.66
rows=138width=7760) 
                           Output: [...]
                           Recheck Cond: ((t2_1.start_time >= '2018-07-01 00:00:00'::timestamp without time zone) AND
(t2_1.start_time< '2018-07-09 00:00:00'::timestamp without time zone))  
                           ->  Bitmap Index Scan on daily_eric_umts_rnc_utrancell_view_201807_unique_idx
(cost=0.00..9.79rows=138 width=0) 
                                 Index Cond: ((t2_1.start_time >= '2018-07-01 00:00:00'::timestamp without time zone)
AND(t2_1.start_time < '2018-07-09 00:00:00'::timestamp without time zone)) 
 JIT:
   Functions: 19
   Options: Inlining false, Optimization false, Expressions true, Deforming true
(28 rows)

Justin