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 1v6twN-00BZ8m-FW for pgsql-bugs@arkaria.postgresql.org; Thu, 09 Oct 2025 16:56:31 +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 1v6twL-007Uqm-7N for pgsql-bugs@arkaria.postgresql.org; Thu, 09 Oct 2025 16:56:30 +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 1v6twK-007Uqd-Qc for pgsql-bugs@lists.postgresql.org; Thu, 09 Oct 2025 16:56:29 +0000 Received: from mail-pf1-x433.google.com ([2607:f8b0:4864:20::433]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v6twI-000tYU-1b for pgsql-bugs@lists.postgresql.org; Thu, 09 Oct 2025 16:56:28 +0000 Received: by mail-pf1-x433.google.com with SMTP id d2e1a72fcca58-78f3bfe3f69so1171047b3a.2 for ; Thu, 09 Oct 2025 09:56:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1760028986; x=1760633786; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=rbs/w3YqPbmGtMpwS5dkxFEqylKkKWak60X22Hq3rnc=; b=xiUWYhnrfotwV1OBnHouOp8k7v2CXYGkAD9FvCk8K0zl34IyuzkA58JOVOzw6rQnrU Q2phSbz27On4AOwVwIPR782av+X12tP29B9PIl185EA27Gf+XaRm2iY1R9HzcXjS//jy f5TyQ4iGn/02GKfnb4NMJYsiK+w95YB2QmDUjKHelZgw3tl732NuEoF/Me5bEp5EtTeZ mDI4LZlGkyPnEWUL42VKv4iti8WeXNqzmTnI3UxgSByVSmwfNUTAZzhntnq9JINTTVLL x36HCYaKBYtQrTFqvxBFz9aMT2spJ/OuXebthP1seqyP8xNQehudWvHjXdzJKkPeh35h tx2w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760028986; x=1760633786; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=rbs/w3YqPbmGtMpwS5dkxFEqylKkKWak60X22Hq3rnc=; b=aOvCH0TrZEjWV0HMeWTlb69DTxJES91lJkVgQ9ezbq8+gtMH/mlWLFxAemPG/k8MsI 54za1G8vFw2EC7T+mM7IjP3nzLDU3+vTFKJMcSK+4Y64Sa9gMN6UIGm9YPZ0XO4G5TbB 6l7XVizCjFulcOVswH2VgvKVDzmJbQE04AOnRzuSgNaiI6GfVSkr0TiV5Ph0RvMemL2H RZabOTRsrv5q0R0Cl2M0LhYXxelCLZDruTfOrHFIgiqlyzz0JB3ksBQRyq7iJXB12ZTj OZzyC8mB3JYwoZP8bYbdl4GV12awc0qKGcWyCwuZEorygBgLJdcCuNHHfD9x2yoolC/F 3lGQ== X-Forwarded-Encrypted: i=1; AJvYcCVR9fdEp87JA0NZp9AzSNR1ynQibft0WkH2WCKZiRxTaN+q7kCAhksg1TWxskkX+hy7lNkRBi4MY4xM@lists.postgresql.org X-Gm-Message-State: AOJu0Yx/vraOM/4iFFM9Q/y6TJjo8B9UdJQTn/nO6f2mySk3cTN6DcRM 8joCQw8nPhrK9YfwblWAmcQX+5ifysT4FBdIlcPNdteMoPmqO4uk1nfrJPLn6Nd5F6xwxtEYZmY aC4o= X-Gm-Gg: ASbGnctYZ/fdBwHR7TUP22E1N9MiuKxmvvPDynVB7THZm0XVGK7Z0sK3ly1q71dXlqa O4/0oEHb9EUeSbxDk1HnrmJT3ypqu++8FnFiCfKSVxZBEmscHEZ+34qmF93KmMKb5mt0XnvgYQy 2/Q7roabw+2MWF1Q+naZEwXj9atmwf0CfYKTt+Fv5Log60vbqHjwSz6ne6hEqfJ1SVjZ1pkCvaw +mMBiAtkhwnMIEnRZxAOItI4tor8URFeiCjmTOqDWQSM8c8R6QXIncYOmIUTf3UVJalThrEGcT1 KBVvgNIaZvGd59I0j1wCHKMnhAuq5oltgaj3BhX64ar6aVTwnaw3cpPSfBdha2dijVBu35qZfCU kYcpXo85GfNbdzZDs0m6cQKEqOic55iZG0ZofKGyAWHk+OF82EDmTBI2bv82UqxrbEBwnRi5zK8 qmSngSUlkBUDyDhw== X-Google-Smtp-Source: AGHT+IGZ7koZOVpso//dKoQKvWupuXFPmj/49X06muBe41BoMVIQBwgP4dXQnL9Xra4oMkvreD+2PA== X-Received: by 2002:a05:6a00:194d:b0:781:7e1:a315 with SMTP id d2e1a72fcca58-79387c17862mr9123903b3a.22.1760028985991; Thu, 09 Oct 2025 09:56:25 -0700 (PDT) Received: from jeff-ws-bridge.lan (c-24-7-19-3.hsd1.ca.comcast.net. [24.7.19.3]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-7992d0e134fsm211041b3a.58.2025.10.09.09.56.25 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 09 Oct 2025 09:56:25 -0700 (PDT) Message-ID: <614d31c9bef9152f90a60bb968f7e855e6164e9c.camel@j-davis.com> Subject: Re: BUG #19078: Segfaults in tts_minimal_store_tuple() following pg_upgrade From: Jeff Davis To: yuri@yrz.am, pgsql-bugs@lists.postgresql.org Date: Thu, 09 Oct 2025 09:56:24 -0700 In-Reply-To: <19078-dfd62f840a2c0766@postgresql.org> References: <19078-dfd62f840a2c0766@postgresql.org> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.3-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2025-10-09 at 08:35 +0000, PG Bug reporting form wrote: > - Disabled enable_hashagg for some queries (just now) Hi, How sure are you that the crashes are happening without HashAgg? I made some changes in that area in v18, and a lot of the evidence points in that direction. Please let me know if you are able to confirm that the simpler (non-hashagg) plan you showed is actually crashing. Regards, Jeff Davis