Horton

Re: BUG #16036: Segmentation fault while doing an update

Антон Власов <druidvav@gmail.com>

View thread View on postgr.es
From: Антон Власов <druidvav@gmail.com>
To: Andres Freund <andres@anarazel.de>
Cc: pgsql-bugs@lists.postgresql.org, PG Bug reporting form <noreply@postgresql.org>
Date: 2019-10-04T01:45:53Z
Lists: pgsql-bugs 
Tried with default debian configuration - problem persists. I’ve got full backtrace when reduced shared_buffers from 18G to 1G. Tried to simulate the problem in artificial environment, but cannot repeat it.
On real data it is 100% repeatable.

> 4 окт. 2019 г., в 4:20, Andres Freund <andres@anarazel.de> написал(а):
> 
> Hi, 
> 
> On October 3, 2019 6:14:33 PM PDT, "Антон Власов" <druidvav@gmail.com <mailto:druidvav@gmail.com>> wrote:
>> Hello,
>> 
>> Looks like disabling jit didn’t affect backtrace at all:
>> 
>> 0  GetMemoryChunkContext (pointer=0x0) at
>> ./build/../src/include/utils/memutils.h:127
>> #1  pfree (pointer=0x0) at
>> ./build/../src/backend/utils/mmgr/mcxt.c:1033
>> #2  0x0000555d7276aaca in heap_freetuple (htup=<optimized out>) at
>> ./build/../src/backend/access/common/heaptuple.c:1340
>> #3  0x0000555d72918889 in tts_buffer_heap_clear (slot=0x555d73dbb118)
>> at ./build/../src/backend/executor/execTuples.c:652
>> #4  0x0000555d72918cbe in ExecClearTuple (slot=0x555d73dbb118) at
>> ./build/../src/include/executor/tuptable.h:428
>> #5  ExecResetTupleTable (tupleTable=0x555d73db5a10, shouldFree=false)
> 
> That's good - I was only looking at that because of the truncated backtrace. Did you do anything to make that work better this time?
> 
> Are there any details that you can provide? Schema? Any extensions in use? 
> 
> Does the problem happen always, or just under concurrency?
> 
> Andres
> -- 
> Sent from my Android device with K-9 Mail. Please excuse my brevity.

Commits

  1. Disable one more set of tests from c8841199509.

  2. Disable one set of tests from c8841199509.

  3. Add isolation tests for the combination of EPQ and triggers.

  4. Fix crash caused by EPQ happening with a before update trigger present.

  5. Modify the isolation tester so that multiple sessions can wait.