Materialized view assertion failure in HEAD

From: Joachim Wieland <joe(at)mcknight(dot)de>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Materialized view assertion failure in HEAD
Date: 2013-03-05 12:50:42
Message-ID: CACw0+10dJLX6uSTO-uV87Ly1DX_egf1eSHCio1Cxm+=64==UhA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 VIEW tvmm;\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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2013-03-05 13:12:46 Re: odd behavior in materialized view
Previous Message Joachim Wieland 2013-03-05 12:30:08 Re: parallel pg_dump