Consistent segfault in complex query

2018-09-12 Thread Kyle Samson
60967 "", isDone=0x2c60c4c) at execQual.c:2985
#4  0x005878c3 in ExecTargetList (projInfo=, 
isDone=0x7ffc571d9b0c) at execQual.c:5322
#5  ExecProject (projInfo=, isDone=0x7ffc571d9b0c) at 
execQual.c:5537
#6  0x0058dd62 in ExecScan (node=0x2c4ffb0, accessMtd=0x599340 
, recheckMtd=0x5992f0 ) at execScan.c:207
#7  0x00586e28 in ExecProcNode (node=0x2c4ffb0) at 
execProcnode.c:404
#8  0x00584472 in EvalPlanQualNext (epqstate=) 
at execMain.c:2366
#9  0x00584b47 in EvalPlanQual (estate=0x2bdd240, 
epqstate=0x2c0d638, relation=, rti=1, lockmode=, tid=0x7ffc571d9c60, priorXmax=2185728490) at execMain.c:1951
#10 0x0059d7cb in ExecUpdate (node=0x2c0d598) at 
nodeModifyTable.c:727
#11 ExecModifyTable (node=0x2c0d598) at nodeModifyTable.c:997
#12 0x00586e78 in ExecProcNode (node=0x2c0d598) at 
execProcnode.c:377
#13 0x00585a82 in ExecutePlan (queryDesc=0x2bdd000, 
direction=, count=0) at execMain.c:1488
#14 standard_ExecutorRun (queryDesc=0x2bdd000, direction=, count=0) at execMain.c:318
#15 0x7f2e5f3b358b in explain_ExecutorRun (queryDesc=0x2bdd000, 
direction=ForwardScanDirection, count=0) at auto_explain.c:231
#16 0x7f2e5f1af495 in pgss_ExecutorRun (queryDesc=0x2bdd000, 
direction=ForwardScanDirection, count=0) at pg_stat_statements.c:716
#17 0x0066553f in ProcessQuery (plan=0x2be32b0, 
sourceText=0x2be7fe0 "WITH tmp(foo2, bar2, baz2, minutes2) AS ( SELECT ARRAY[$1 
::text], ARRAY[$2 ::text], ARRAY[$3 ::text], $4 ::double precision ) UPDATE 
table_name SET occurrences = CAS"..., params=0x2bdce30, dest=, completionTag=0x7ffc571da2f0 "") at pquery.c:185
#18 0x0066576f in PortalRunMulti (portal=0x2bd2530, isTopLevel=1 
'\001', dest=0xb1d380, altdest=0xb1d380, completionTag=0x7ffc571da2f0 "") at 
pquery.c:1275
#19 0x00665e32 in PortalRun (portal=0x2bd2530, 
count=9223372036854775807, isTopLevel=1 '\001', dest=0x2ba30b0, 
altdest=0x2ba30b0, completionTag=0x7ffc571da2f0 "") at pquery.c:812
#20 0x0066409d in exec_execute_message (argc=, 
argv=, dbname=0x2965280 "database_name", username=) at postgres.c:1958
#21 PostgresMain (argc=, argv=, 
dbname=0x2965280 "database_name", username=) at 
postgres.c:4154
#22 0x0061df38 in BackendRun (argc=, 
argv=) at postmaster.c:4194
#23 BackendStartup (argc=, argv=) 
at postmaster.c:3857
#24 ServerLoop (argc=, argv=) at 
postmaster.c:1702
#25 PostmasterMain (argc=, argv=) 
at postmaster.c:1326
#26 0x005b92f8 in main (argc=5, argv=0x2964470) at main.c:234

fcinfo contents from the arraycontains in frame #1

    (gdb) print *fcinfo
$1 = {flinfo = 0x2c56de0, context = 0x0, resultinfo = 0x0, fncollation = 
100, isnull = 0 '\000', nargs = 2, arg = {46431788, 0 }, 
argnull = '\000' }

- Kyle Samson


Re: found xmin from before relfrozenxid on pg_catalog.pg_authid

2018-08-08 Thread Kyle Samson
Hello,

We found the exact same issue on a production database at TripAdvisor. We have 
no new information to add for debugging. Bumping this to up the priority on a 
patch version release getting out.

Thanks,
-Kyle Samson