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 1utkDM-00DVdn-1Z for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Sep 2025 09:55:40 +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 1utkDL-008dis-8m for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Sep 2025 09:55:39 +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 1utkDK-008dik-Ug for pgsql-hackers@lists.postgresql.org; Wed, 03 Sep 2025 09:55:39 +0000 Received: from mail-wm1-x334.google.com ([2a00:1450:4864:20::334]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1utkDH-000KZI-22 for pgsql-hackers@lists.postgresql.org; Wed, 03 Sep 2025 09:55:38 +0000 Received: by mail-wm1-x334.google.com with SMTP id 5b1f17b1804b1-45b627ea685so53200695e9.1 for ; Wed, 03 Sep 2025 02:55:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1756893335; x=1757498135; darn=lists.postgresql.org; h=message-id:date:content-id:mime-version:comments:references :in-reply-to:subject:cc:to:from:from:to:cc:subject:date:message-id :reply-to; bh=5C+/awP4tBbBX/HZ5GGW3Pq9WvneWRPaNSy1KzcrPsI=; b=MMLt+rz1ioifRb3zjx0Hcte+c+7VdQvZdfwTm0m4pACUPF6A4HLTBoSCuTtssBx8jw YBo2Z4UTvBMwlc1SkXaXJkpZmrzGx4JYTuzzMTTVwDtCDrESZGSsAUOlW7TxFjAzZvO3 dT7vuqTdrFnMdWE/BAH9YLX6QMVaoeT4fkgGcmrRq8yVF92HBy5i8Usai6pn3YlN10Dw QbaABih+z0WkZKxX5jw++EkYNMcuCSWibIVY4NvTdZhV6vL1EYTYNc+LQbuylW72CrHj fR9ujYKAa/yXvhHmFLgDgejSVuGqMLM3VZEHKeydtH73L+2dQhQZRd8JFepFMGODRVSu BaZQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1756893335; x=1757498135; h=message-id:date:content-id:mime-version:comments:references :in-reply-to:subject:cc:to:from:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=5C+/awP4tBbBX/HZ5GGW3Pq9WvneWRPaNSy1KzcrPsI=; b=OlB9cpCIlwDH9cWlZglu4JnudeJrAsAokjCX23G44VDsxzqE3sE91khOaj5BkIuzPS NRoF4fOO1KMey5bBM+e1DykQvSsJLi0g71QMVqZ82RUgovuyUYjGlaTaGsD3nu+t4ibR WMvb5K2Gc0an0/ecopTwjKfRTlFVE0n901z4TTh9Jp+afsYE4D3ggtp7rcvCRnBU0nho H4lLfVm24l4q9FJ+k/TQHWdFUTX4Lb9qX0SrQ4/9KK9OpSoSi0wCqJj6M4S94hm/Zi13 RiRG1GCiAf2+/uKlOWasO8Sr+V37O6zPOXffiXLTn+55xjo5sGF72OoLKpy4GQWIhvhY J4Xg== X-Forwarded-Encrypted: i=1; AJvYcCVWEpAuD4DvNsqN6Cv4/XNdIAi9N7kEd+OmYghKGrothhjjSMM9lchQYH/7XNIiwtUqUWf8nnhcpxpW6WWQ@lists.postgresql.org X-Gm-Message-State: AOJu0Yw0mqmfhAeSO+8HoPdi5K0RRTL7NXGF8fMMSCVo0fenSGsSXnzl JP3hnNJ7pgu7I6MVgMWidDF5SGi80QCJ4fHhTnN/r2ngtvGUVZcOUQ4cFSAK9fjQG6I= X-Gm-Gg: ASbGncuqwa/6Lqk8SOjiUCovMozqSpVTtr/W6FtICGLeLngM2xFvqUGPiEpNr2pwtvt OL2lB/JgjlfF13x6D6/cWCinUrpm3+0pcMchDNHAjcc0N2PD2TvPEexA+jgzaIGat/sxDNZlOAX SEDz1h7QHb8tOeoKkLjND/w1qXGYFdIzrFB/MqKbosrsS0tSjL7JPtdLD9KGIGwhqwgBufeEuoZ 9fefHxLI1aAvIDy5ZEiQOVDGyS/cC+o+1qVoo9yM7vd1h8WF3e3AyZ3aP4qwi1090W/BuOWtROW NyA8hdV/c/PTIV0Z4H12P0I8DLuRZn6VlmCOnyoWgStnsj3BTNoprprSM4mKJysUhf92A9kBkux xLpsiRRegPvSs9VZqZYdANVFa+mx6s/1YeTxJ X-Google-Smtp-Source: AGHT+IF43Yzncy3yB8GzNmxzEOIXWqAQ4I645brWFxWLDs3elDXIRZxrGdJKo6KVSfg4gbZEb77zVg== X-Received: by 2002:a05:600c:4595:b0:45b:73be:c707 with SMTP id 5b1f17b1804b1-45b8559bbddmr113545915e9.22.1756893335593; Wed, 03 Sep 2025 02:55:35 -0700 (PDT) Received: from localhost (109-81-168-144.rct.o2.cz. [109.81.168.144]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-45b72c55c1bsm329857055e9.10.2025.09.03.02.55.34 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 03 Sep 2025 02:55:35 -0700 (PDT) From: Antonin Houska To: Mihail Nikalayeu cc: Alvaro Herrera , Pg Hackers , Robert Treat , Fujii Masao Subject: Re: Adding REPACK [concurrently] In-reply-to: References: <202508301750.cbohxyy2pcce@alvherre.pgsql> <202508311209.gnvpor56qkdc@alvherre.pgsql> <4607.1756703531@localhost> <51329.1756740618@localhost> Comments: In-reply-to Mihail Nikalayeu message dated "Tue, 02 Sep 2025 12:44:27 +0200." X-Mailer: MH-E 8.6+git; nmh 1.8; GNU Emacs 28.3 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <119673.1756893334.1@localhost> Date: Wed, 03 Sep 2025 11:55:34 +0200 Message-ID: <119674.1756893334@localhost> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Mihail Nikalayeu wrote: > While testing MVCC-safe version with stress-tests > 007_repack_concurrently_mvcc.pl I encountered some random crashes with > such logs: > > 25-09-02 12:24:40.039 CEST client backend[261907] > 007_repack_concurrently_mvcc.pl ERROR: relcache reference > 0x7715b9f394a8 is not owned by resource owner TopTransaction > ... > This time I was clever and tried to attempt to reproduce the issue on > a non-MVCC safe version at first - and it is reproducible. Thanks again for a thorough testing! I think this should be fixed separately [1]. [1] https://www.postgresql.org/message-id/119497.1756892972%40localhost -- Antonin Houska Web: https://www.cybertec-postgresql.com