Materialized view assertion failure in HEAD - Mailing list pgsql-hackers

From Joachim Wieland
Subject Materialized view assertion failure in HEAD
Date
Msg-id CACw0+10dJLX6uSTO-uV87Ly1DX_egf1eSHCio1Cxm+=64==UhA@mail.gmail.com
Whole thread Raw
Responses Re: Materialized view assertion failure in HEAD  (Kevin Grittner <kgrittn@ymail.com>)
Re: Materialized view assertion failure in HEAD  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-hackers
I'm getting an assertion failure in HEAD with materialized views, see
below for backtrace.

To reproduce, just run make installcheck, dump the regression database
and then restore it, the server crashes during restore.

(gdb) bt
#0  0x00007f283a366425 in raise () from /lib/x86_64-linux-gnu/libc.so.6
#1  0x00007f283a369b8b in abort () from /lib/x86_64-linux-gnu/libc.so.6
#2  0x0000000000888429 in ExceptionalCondition (   conditionName=0xa0c840 "!(!matviewRel->rd_rel->relhasoids)",
errorType=0xa0c78a"FailedAssertion", fileName=0xa0c780 "matview.c",   lineNumber=135) at assert.c:54
 
#3  0x00000000005dbfc4 in ExecRefreshMatView (stmt=0x1b70a28,   queryString=0x1b6ff98 "REFRESH MATERIALIZED VIEW
tvmm;\n\n\n",params=0x0,   completionTag=0x7fff47af0a60 "") at matview.c:135
 
#4  0x00000000007758a5 in standard_ProcessUtility (parsetree=0x1b70a28,   queryString=0x1b6ff98 "REFRESH MATERIALIZED
VIEWtvmm;\n\n\n", params=0x0,   dest=0x1b70da0, completionTag=0x7fff47af0a60 "",   context=PROCESS_UTILITY_TOPLEVEL) at
utility.c:1173
#5  0x0000000000773e3f in ProcessUtility (parsetree=0x1b70a28,   queryString=0x1b6ff98 "REFRESH MATERIALIZED VIEW
tvmm;\n\n\n",params=0x0,   dest=0x1b70da0, completionTag=0x7fff47af0a60 "",   context=PROCESS_UTILITY_TOPLEVEL) at
utility.c:341
#6  0x0000000000772d7e in PortalRunUtility (portal=0x1aeb6d8,   utilityStmt=0x1b70a28, isTopLevel=1 '\001',
dest=0x1b70da0,  completionTag=0x7fff47af0a60 "") at pquery.c:1185
 
#7  0x0000000000772f56 in PortalRunMulti (portal=0x1aeb6d8,   isTopLevel=1 '\001', dest=0x1b70da0, altdest=0x1b70da0,
completionTag=0x7fff47af0a60"") at pquery.c:1317
 
#8  0x0000000000772481 in PortalRun (portal=0x1aeb6d8,   count=9223372036854775807, isTopLevel=1 '\001',
dest=0x1b70da0,  altdest=0x1b70da0, completionTag=0x7fff47af0a60 "") at pquery.c:814
 
#9  0x000000000076c155 in exec_simple_query (   query_string=0x1b6ff98 "REFRESH MATERIALIZED VIEW tvmm;\n\n\n")   at
postgres.c:1048
#10 0x0000000000770517 in PostgresMain (argc=2, argv=0x1ab4bb0,   username=0x1ab4a88 "joe") at postgres.c:3969
#11 0x000000000070ccec in BackendRun (port=0x1ae5ac0) at postmaster.c:3989
#12 0x000000000070c401 in BackendStartup (port=0x1ae5ac0) at postmaster.c:3673
#13 0x0000000000708ce6 in ServerLoop () at postmaster.c:1575
#14 0x0000000000708420 in PostmasterMain (argc=3, argv=0x1ab2420)   at postmaster.c:1244
#15 0x00000000006704f7 in main (argc=3, argv=0x1ab2420) at main.c:197



pgsql-hackers by date:

Previous
From: Joachim Wieland
Date:
Subject: Re: parallel pg_dump
Next
From: Fujii Masao
Date:
Subject: Re: odd behavior in materialized view