Re: BUG #16205: background worker "logical replication worker" (PID 25218) was terminated by signal 11: Segmentation

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Mahendra Singh Thalor <mahi6run(at)gmail(dot)com>
Cc: Pendekar Dikala Senja <pendekar(dot)senja(at)outlook(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #16205: background worker "logical replication worker" (PID 25218) was terminated by signal 11: Segmentation
Date: 2020-01-16 18:46:55
Message-ID: 5D4B088D-98A1-4A3D-A048-B87AFBAF15E8@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

We've been encountering the same bug; here's a stack trace from the crashed process:

(gdb) bt
#0 __memmove_avx_unaligned_erms () at ../sysdeps/x86_64/multiarch/memmove-vec-unaligned-erms.S:427
#1 0x00005582bda1fb57 in memcpy (__len=425318492, __src=<optimized out>, __dest=<optimized out>) at /usr/include/x86_64-linux-gnu/bits/string_fortified.h:34
#2 tts_virtual_materialize (slot=0x5582bebca418) at ./build/../src/backend/executor/execTuples.c:235
#3 0x00005582bda21179 in ExecFetchSlotHeapTuple (slot=0x5582bebca418, materialize=<optimized out>, shouldFree=0x7ffeccfccc37) at ./build/../src/backend/executor/execTuples.c:1624
#4 0x00005582bd8b4e9c in heapam_tuple_update (relation=0x7f0bf1a92430, otid=0x5582bebca6a8, slot=0x5582bebca418, cid=943, snapshot=<optimized out>, crosscheck=0x0, wait=true,
tmfd=0x7ffeccfcccc0, lockmode=0x7ffeccfcccbc, update_indexes=0x7ffeccfccd37) at ./build/../src/backend/access/heap/heapam_handler.c:325
#5 0x00005582bd8e4306 in table_tuple_update (update_indexes=0x7ffeccfccd37, lockmode=0x7ffeccfcccbc, tmfd=0x7ffeccfcccc0, wait=true, crosscheck=0x0, snapshot=0x0,
cid=<optimized out>, slot=0x5582bebca418, otid=0x5582bebca6a8, rel=0x7f0bf1a92430) at ./build/../src/include/access/tableam.h:1261
#6 simple_table_tuple_update (rel=0x7f0bf1a92430, otid=otid(at)entry=0x5582bebca6a8, slot=slot(at)entry=0x5582bebca418, snapshot=0x0, update_indexes=update_indexes(at)entry=0x7ffeccfccd37)
at ./build/../src/backend/access/table/tableam.c:325
#7 0x00005582bda1d462 in ExecSimpleRelationUpdate (estate=estate(at)entry=0x5582bebd1970, epqstate=epqstate(at)entry=0x7ffeccfcce10, searchslot=searchslot(at)entry=0x5582bebca678,
slot=slot(at)entry=0x5582bebca418) at ./build/../src/backend/executor/execReplication.c:493
#8 0x00005582bdb1a188 in apply_handle_update (s=s(at)entry=0x7ffeccfd4420) at ./build/../src/backend/replication/logical/worker.c:750
#9 0x00005582bdb1affe in apply_dispatch (s=0x7ffeccfd4420) at ./build/../src/backend/replication/logical/worker.c:968
#10 LogicalRepApplyLoop (last_received=8839008698464) at ./build/../src/backend/replication/logical/worker.c:1176
#11 ApplyWorkerMain (main_arg=<optimized out>) at ./build/../src/backend/replication/logical/worker.c:1734
#12 0x00005582bdae972e in StartBackgroundWorker () at ./build/../src/backend/postmaster/bgworker.c:834
#13 0x00005582bdaf579c in do_start_bgworker (rw=0x5582beafcca0) at ./build/../src/backend/postmaster/postmaster.c:5770
#14 maybe_start_bgworkers () at ./build/../src/backend/postmaster/postmaster.c:5996
#15 0x00005582bdaf6235 in sigusr1_handler (postgres_signal_arg=<optimized out>) at ./build/../src/backend/postmaster/postmaster.c:5167
#16 <signal handler called>
#17 0x00007f1013bfaff7 in __GI___select (nfds=nfds(at)entry=8, readfds=readfds(at)entry=0x7ffeccfd5470, writefds=writefds(at)entry=0x0, exceptfds=exceptfds(at)entry=0x0,
timeout=timeout(at)entry=0x7ffeccfd53d0) at ../sysdeps/unix/sysv/linux/select.c:41
#18 0x00005582bdaf67db in ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1668
#19 0x00005582bdaf8513 in PostmasterMain (argc=5, argv=0x5582beaaa090) at ./build/../src/backend/postmaster/postmaster.c:1377
#20 0x00005582bd86ecf6 in main (argc=5, argv=0x5582beaaa090) at ./build/../src/backend/main/main.c:228
(gdb)
--
-- Christophe Pettus
xof(at)thebuild(dot)com

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2020-01-16 22:36:16 BUG #16212: subquery block allows to overwrite table alias defined earlier
Previous Message David G. Johnston 2020-01-16 16:49:24 Re: BUG #16210: Space