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
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 |