From: | Steve Singer <steve(at)ssinger(dot)info> |
---|---|
To: | PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | PG 12 beta 1 segfault during analyze |
Date: | 2019-06-16 02:05:42 |
Message-ID: | c7988239-d42c-ddc4-41db-171b23b35e4f@ssinger.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I encountered the following segfault when running against a PG 12 beta1
during a analyze against a table.
#0 0x000056008ad0c826 in update_attstats (vacattrstats=0x0,
natts=2139062143, inh=false,
relid=<error reading variable: Cannot access memory at address
0x40>) at analyze.c:572
#1 do_analyze_rel (onerel=onerel(at)entry=0x7f0bc59a7a38,
params=params(at)entry=0x7ffe06aeabb0, va_cols=va_cols(at)entry=0x0,
acquirefunc=<optimized out>, relpages=8, inh=inh(at)entry=false,
in_outer_xact=false, elevel=13) at analyze.c:572
#2 0x000056008ad0d2e0 in analyze_rel (relid=<optimized out>,
relation=<optimized out>,
params=params(at)entry=0x7ffe06aeabb0, va_cols=0x0,
in_outer_xact=<optimized out>, bstrategy=<optimized out>)
at analyze.c:260
#3 0x000056008ad81300 in vacuum (relations=0x56008c4d1110,
params=params(at)entry=0x7ffe06aeabb0,
bstrategy=<optimized out>, bstrategy(at)entry=0x0,
isTopLevel=isTopLevel(at)entry=true) at vacuum.c:413
#4 0x000056008ad8197f in ExecVacuum
(pstate=pstate(at)entry=0x56008c5c2688, vacstmt=vacstmt(at)entry=0x56008c3e0428,
isTopLevel=isTopLevel(at)entry=true) at vacuum.c:199
#5 0x000056008af0133b in standard_ProcessUtility (pstmt=0x56008c982e50,
queryString=0x56008c3df368 "select
\"_disorder_replica\".finishTableAfterCopy(3); analyze
\"disorder\".\"do_inventory\"; ", context=<optimized out>, params=0x0,
queryEnv=0x0, dest=0x56008c9831d8, completionTag=0x7ffe06aeaef0 "")
at utility.c:670
#6 0x000056008aefe112 in PortalRunUtility (portal=0x56008c4515f8,
pstmt=0x56008c982e50, isTopLevel=<optimized out>,
setHoldSnapshot=<optimized out>, dest=<optimized out>,
completionTag=0x7ffe06aeaef0 "") at pquery.c:1175
#7 0x000056008aefec91 in PortalRunMulti
(portal=portal(at)entry=0x56008c4515f8, isTopLevel=isTopLevel(at)entry=true,
setHoldSnapshot=setHoldSnapshot(at)entry=false,
dest=dest(at)entry=0x56008c9831d8, altdest=altdest(at)entry=0x56008c9831d8,
completionTag=completionTag(at)entry=0x7ffe06aeaef0 "") at pquery.c:1328
#8 0x000056008aeff9e9 in PortalRun (portal=portal(at)entry=0x56008c4515f8,
count=count(at)entry=9223372036854775807,
isTopLevel=isTopLevel(at)entry=true, run_once=run_once(at)entry=true,
dest=dest(at)entry=0x56008c9831d8,
altdest=altdest(at)entry=0x56008c9831d8, completionTag=0x7ffe06aeaef0
"") at pquery.c:796
#9 0x000056008aefb6bb in exec_simple_query (
query_string=0x56008c3df368 "select
\"_disorder_replica\".finishTableAfterCopy(3); analyze
\"disorder\".\"do_inventory\"; ") at postgres.c:1215
With master from today(aa087ec64f703a52f3c48c) I still get segfaults
under do_analyze_rel
compute_index_stats (onerel=0x7f84bf1436a8, col_context=0x55a5d3d56640,
numrows=<optimized out>, rows=0x55a5d4039520,
nindexes=<optimized out>, indexdata=0x3ff0000000000000,
totalrows=500) at analyze.c:711
#1 do_analyze_rel (onerel=onerel(at)entry=0x7f84bf1436a8,
params=0x7ffdde2b5c40, params(at)entry=0x3ff0000000000000,
va_cols=va_cols(at)entry=0x0, acquirefunc=<optimized out>,
relpages=11, inh=inh(at)entry=false, in_outer_xact=true,
elevel=13) at analyze.c:552
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-06-16 02:18:54 | Re: PG 12 beta 1 segfault during analyze |
Previous Message | Chapman Flack | 2019-06-16 01:46:55 | Re: The flinfo->fn_extra question, from me this time. |