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

Michael Paquier <[email protected]> Wed, 15 Jan 2020 11:58:41 +0900
Newsgroups gmane.comp.db.postgresql.bugs
Message-ID <[email protected]>
--qD3brAgIG4LbUq6d
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Wed, Jan 15, 2020 at 02:00:48AM +0000, PG Bug reporting form wrote:
> I got error when replicate with native logical method from PostgreSQL 11.6
> to PostgreSQL 12.1, I will connecting table partition to table partition
> from Version 11.6 to Version 12.1, but after all tables already replicated
> around more than 2 hours, server can't access and recovery mode. please help
> to advice, below log.

Could you provide a backtrace?  Looking at the recent commit history,
we had one fix which could be relevant to you after 12.1 was released:
https://www.postgresql.org/message-id//[email protected]

And here is the commit:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=a2aa224e

The problem may be different though, so a backtrace would be good to
check anyway.
--
Michael

--qD3brAgIG4LbUq6d
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl4ef+EACgkQnvQgOdby
QH0I2A//UthziA/Hs/1p3I5PKig1737Jf6j54YvHyNq/JwR5ttz9y91YR5nH/4Zt
s4/BTAqu3C5A6RmK2kMeAFQ299eDa54cCsAkq5tM+Am/IcgIkekY7i/VTN76m8oQ
+VAoe27q3pOefhM41bk+y691mq16CV19srFVUh4+R7tuXO/BlA/wZbXP2tpAU/P8
Qv0lJQ056rGvxG+Zx2QlCK3mJi2A5jqsWwAf82u4p5WiSsvQS3zBYMMSqEHt5DDn
GO0AvVqEfZb1VeUdg36k4WBzil06HBzOvNGdBTUEKeKzuHtvXwgF9ADvAQEX3yiw
fy7IGksMX9DgBpdMnL4Kzn5kaQXhvsWdwVJDq33s9BCsGIl2D3v3r8iHSaa0gnqY
ovUkbnztbh8VznbKq7LAJhsAbyLY6Qs3luyDfzVF5cXlzi0AJodO8nYMJ3SOfigd
pNEC8eho3vgiOlbgy10K8giXODSbBt+IGhKh3wXqVJ7Of/M8hulxv4aYykZZsAQs
lACjRh8SSP6lUGoOZHu7Dp00ABiyVKHdkareABgqDV4oZBNcLa+O/c2kodrWBNvU
qrOroviK3Oi25Y/HQAtk7LMqQ9x9VX26U70Bxg6t6wdNzOqt+zxsb2wrtZxN59tJ
c1o7HJGB/QGGmnogauum/IJKoNTWhj9keLXHc7LBi1SN8NwP+a4=
=AWSF
-----END PGP SIGNATURE-----

--qD3brAgIG4LbUq6d--