Materialized view assertion failure in HEAD

Поиск
Список
Период
Сортировка
От Joachim Wieland
Тема Materialized view assertion failure in HEAD
Дата
Msg-id CACw0+10dJLX6uSTO-uV87Ly1DX_egf1eSHCio1Cxm+=64==UhA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Materialized view assertion failure in HEAD  (Kevin Grittner <kgrittn@ymail.com>)
Re: Materialized view assertion failure in HEAD  (Kevin Grittner <kgrittn@ymail.com>)
Список 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 по дате отправления:

Предыдущее
От: Joachim Wieland
Дата:
Сообщение: Re: parallel pg_dump
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: odd behavior in materialized view