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 1qwO1A-00BORe-Bw for pgsql-admin@arkaria.postgresql.org; Fri, 27 Oct 2023 14:40:56 +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 1qwO17-00GEHP-OD for pgsql-admin@arkaria.postgresql.org; Fri, 27 Oct 2023 14:40:53 +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 1qwO17-00GEHF-D0 for pgsql-admin@lists.postgresql.org; Fri, 27 Oct 2023 14:40:53 +0000 Received: from mail-yb1-xb2b.google.com ([2607:f8b0:4864:20::b2b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qwO10-0039x9-HN for pgsql-admin@lists.postgresql.org; Fri, 27 Oct 2023 14:40:52 +0000 Received: by mail-yb1-xb2b.google.com with SMTP id 3f1490d57ef6-d9a4c0d89f7so1553008276.1 for ; Fri, 27 Oct 2023 07:40:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1698417645; x=1699022445; darn=lists.postgresql.org; h=content-transfer-encoding:subject:from:content-language:to :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=osAKRS+p+nVj1AGnPAbBxuFKEdW2TAVltX1anHCOWks=; b=exkzFmEAu9Nids71m0Y+ZoVcFeZouM2tN4TNAKPybQQBwfFJe6D92paMjr/cHbQAgl S4s5l1fIM3mLGQH52qEHP29dBVm0UikuJQ0rm+5n1JIOuQjZcPNDORDyBphQ5XW2iqqa JihZjSs0T4XXMJ6vEoa2c/7Gez3WAKCkN7DRPpCrQoVWmJdigbpEoTGzOiNtGxF5/rxa 4N2Q0UNGsu9cnHCO5Z1dZWzkc1pvxa4yr9K6YD1GNY+Ze56pgD+Or0ws5gf2AnkfrcFe 1D3YbHHyrB7HB0LDft7dZpaj3aCdE2za9MYjTPo+eEK7NTewi0VNtqQ3zyzEEM/g93cc vC5g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698417645; x=1699022445; h=content-transfer-encoding:subject:from:content-language:to :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=osAKRS+p+nVj1AGnPAbBxuFKEdW2TAVltX1anHCOWks=; b=bj0bBo7Js7mOItbY3CwaOxyRToZ7THvwlybqLEwxeZSJ7l/WJGS/8dWE/JoAQioFXS jQOx0JbsD4aYcS6LBLU1weuTHHR0AhiVBOXJyCBJmuqL4e99zIyX8/DllyS3t3ff6J9W 4CLClJgSSXuo1IyCZYYJxNGK62vdfteuvDFcae/t8FHhcdgYjxBGbdJ5y1xaViG6Uor3 kdnaqCmNYjyfeOFAVW0UWTrdCKJnU7tU49Axk/jvZCiUFR/aOE8QmUmo+cAy8MkCU/xu 6cIy5iGtA7pS53vcJHy32fPWRPKO0g1/Mm4I96rz9To9D4XyOMfk9yzOAL39L6RdiKiX Ku2g== X-Gm-Message-State: AOJu0YwjPfHJs3uXoXbbRamHGyAsi9p+rHSpAw65zW+vgwI3NiEFeHhg z+Ph188Lfs+3kuSHHtpMzuHmnIZ8nXU= X-Google-Smtp-Source: AGHT+IHeHtzZVB9MUSIBmWykS7ZLPejjWNrWJ7aD1Yi7e3k5DhVJmwGa7fwzdIRaKl+O7qBKjqDiwA== X-Received: by 2002:a25:7602:0:b0:d9a:f02f:2adc with SMTP id r2-20020a257602000000b00d9af02f2adcmr3038841ybc.27.1698417644613; Fri, 27 Oct 2023 07:40:44 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:e0e7:f6ad:239e:5da2? ([2600:1700:bd2c:b810:e0e7:f6ad:239e:5da2]) by smtp.googlemail.com with ESMTPSA id k27-20020a25b29b000000b00d72176bdc5csm698556ybj.40.2023.10.27.07.40.44 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 27 Oct 2023 07:40:44 -0700 (PDT) Message-ID: Date: Fri, 27 Oct 2023 09:40:43 -0500 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird To: pgsql-admin@lists.postgresql.org Content-Language: en-US From: Ron Subject: Rollback after "Connection timed out"? Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Pg 9.6.24 On Server_A, I ran: psql --host=blarge mydb -c "ALTER TABLE blah ..." After about 2 hours, it displayed this message: Could not receive data from server: Connection timed out Connection to server was lost And yet the ALTER TABLE (it's heavily inheritance-partitioned) is still running on blarge.  Is it still working, or is it rolling back (which I'd expect to be fast)? -- Born in Arizona, moved to Babylonia.