assertion in 9.4 with wal_level=logical

Поиск
Список
Период
Сортировка
От Steve Singer
Тема assertion in 9.4 with wal_level=logical
Дата
Msg-id BLU0-SMTP69FCBF7F3A6FCDA70FAE74DC520@phx.gbl
обсуждение исходный текст
Ответы Re: assertion in 9.4 with wal_level=logical  (Andres Freund <andres@2ndquadrant.com>)
Re: assertion in 9.4 with wal_level=logical  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
With master/9.4 from today (52e757420fa98a76015c2c88432db94269f3e8f4)

I am getting an assertion when doing a truncate via SPI when I have 
wal_level=logical.

Stack trace is below.

I am just replicating a table with normal slony (2.2) I don't need to 
establish any replication slots to get this.




(gdb) where
#0  0x00007fc9b4f58295 in __GI_raise (sig=sig@entry=6)    at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#1  0x00007fc9b4f5b438 in __GI_abort () at abort.c:90
#2  0x00000000007a10f7 in ExceptionalCondition (    conditionName=conditionName@entry=0x955d90 "!(CritSectionCount == 0

|| (CurrentMemoryContext) == ErrorContext || (MyAuxProcType == 
CheckpointerProcess))",    errorType=errorType@entry=0x7da7b0 "FailedAssertion",    fileName=fileName@entry=0x955a2e
"mcxt.c",
 
lineNumber=lineNumber@entry=670)    at assert.c:54
#3  0x00000000007c3090 in palloc (size=16) at mcxt.c:670
#4  0x00000000004dd83f in mXactCacheGetById (members=0x7fff679a3d18, 
multi=58)    at multixact.c:1411
#5  GetMultiXactIdMembers (multi=58, members=members@entry=0x7fff679a3d18,    allow_old=allow_old@entry=0 '\000') at
multixact.c:1080
#6  0x000000000049e43f in MultiXactIdGetUpdateXid (xmax=<optimized out>,    t_infomask=<optimized out>) at
heapam.c:6042
#7  0x00000000004a1ccc in HeapTupleGetUpdateXid (tuple=<optimized out>)    at heapam.c:6083
#8  0x00000000007cf7d9 in HeapTupleHeaderGetCmax 
(tup=tup@entry=0x7fc9ac838e38)    at combocid.c:122
#9  0x000000000049eb98 in log_heap_new_cid (    relation=relation@entry=0x7fc9b5a67dc0, tup=tup@entry=0x7fff679a3ea0)
at heapam.c:7047
 
#10 0x00000000004a48a5 in heap_update 
(relation=relation@entry=0x7fc9b5a67dc0,    otid=otid@entry=0x2678c6c, newtup=newtup@entry=0x2678c68, cid=26,
crosscheck=crosscheck@entry=0x0,wait=wait@entry=1 '\001',    hufd=hufd@entry=0x7fff679a4080,
lockmode=lockmode@entry=0x7fff679a407c)   at heapam.c:3734
 
#11 0x00000000004a5842 in simple_heap_update (    relation=relation@entry=0x7fc9b5a67dc0, otid=otid@entry=0x2678c6c,
tup=tup@entry=0x2678c68)at heapam.c:4010
 
#12 0x0000000000797cf7 in RelationSetNewRelfilenode (    relation=relation@entry=0x7fc9ab270b68, freezeXid=19459,
minmulti=minmulti@entry=58)at relcache.c:2956
 
#13 0x000000000059ddde in ExecuteTruncate (stmt=0x3a, stmt@entry=0x2678a58)    at tablecmds.c:1187
#14 0x00000000006c3870 in standard_ProcessUtility (parsetree=0x2678a58,    queryString=<optimized out>,
context=<optimizedout>, params=0x0,    dest=<optimized out>, completionTag=<optimized out>) at utility.c:515
 
#15 0x00000000005e79d9 in _SPI_execute_plan 
(plan=plan@entry=0x7fff679a4320,    paramLI=paramLI@entry=0x0, snapshot=snapshot@entry=0x0,
crosscheck_snapshot=crosscheck_snapshot@entry=0x0,   read_only=read_only@entry=0 '\000',
fire_triggers=fire_triggers@entry=1'\001', tcount=tcount@entry=0)    at spi.c:2171
 
#16 0x00000000005e83c1 in SPI_execute (
#16 0x00000000005e83c1 in SPI_execute (
---Type <return> to continue, or q <return> to quit---    src=src@entry=0x25bde90 "truncate only
\"disorder\".\"do_restock\"",   read_only=0 '\000', tcount=tcount@entry=0) at spi.c:386
 



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: New windows compiler warning from 585bca39
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Clock sweep not caching enough B-Tree leaf pages?