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 1tnaSj-006YBi-FS for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Feb 2025 09:45:49 +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 1tnaSh-00AV6p-SJ for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Feb 2025 09:45:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tnaSh-00AV3R-IC for pgsql-hackers@lists.postgresql.org; Thu, 27 Feb 2025 09:45:47 +0000 Received: from mail-ed1-x533.google.com ([2a00:1450:4864:20::533]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tnaSe-000MM4-1K for pgsql-hackers@postgresql.org; Thu, 27 Feb 2025 09:45:47 +0000 Received: by mail-ed1-x533.google.com with SMTP id 4fb4d7f45d1cf-5e08064b4ddso835027a12.1 for ; Thu, 27 Feb 2025 01:45:44 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1740649544; x=1741254344; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=jyQ/HThF4AHO3ciE0KpjLeMLSpASYGCIQZroP6y4QbA=; b=C6T2Z9P906Aal8CwuGwD2eNdVhrfUvMQeXd4nC6DpAigZ4R4oAi26/M+vyvq1hWBAt hKYFUprXTCXNDMGA5MohBC6jApQ0VhGG/+MGDkY8EJoqn3QZbQ6akKZSsEh+WCTlhA/b T/m/2N1wYq6Bji4O02wiJ1jiIZxeuu94HtDSgGKpUMxaTtMAX47pVEKTYSQL0RFv8kwU NSAvwl5hI4mTUi34pwupwWdZOQxTOVokkh9aknnLC4Ap3oJR//ufePUuzyT9Y/QS8x+j B7E9/Z2rRmzVLkIBDJrU1O3yaYmBtNtrPNhw0RPCCIvFxKhlcv8ntMhwO8H/Sxv0fJyB VYoA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740649544; x=1741254344; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=jyQ/HThF4AHO3ciE0KpjLeMLSpASYGCIQZroP6y4QbA=; b=Dz+UP73fteodI/juBmt0o+b/QO1DfP4/ecXUtMpXPiauuRXvhghg64ltp3U6IePFiV AXNKjjXVXtboCpQiliV+O+zCwQ4xNii0kticLsAXOCZ8BXXiBXuZEPHiSVRaDQmU1J2+ XeaW3f3VxohM/WvaqsC0CjbdjqMghwKw5HW2j5UKEJo41TuASNzUaLjU8TrCuDhu6w4K NgkkB9VV5irMHzicPBlCH02efnmfCc1vreeeCAA0+YkC3esvPCjGfdEvhnKdrlk0pfdl E6B3Xdma4MFAFQxUdGqzhByGnT4P1rwrXUnaPbYiWQFxyXyW8NjDj+Uye1pXZCnnYB8+ TD1g== X-Forwarded-Encrypted: i=1; AJvYcCWN1tYi5YWjaHMOKKvxUFLO0h374c6dszB7sgrFcw3ZL8A+i0wudTsVnBwlfebRS+cPLcQpaNrHDwV8Tb1O@postgresql.org X-Gm-Message-State: AOJu0YzBt3sU7M/peBi/w8WrPcqgAw0hJ0NwiEMpu7Mo1ngMlQeV20e7 2XEs70YJsyMujsYqvd8aGsMaIf8hwebJnrdXvMoyqFdG1JhU2MLm5nPlEBQujFNWNY2J5nX2JrP VIdSNM8K0ysTt9P+fo3oYP+Uq2nk= X-Gm-Gg: ASbGnctSm3pDRurV8YeLfjycj2yzJDbcbDrnHrisjO0HpGoYW9jAEx0R5kURyYlI/aZ vVRkDm5ub1hlk5EYUKp1g7Iy3jo/PLEP7ebAHKa7Ewm89xjgxrqzCT5CTf/asToD28bQDvEV4qU iYuAC2drc= X-Google-Smtp-Source: AGHT+IEiWEYJ4opgLN4XvFFwz8V2ePBwfacDBwEzD9eBpvhYR0a71D1vL9efpXzSCS5CwlhQN0TFWpwChd8+LD1UIH4= X-Received: by 2002:a05:6402:3705:b0:5d9:fbb5:9ee with SMTP id 4fb4d7f45d1cf-5e0b70de93dmr24146635a12.13.1740649543373; Thu, 27 Feb 2025 01:45:43 -0800 (PST) MIME-Version: 1.0 References: <67f7132d-3923-47a6-9de2-5b7d86ddb73f@vondra.me> <53bcd88f-2b25-4a7a-949b-64f2960cfc62@vondra.me> In-Reply-To: From: Alexander Korotkov Date: Thu, 27 Feb 2025 11:45:32 +0200 X-Gm-Features: AQ5f1Job4GXeS5pv-t8ORxZEvsHAZYGiTrcxg4h0A4vaC2R_9quQkfNXideYjXI Message-ID: Subject: Re: suspicious lockup on widowbird in AdvanceXLInsertBuffer (could it be due to 6a2275b8953?) To: Peter Geoghegan Cc: Tomas Vondra , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Feb 27, 2025 at 12:24=E2=80=AFAM Peter Geoghegan wrote= : > > On Wed, Feb 26, 2025 at 5:16=E2=80=AFPM Tomas Vondra wr= ote: > > Oh, I forgot about that. I guess if the theory is the commit might be > > causing this, and it's been already reverted, I should just restart the > > instance, so that it tests with the revert. > > According to the revert commit's commit message there was also > problems on batta at the time. Might have been the same issue that you > saw on widowbird. Alexander? Yes, the backtrace posted by Tomas from widowbird looks quite the same as posted by Michael from batta. My apologies for committing not well-tested patch. ------ Regards, Alexander Korotkov Supabase