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 1tshXH-004okY-8j for pgsql-hackers@arkaria.postgresql.org; Thu, 13 Mar 2025 12:19:39 +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 1tshXF-00CEAL-OV for pgsql-hackers@arkaria.postgresql.org; Thu, 13 Mar 2025 12:19:37 +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 1tshXF-00CEAD-Ec for pgsql-hackers@lists.postgresql.org; Thu, 13 Mar 2025 12:19:37 +0000 Received: from mail-qt1-x835.google.com ([2607:f8b0:4864:20::835]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tshXD-002brU-0T for pgsql-hackers@lists.postgresql.org; Thu, 13 Mar 2025 12:19:36 +0000 Received: by mail-qt1-x835.google.com with SMTP id d75a77b69052e-47690a4ec97so7983891cf.2 for ; Thu, 13 Mar 2025 05:19:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dunslane-net.20230601.gappssmtp.com; s=20230601; t=1741868374; x=1742473174; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:autocrypt:content-language :from:references:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=jSX1ZlPVta6cUKZV+F+B7B5ufa4npVHVkYU6rLaHv04=; b=NGPL1+rdiuh/rg1P33vvCyvGEER2e6B6ftiVsssZ6y4ZNF33yZowftU3uxi2U6JkcG 7D+nfsW+8KJzkKZrOEIVB/0/YDg+JdsgdnLH0ByVTCM7AJeK7692lfcsb2TlfTjBNsFZ mWO9B+wKHdw5fsSqkjYQ9cy+G0PtmeUxW53AgVjyKphdYt/4vJzV3rOgfG2soQ86M0sQ QNuNgcVMjUyVH5nLAIv7KdAHSZ2ByFpkBzwNHVdQ0vatl6LjmDUGjkQ86VawPvM3dm83 Co/hcxUgroVQPPw9/7P0X6NFhGBNWherNE7MrfKihyNobV7BF8YGVuZa22dyj1N1HN1C I52g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741868374; x=1742473174; h=content-transfer-encoding:in-reply-to:autocrypt:content-language :from:references:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=jSX1ZlPVta6cUKZV+F+B7B5ufa4npVHVkYU6rLaHv04=; b=i/uaTgGen6UNeXKAkHeEItB5VOo8uSiV9iIaig2Kz3lPBtzefpV7XT/HJJ+8sHfqBd g9+5HDaWxBP8lTB9Lg7YLjsWBms4U+eSMD/IvFpnzMy4faZRlzK6FgdXqPl1tsmHB8w3 pcFoWymo4TTl05Te4gZwSqoY4zz3MT+PRj97jcmd6vNKAOH5sDw0D37gl/xQMTd3W4Jt q/TGsVVERLt89CZTgvlNcBqrrd7ucbz9MsgSnDxmbz72dGAQkuEWQ90Lg6EVp81VjqsX hH7B+JH+o94S2LaIoz+2mBUNwe3ldI7lyQcpPym5fWa0CBoWTX4w2/Zjwtcxya1PjIOz xpVA== X-Forwarded-Encrypted: i=1; AJvYcCUJpeurCEdD3CARx9axuKjp0dNf+EKdAZhSb5fI2fvtb29eAfqfXrGAEAHC6evWLaXfw4gXc9HzOn1xQAet@lists.postgresql.org X-Gm-Message-State: AOJu0YzS6XPI81fy8U6rdql0igHE1QLFF2mfoyqMF1OwmBwtjwQ75w40 F4Y0eBf/33is6e29Dc6XWMgkiGXDiorjXWc5Pb2Q6MVn0TGE7fYntNPlISs6fzI= X-Gm-Gg: ASbGncu11MBhuHVn19Ds2o4/0R5yCbXys8L395bxf8ASle+apeDfLDzCAguRUySMnhq DU5jvmXWQ4xN5nmaX+SYQE7tiW1Fiogt2Eq3yE2jH2s+tFvgRNbziMOmtxZWSR0qyKBaM/+z+/5 kcS9gpMd5MWJAv+JrkqvYLyHnPgcfSu8FKunjz3/LncQbrP0/UM7n5ua391tBczaKTgmLTXU5H+ NKDv0taOk0EodYx8ybyn48ZT68PsPZQvWuTDieTFdmu7yA3L/Bz9QARt2kF0ppdN4KftZoGVDSF 3TDW0dwAJIJM1cwvirS15HYN1qEHjCBWq6yXpXWAD/yKbo3zv8sgsZsdTOzaob3loA== X-Google-Smtp-Source: AGHT+IE9aN2M1XV3qtPK/42Eke32/U0HKhVtp0y4iQjxJ/CXGPsA5LOtGDm8BNoeuqZbcsZBNyKHjQ== X-Received: by 2002:a05:622a:1806:b0:476:9548:4734 with SMTP id d75a77b69052e-4769947f428mr145717791cf.6.1741868373855; Thu, 13 Mar 2025 05:19:33 -0700 (PDT) Received: from ?IPV6:2605:a601:a681:6b00::1cb? ([2605:a601:a681:6b00::1cb]) by smtp.googlemail.com with ESMTPSA id d75a77b69052e-476bb673831sm8823141cf.48.2025.03.13.05.19.32 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 13 Mar 2025 05:19:32 -0700 (PDT) Message-ID: <644cf995-e3a5-4f69-9398-7db500e2673d@dunslane.net> Date: Thu, 13 Mar 2025 08:19:31 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Random pg_upgrade 004_subscription test failure on drongo To: vignesh C , PostgreSQL Hackers References: From: Andrew Dunstan Content-Language: en-US Autocrypt: addr=andrew@dunslane.net; keydata= xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB AAHNJEFuZHJldyBEdW5zdGFuIDxhbmRyZXdAZHVuc2xhbmUubmV0PsLAmwQTAQgARQIbAwIX gAIZAQULCQgHAgMiAgEGFQoJCAsCBBYCAwECHgcWIQTkPlhGHfx8v0RpFaWZ+n/LWfw7gQUC ZFlxxwUJGVGAbgAKCRCZ+n/LWfw7gXikB/9ZdcUy6CTBFIIuL/bVsc1eLEW/gJBjJBF6HxNY xgEkAgXAp4Lg4A5U+QB9GouFr7+GYxF0BU4hzoGhNPUWltxnHdMWP8nC/38LAqgMi8L/bbsm HW5YPBdWYaAZAPJQVfOAgjTbRUb26KSprpyrrJKW0ZmrZfjhNPcQ72jpWzoPLQqx2X6B0fru 1jq+cBh8lb6r1mJTim1T3JIn+F/v5VpdQS+EL8xqsHkfzKjIPsW3CIXpkypSk6saA55Rkkbl 26AW8ftPVB0Q6Lnn6FLt9CP0MGNixBQ55yq8r1K+nCBvCCjvQjM8RDm0UUum0WNl+ifQgTLO E8TWEnwVtkBf+3QWzsBNBE7KWFkBCADRnOM0FCzsYW6jtncg+dWIagjUZpvaClmqn/sJluLa Q3v1VXMQJzYs3eC1gh386W+XBwLRpDj3jzH81lX+p73Re3d3oJW7X+ffsxuzu5ZVdMUkqBYo nkAbKxr6gyJ12F/+JkUVzLcoTN+d/7YsQvUVi7NaKH8mJgjz112O4fUe3p9wfAaFa0RXHc5S GPzRTYRRlv/XZBIho4J2tkZOnteZJZ+GbxQVlINt6fd8P6al3MWOvpP/ExJPguEfjOsO6Njy xjo3WfpD4lHMOR/Oc3/8mScEF84rF2jXbsFgelWnbPWAvXY+pD0dXOFRkagGmC/viwBDqq5b 5tk76kKmUbZxABEBAAHCwHwEGAEIACYCGwwWIQTkPlhGHfx8v0RpFaWZ+n/LWfw7gQUCZFlx 5wUJGVGAjgAKCRCZ+n/LWfw7gf+iB/4g8CPY5jihf5r/8EsoIGe2H+dpVmpPF8YGBzTIvCz/ fQoOq8AX/pE76QEuFnFZWfjw+wgBXgCVmkox2Eflkk6z4ND3pcwGZ6CfCxTQCDk/dij+2DQ4 6bmDCy/sBgcbz9mTpoLC11HLoPae6YN9nBNQRZDcEFEu54OaVOqlIdbA6m+POIBCXZdHOFc0 WoDTgxHRzC1jgQNidyd6tKqcsVJs0dzF0oKTmFFmUAqTdJO12LBuNA1rlqrR3EtpYk8B/wtS 5dIMD7Q8hwQpL+4C6GNpb6ZKnPkLi47pDOLhz2qBrqN+rqUEsT3YnExYpzj5yOBi+FlmV1Hw 49QYe1sn2ZPs In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-03-13 Th 5:04 AM, vignesh C wrote: > Hi, > > In one of the recent buildfarm runs, the test > pg_upgrade/004_subscription test fails at [1]. > It has failed with the following: > Restoring database schemas in the new cluster > *failure* > > Consult the last few lines of > "C:/prog/bf/root/HEAD/pgsql.build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_new_sub_data/pgdata/pg_upgrade_output.d/20250310T194018.517/log/pg_upgrade_dump_1.log" > for > the probable cause of the failure. > Failure, exiting > > Unfortunately we don't have pg_upgrade_output.d contents in buildfarm > to see what is the exact reason. That's not supposed to happen. I am testing a fix to see if I can make it collect the logs, but for now we'll have to wait till the next failure .. cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com