Re: pg11.1 jit segv

On Fri, Nov 16, 2018 at 05:47:24PM -0800, Andres Freund wrote:
> That's probably just the same issue as before, namely random data
> somehow being produced as the result of tuple deforming.

Does this help at all?

ts=# SELECT utrancell FROM child.daily_eric_umts_rnc_utrancell_view_201807 LIMIT 9;
ERROR:  invalid memory alloc request size 18446744073709551613

Note that's a table named after a view, and not itself a view..

(gdb) b errfinish
Breakpoint 3 at 0x891a00: file elog.c, line 411.
(gdb) c
Continuing.
SELECT start_time, site_id, sect_id, rnc_id, utrancell, eul_harq_ps_trans_tti2_1 FROM
child.daily_eric_umts_rnc_utrancell_view_201801LIMIT 1;
 
         1: start_time  (typeid = 1114, len = 8, typmod = -1, byval = t)
         2: site_id     (typeid = 23, len = 4, typmod = -1, byval = t)
         3: sect_id     (typeid = 23, len = 4, typmod = -1, byval = t)
         4: rnc_id      (typeid = 23, len = 4, typmod = -1, byval = t)
         5: utrancell   (typeid = 25, len = -1, typmod = -1, byval = f)
         6: eul_harq_ps_trans_tti2_1    (typeid = 20, len = 8, typmod = -1, byval = t)
        ----
         1: start_time = "2000-01-01 00:00:00"  (typeid = 1114, len = 8, typmod = -1, byval = t)
         2: site_id = "0"       (typeid = 23, len = 4, typmod = -1, byval = t)
         3: sect_id = "0"       (typeid = 23, len = 4, typmod = -1, byval = t)
         4: rnc_id = "0"        (typeid = 23, len = 4, typmod = -1, byval = t)

The error occurs when selecting the 5th column, which is "text not null"; but,
the other fields are also garbage (namely 0).

#0  slot_compile_deform (context=context@entry=0xe184b8, desc=desc@entry=0xe9baf0, ops=ops@entry=0xa21020
<TTSOpsBufferHeapTuple>,natts=5) at llvmjit_deform.c:36
 
#1  0x00007fffe72535f5 in llvm_compile_expr (state=0xed8458) at llvmjit_expr.c:325
#2  0x000000000061e429 in ExecReadyExpr (state=state@entry=0xed8458) at execExpr.c:628
#3  0x00000000006219b4 in ExecBuildProjectionInfo (targetList=<optimized out>, econtext=<optimized out>,
slot=<optimizedout>, parent=parent@entry=0xed7d40, inputDesc=inputDesc@entry=0xe9baf0) at execExpr.c:472
 
#4  0x00000000006370b2 in ExecAssignProjectionInfo (planstate=planstate@entry=0xed7d40,
inputDesc=inputDesc@entry=0xe9baf0)at execUtils.c:501
 
#5  0x00000000006371c6 in ExecConditionalAssignProjectionInfo (planstate=planstate@entry=0xed7d40, inputDesc=0xe9baf0,
varno=<optimizedout>) at execUtils.c:539
 
#6  0x0000000000632627 in ExecAssignScanProjectionInfo (node=node@entry=0xed7d40) at execScan.c:240
#7  0x0000000000655867 in ExecInitSeqScan (node=node@entry=0xeecbb8, estate=estate@entry=0xed78d8,
eflags=eflags@entry=16)at nodeSeqscan.c:182
 
#8  0x0000000000630e53 in ExecInitNode (node=0xeecbb8, estate=estate@entry=0xed78d8, eflags=eflags@entry=16) at
execProcnode.c:207
#9  0x000000000064c78a in ExecInitLimit (node=node@entry=0xeecc50, estate=estate@entry=0xed78d8,
eflags=eflags@entry=16)at nodeLimit.c:368
 
#10 0x0000000000630b52 in ExecInitNode (node=node@entry=0xeecc50, estate=estate@entry=0xed78d8, eflags=eflags@entry=16)
atexecProcnode.c:363
 
#11 0x000000000062ac45 in InitPlan (eflags=16, queryDesc=<optimized out>) at execMain.c:1025
#12 standard_ExecutorStart (queryDesc=<optimized out>, eflags=16) at execMain.c:265
#13 0x0000000000784fdb in PortalStart (portal=portal@entry=0xe48528, params=params@entry=0x0, eflags=eflags@entry=0,
snapshot=snapshot@entry=0x0)at pquery.c:520
 
#14 0x0000000000781218 in exec_simple_query (query_string=0xe56568 "SELECT start_time,site_id,sect_id,rnc_id,utrancell
FROMchild.daily_eric_umts_rnc_utrancell_view_201801 LIMIT 1\n") at postgres.c:1176
 
#15 0x00000000007825c2 in PostgresMain (argc=argc@entry=17, argv=argv@entry=0xddbb40, dbname=0xdfcd70 "postgres",
dbname@entry=0x0,username=<optimized out>) at postgres.c:4243
 
#16 0x000000000047d8be in main (argc=17, argv=0xddbb40) at main.c:224

#0  errfinish (dummy=dummy@entry=0) at elog.c:411
#1  0x0000000000895379 in elog_finish (elevel=elevel@entry=20, fmt=fmt@entry=0xaabf68 "invalid memory alloc request
size%zu") at elog.c:1365
 
#2  0x00000000008bb46e in palloc (size=18446744073709551613) at mcxt.c:934
#3  0x000000000086ad3a in text_to_cstring (t=0x7fffe7b83344) at varlena.c:189
#4  0x0000000000897ed5 in FunctionCall1Coll (flinfo=flinfo@entry=0x7fffffffdce0, collation=collation@entry=0,
arg1=arg1@entry=140737080996676)at fmgr.c:1123
 
#5  0x0000000000899206 in OutputFunctionCall (val=140737080996676, flinfo=0x7fffffffdce0) at fmgr.c:1755
#6  OidOutputFunctionCall (functionId=<optimized out>, val=val@entry=140737080996676) at fmgr.c:1838
#7  0x000000000048b57b in debugtup (slot=0xed8330, self=<optimized out>) at printtup.c:625
#8  0x0000000000629a50 in ExecutePlan (execute_once=<optimized out>, dest=0xa66160 <debugtupDR>, direction=<optimized
out>,numberTuples=0, sendTuples=true, operation=CMD_SELECT, use_parallel_mode=<optimized out>, 
 
    planstate=0xed7ad0, estate=0xed7878) at execMain.c:1748
#9  standard_ExecutorRun (queryDesc=0xe6ac78, direction=<optimized out>, count=0, execute_once=<optimized out>) at
execMain.c:364
#10 0x000000000078409b in PortalRunSelect (portal=portal@entry=0xe484c8, forward=forward@entry=true, count=0,
count@entry=9223372036854775807,dest=dest@entry=0xa66160 <debugtupDR>) at pquery.c:932
 
#11 0x00000000007855b8 in PortalRun (portal=portal@entry=0xe484c8, count=count@entry=9223372036854775807,
isTopLevel=isTopLevel@entry=true,run_once=run_once@entry=true, dest=dest@entry=0xa66160 <debugtupDR>, 
 
    altdest=altdest@entry=0xa66160 <debugtupDR>, completionTag=completionTag@entry=0x7fffffffdfc0 "") at pquery.c:773
#12 0x000000000078128d in exec_simple_query (query_string=0xe56508 "SELECT
start_time,site_id,sect_id,rnc_id,utrancell,eul_harq_ps_trans_tti2_1FROM
child.daily_eric_umts_rnc_utrancell_view_201801LIMIT 1;\n")
 
    at postgres.c:1215
#13 0x00000000007825c2 in PostgresMain (argc=argc@entry=15, argv=argv@entry=0xddbb40, dbname=0xdfcd30 "postgres",
dbname@entry=0x0,username=<optimized out>) at postgres.c:4243
 
#14 0x000000000047d8be in main (argc=15, argv=0xddbb40) at main.c:224

Justin