Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfFnN-00GTVt-TE for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Feb 2024 09:00:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rfFnL-008s9S-Bq for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Feb 2024 09:00:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfFnK-008s9K-VT for pgsql-bugs@lists.postgresql.org; Wed, 28 Feb 2024 09:00:07 +0000 Received: from mail-lj1-x232.google.com ([2a00:1450:4864:20::232]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rfFnH-001kL8-FD for pgsql-bugs@lists.postgresql.org; Wed, 28 Feb 2024 09:00:06 +0000 Received: by mail-lj1-x232.google.com with SMTP id 38308e7fff4ca-2d208be133bso79412741fa.2 for ; Wed, 28 Feb 2024 01:00:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1709110803; x=1709715603; darn=lists.postgresql.org; h=in-reply-to:from:content-language:references:to:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=xiDxCgEeXYVxXi+pWSPmILdJ7zL3P4JZ+p0fKEncgdw=; b=iQxokAKrnS9SHJP4C7nh932inUr+boqKqWLmT41Q3K13szLNqYyuZtB90h0Iha/8u7 VfPWAywe3pEAywQhh/72GCEEhUPCclU7mD8zCi0WLjDEDdVjnaWWolIgi3sx1/8QPQeE /B2+Jar8sq1xv0YI/la0+7adtMHecGiYQ5nKNyfCw2w206ddDc+O2RY4lKx5sZCnA93B 7PssBaeqC43iKlbL520s7LZgF0UJ1SZlcQ+QeUVZjDz8G614YDLqNgo5ps7qejuO0V09 Y3gbfH61Q6Ja9bNIHHMoNIWYKfEkIH1398DRefLIvZaoTwsxgk5V5d+hRAjdSyvcYYBH L1MQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1709110803; x=1709715603; h=in-reply-to:from:content-language:references:to:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=xiDxCgEeXYVxXi+pWSPmILdJ7zL3P4JZ+p0fKEncgdw=; b=MmcmSGbVXjYEAmQa7nshgNyMCwXJFm1WrpXZpCmEBDVnX3FK+bUAt7EG56m1Ig2Cpt EWzk+x8rGoJaTghaoRo/pDWf6jM6mLBF+k6zbBf4WyrN8UEzYM6Xw3RhyP502fYuqUw3 5jUopm4kuosLq7mxMwoxQra5TTC/+Mczmw5xt2YIkHuV2w9R5ZklzAZ667OFF6cBKKXe TOHy6d36Rd4/qeN0pI1LgB8YfAHc3UGRFHU/PqqnMkSGdsLHnULb7m+6SUse6cdGAIo1 RLvG7TbWwVyZHiMVr4TTmRqqNk/KWtC5bPlGfD89drKM8FTLvOs9HpwELOEiVPYQOVXg fY7Q== X-Forwarded-Encrypted: i=1; AJvYcCWX1LG4zZjgszrWMEofKT+tTJMF64cV7TPC12MVp3BTYJ1U+ERkm1OfOLXmIMCxabbn0pY7LqKUcG3balePFqt2Ai9ByXw/Yu9XTVBvyu3T X-Gm-Message-State: AOJu0YxBQM1FGERHCtHXdQW+uycR/YoVx7BzsQGkUQTGPPeB0WWVrmrT 03GCTrzwREsGn5vIqH+RLfKIDvSBwfSu7gKi0ibtjNLogXupINex X-Google-Smtp-Source: AGHT+IHlU7TUV6k3lWSsXKMRqW8GVr5zwU2SbP7q4WNN4hxlDauSekZTYk/ze4JR6fXPDr2FKIfg0Q== X-Received: by 2002:a2e:a4d6:0:b0:2d2:c98b:fe6e with SMTP id p22-20020a2ea4d6000000b002d2c98bfe6emr585505ljm.33.1709110802603; Wed, 28 Feb 2024 01:00:02 -0800 (PST) Received: from [1.0.0.7] ([178.155.28.213]) by smtp.gmail.com with ESMTPSA id x8-20020a2e7c08000000b002d0a7ba3215sm1545069ljc.85.2024.02.28.01.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 28 Feb 2024 01:00:02 -0800 (PST) Content-Type: multipart/alternative; boundary="------------gCdV5XocSRY3SSeZopUcEyJ4" Message-ID: Date: Wed, 28 Feb 2024 12:00:00 +0300 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: BUG #18369: logical decoding core on AssertTXNLsnOrder() To: ocean_li_996 , pgsql-bugs@lists.postgresql.org References: <18369-ad61699bf91c5bc0@postgresql.org> <6d0e80d6.c1fc.18deeb8120a.Coremail.ocean_li_996@163.com> <3d696d51.cfa6.18deeccd483.Coremail.ocean_li_996@163.com> Content-Language: en-US From: Alexander Lakhin In-Reply-To: <3d696d51.cfa6.18deeccd483.Coremail.ocean_li_996@163.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------gCdV5XocSRY3SSeZopUcEyJ4 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Hello Haiyang Li, 28.02.2024 11:20, ocean_li_996 wrote: > > This issue exists in PG 12 -15. > > At 2024-02-28 15:57:37, "ocean_li_996" wrote: > > At 2024-02-28 15:53:30, "PG Bug reporting form" wrote: > > >1) The WAL records from restart_lsn to the corresponding lsn when the issue > >occurred, > >2) personal analysis of the problem, > >3) the steps to reproduce the issue, > >4) personal proposed solution > >will be posted later under this thread. > > > Please see the similar issue discussed last year: https://www.postgresql.org/message-id/f158d9ca-2057-2836-a522-0b1278be5a53%40gmail.com With your patch applied (on REL_14_STABLE) I still get: TRAP: FailedAssertion("builder->next_phase_at == InvalidTransactionId", File: "snapbuild.c", Line: 1623, PID: 92772) when running make -s installcheck-force -C contrib/test_decoding... as specified in that message. (You might need to disable REGRESS tests in the Makefile to reach isolation tests.) Best regards, Alexander --------------gCdV5XocSRY3SSeZopUcEyJ4 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
Hello Haiyang Li,

28.02.2024 11:20, ocean_li_996 wrote:

This issue exists in PG 12 -15.

At 2024-02-28 15:57:37, "ocean_li_996" <ocean_li_996@163.com> wrote:

At 2024-02-28 15:53:30, "PG Bug reporting form" <noreply@postgresql.org> wrote:

>1) The WAL records from restart_lsn to the corresponding lsn when the issue
>occurred,
>2) personal analysis of the problem,
>3) the steps to reproduce the issue,
>4) personal proposed solution
>will be posted later under this thread.

>

Please see the similar issue discussed last year:
https://www.postgresql.org/message-id/f158d9ca-2057-2836-a522-0b1278be5a53%40gmail.com

With your patch applied (on REL_14_STABLE) I still get:
TRAP: FailedAssertion("builder->next_phase_at == InvalidTransactionId", File: "snapbuild.c", Line: 1623, PID: 92772)

when running make -s installcheck-force -C contrib/test_decoding...
as specified in that message.
(You might need to disable REGRESS tests in the Makefile to reach
isolation tests.)

Best regards,
Alexander
--------------gCdV5XocSRY3SSeZopUcEyJ4--