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.96) (envelope-from ) id 1vJc6I-00DAgD-0V for pgsql-admin@arkaria.postgresql.org; Thu, 13 Nov 2025 18:31:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vJc6F-0034CR-34 for pgsql-admin@arkaria.postgresql.org; Thu, 13 Nov 2025 18:31:15 +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.96) (envelope-from ) id 1vJc5C-0030LZ-16 for pgsql-admin@lists.postgresql.org; Thu, 13 Nov 2025 18:30:10 +0000 Received: from mail-ed1-x52e.google.com ([2a00:1450:4864:20::52e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vJc54-006yFc-1i for pgsql-admin@lists.postgresql.org; Thu, 13 Nov 2025 18:30:09 +0000 Received: by mail-ed1-x52e.google.com with SMTP id 4fb4d7f45d1cf-640aaa89697so1679681a12.3 for ; Thu, 13 Nov 2025 10:30:02 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1763058601; x=1763663401; 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=pqYviDpt5b2PHhWtANRWOwh6NWXYEo/zPCBWSo7ZG44=; b=RQsMTaJhM2X7iLPTRxP+sR73YoaTHpOwpzbSQ78DXfnRSqnJI88FLoWHSGiXKOePQ4 SV/+hHcPUnBAXQ5fWeElmoqzYkfdF0BHZyuTKKfXrL10yYS205+GfKB4dGF/b4KjiHXd rR51uourW0/QUslztl4iy9+a1bMGy6hEMNOXlUNiso2LWD9ehsYYfVe+y/ZVPsDEAp/X snLkDn1+OAGqMnyyIQksClrebJ7zbWQbjRMWVwUL1CR6L01et4cmOkWWO9/kis+paqZ3 i1OZkXLydpb2DySseTB94fmUHV62dum8y2REBjuolORxmJmNpjN31mrPYj5RY3hqVoud omSA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1763058601; x=1763663401; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=pqYviDpt5b2PHhWtANRWOwh6NWXYEo/zPCBWSo7ZG44=; b=jOuUIu+05Pv+8uH2uD3ndal7hfZsD3IZuTgUxP06Nf/q6pqnevoxByo9EBYkiBvheq 1llOWeGWHj+HIoLOa8+0rUvtavLxytPqG9Icw9sY0qurKZImLkjGxC3sYVIv1vtdEJtA 4VwJEaAbTJo/OvAI9vahbW55ygf/eg2ZbBeURyEnW5GDL9/nSMBmUfUrWz7fhny4jVTU JsZZUre+C/zq4xL4KXhJTs3w9/pbla5r+G9duB1b/v4s8NE+cdLfeC8vr5O622ruJuL5 UBIco9cnoTT+7ldzjRyLeAKgFTg+e3MJx7zJ4RrwaTacdzqBb3Ffg/40bUqWVKNbEhK9 nbEQ== X-Forwarded-Encrypted: i=1; AJvYcCUU2/gebS9bgyPTcjOocsd+QaMAoyCWtURgl12Bf+fIV6nPO+uWlrCQbzuSJRi1J8R8nG7PkQ5TtdGisw==@lists.postgresql.org X-Gm-Message-State: AOJu0Yx6i8t1U1nYTTSCY5N7bLW12w5/A9BEMf53wZdrTFBSqZYABBgi 3FlLupXKi+kk/1N4fAsXXWDDq+7mjv/O6hRkbGyeaAD0M8ON1PBZa5IzJB8qLSK5qmWKHNjPwR/ MnvfB X-Gm-Gg: ASbGncuts2YY/BXLKDss9M7LYnve1NyuSIVCExUzc8+QiL1NWP3fKdU91kbfrTc62iZ odrXnVUFAQIRLCWPKicbvYerrfKEl16qnl0DBCCvWrt/B0/KfBSR2RvtW2Gd7BSXdL1g0E6sed4 9d6Ti4csL92af67fFIU2MZeIJpnVD6msF5L3xIzUI73pxS/YBka8HC3zHMxWBN+0FsuOjgOtTa0 I73QxH94i22qn7GsUdYWpbVJn1fDoj/6dEOQdShtIp22iIi/SP1FbGvozk5roQWRZzE932ufjl1 mQ7vz+M/mxNhDN5TfQlDiSID2JKsxIFXTImbCUsYbWqQBYaE/lHk8J+Iua66ss7m1Q+odTAAI4k 7XbZq/ceCu7Hq3L+GiuYG2MKE6GwZMf98GgtLyX5g1hYsKHJOMNajxCasnTNgUcRD0YesJURZ7I xh2NfWrYJ+YwEedozloIS+k298/uAYLsUpXP+8VEqVuw== X-Google-Smtp-Source: AGHT+IGXDocgegqzjcvlzgRm6XhZ4KxPzMtpkoobefnpO3Jzx7IFQz3Jpf1gW8/p7yYkj7c8ikI43g== X-Received: by 2002:a17:907:3f03:b0:b73:4006:1875 with SMTP id a640c23a62f3a-b73678f39d1mr22262266b.38.1763058600984; Thu, 13 Nov 2025 10:30:00 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:260:ec3c:33a9:6b48:3cf9:2769]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-b734fad41d9sm215733566b.27.2025.11.13.10.30.00 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 13 Nov 2025 10:30:00 -0800 (PST) Message-ID: Subject: Re: vacuumdb produces ERROR: cannot freeze committed xmax From: Laurenz Albe To: Sbob , pgsql-admin@lists.postgresql.org Date: Thu, 13 Nov 2025 19:29:59 +0100 In-Reply-To: <1801edda-893d-4b71-8694-6d775762df8e@quadratum-braccas.com> References: <1ac45482-cf26-4d6c-b551-ce9c9a5cbeec@quadratum-braccas.com> <1801edda-893d-4b71-8694-6d775762df8e@quadratum-braccas.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2025-11-13 at 10:16 -0700, Sbob wrote: > Yes, we did a restore of the tables that seemed to be corrupted, any=20 > advice on determining the cause of the corruption? Investigate what odd things you did with the database. In my experience, the main causes for corruption are: - shoddy or old hardware - bad administration (e.g., badly taken backups) - software bugs Yours, Laurenz Albe