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 1rfQM4-0001GE-5j for pgsql-general@arkaria.postgresql.org; Wed, 28 Feb 2024 20:16: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 1rfQM2-00EmyL-ID for pgsql-general@arkaria.postgresql.org; Wed, 28 Feb 2024 20:16:39 +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 1rfQM2-00EmyC-4R for pgsql-general@lists.postgresql.org; Wed, 28 Feb 2024 20:16:38 +0000 Received: from mail-ed1-x534.google.com ([2a00:1450:4864:20::534]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rfQLy-001tON-V9 for pgsql-general@lists.postgresql.org; Wed, 28 Feb 2024 20:16:37 +0000 Received: by mail-ed1-x534.google.com with SMTP id 4fb4d7f45d1cf-564a53b8133so236464a12.0 for ; Wed, 28 Feb 2024 12:16:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1709151394; x=1709756194; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:cc:to:from:subject:message-id:from:to :cc:subject:date:message-id:reply-to; bh=9EnSq3aCh1CKn4BT5rb4UL++lY/lTeFhqruy45yKmOQ=; b=OCBKewn63OwfnmgWHX9V+pE27kECEb7C0toq51Usko04vMKUfSIb/velFNt99np4BG F+lWKKa7/GYfLAy+sIENuA4wubR/qL1ialkW8kRRH0R809shjC5PT+90v9ZlQiZbgw3l aReHITZmHQBshZStY5v2SzNhcraURRYFquZbUCQoyHsW/C9sfWzudMGSh1nC6aHJ8xmq rJVw/igk/tQxLb9RWo+Udk4OIST7f0CI+aMUQzCYVXrHQK3X2/aPJ4WSPMARHozlZE3e dlVRi/DFoOT6n3AloHvjqNyHP4d2G2YRwHfDspVu+gs0nCW/W6Vo8IF6xKsHB+IUHVNJ cJBw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1709151394; x=1709756194; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:cc:to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=9EnSq3aCh1CKn4BT5rb4UL++lY/lTeFhqruy45yKmOQ=; b=ILqbvd6GVrSAiVjeU6XTcuA4bJLTRFvIL6FiDyeiTW3P9IpDjx/Ctu5KQRwfg858JD wdeYkLxhFxKJRAusR1T36yCWEba53uyxZxDMDsEHSUmN133wnp9G3YiOTwpWql05GC4j MwE7zn+WXAS9qNF6EHQMbYxAThmJdyy9YuexgBeavYk88ffq2syOsEVc+tcm86l4/UFX ppoiX96NHlAOKQ7OEnDqB1R9eSJlPISKJkosvCVxeE5XgP+Inn9Q/VyrbkQ5EXntgOPA FdDMHRoLeL3AT2Uvu3Cih9+zf5pw/3X4b1+NDBUweKEcslOq7XeSNUvE8rCTLhwYTl69 pw+A== X-Gm-Message-State: AOJu0Yxt/EVezJIvYfTxEsSrmaO/EB5X+dEAkf17at3Nvl/Ug/18ppCD XCu9iMuwWtRG93lgxjDM9ohXSdQC3d9lF+YDONsDZuRn3UctHDh3KbzqoGcs0NA= X-Google-Smtp-Source: AGHT+IFivhdkStXKACBVSRhk9P0Z0ZmgEWlQnCo726C+N4XONf2ei+5Q6TF7rCvO2DpGUz6wm3Zkxw== X-Received: by 2002:a17:906:70c:b0:a43:7edb:87 with SMTP id y12-20020a170906070c00b00a437edb0087mr26696ejb.4.1709151394226; Wed, 28 Feb 2024 12:16:34 -0800 (PST) Received: from localhost.localdomain ([2001:871:260:b4a1:cc62:7f49:dcc2:cfd5]) by smtp.gmail.com with ESMTPSA id x16-20020a170906b09000b00a3fce8c0f99sm2197258ejy.191.2024.02.28.12.16.33 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 28 Feb 2024 12:16:34 -0800 (PST) Message-ID: Subject: Re: Orphan files filling root partition after crash From: Laurenz Albe To: Dimitrios Apostolou Cc: pgsql-general@lists.postgresql.org Date: Wed, 28 Feb 2024 21:16:33 +0100 In-Reply-To: <5233ff6e-f363-92a4-aa18-7a9392d35ad7@gmx.net> References: <5233ff6e-f363-92a4-aa18-7a9392d35ad7@gmx.net> Autocrypt: addr=laurenz.albe@cybertec.at; prefer-encrypt=mutual; keydata=mQINBGGDwAQBEADgbWy5cKXQld3N2mF+DFyiNFbi2oBl2T+XgxpPF8wTRw2D/u4bBKXP0SYSE/lA86jIVNWWU0gf1KODIkVvgJm2w4vH2VBV1b7ddVViGl1Iu+9zaRnv9wulhnH42KefepXnoean6UT1EzLM0opF/Ik0j+40TxdRtobkBprkQUyHDXWlHc2ffPs3SipyFEP9AVLf7ejRC46CXWDnsqjOBSMEW8Z4HiK/8RrPZBsKLts8dJxKF4pygOdJb0CWk8k/X1jbcfdxo+zOLjOMvJcSJ2pFdJmQHU+JufB3rePziqQ2S9Ur6sccr9XnTC1GVBWN4Lf5VHq+vf+bFJjVwg+2hrySZnAVfcOrxoqFLErr7ug1zN2nM1kcpgA4VWn4gxlJtYNYYq+9WxX5dtvnNANlG3ZCrRKQzl8lxtzoF6Zo7LUhEqPaHDwn7Rvs+IdbOn41lF5UDTJGqmC4gS/bZydW2Fy3YWm4aSaN9fgFf8D+PVkrlKAZB7gBLz1TyHjbcRf85cYF+GKKrDld5SzMB/V60VX3oP/Eo8ikFpyWaqiz1f9X7MBot3/PjJkY+wDzp3nmb19QEcOBuQiSQ4xds2r0HewbuHTAR68u8jNNMGmpm2j4x+g09Jd/WQDjqlTBZ/jEltH41fYCCPWMfljXTOOXu2eLNGdfi7ETZogtwjM9oTtSPQARAQABtCdMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD6JAk4EEwEIADgWIQR0CqhbZGGABqoaSbdi8bhXA2EdmAUCYYPABAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBi8bhXA2EdmM/6EADK232JCwmBzhlj8h7U9CjG6kx0JHP3uJGv+XfsHtHAlmY/RCwF1BHMEsRlk bT5UrLvJ2jb99bA9QARzhFaxzyn0F/BUKzuIjRGNs/n6d5dNUFA0kOt8sX+TacmC GEyjEBCrVCm4ranBiUyePn9NhHNWnaex7pJyqvMLLdwW9BEMJx0Fqo+DN8ukbXmYRsmhEtd3ue+x/luYmOmJnaGtzInaY5aOJYbW9XqoRIZkZvOCgbi1FfvNmoqWa+3oVxTOgw9RafjJDyW0lTHzKGjbGI5ofMU98l+/hKJFYJqWUF6VpFJY5YIcN/1lf4ZICMwDl+MPIVo/tpq8L10seJL28nLlvw3K+cI+TVW8IW/qL/LyVoDofI3USeOORuYmhpWRhik8JXX6xf3v6GrRilJIPWNFIJbxm1ZblQiQnOw3IOW7T+8nAmPin1HKqM3VrOrJQ2VtShsefNBibNAsr1oFaqcDBkn3yGG8i6CTW+FyO4PZ+/EwNxMVgktxbYdy5AT1/lpXr5tB+phhLIyVfiBvrWs5EThxYMQ/L8Y85c3GMsAy1l/x4h3jqySIYy3SCU9+jc5UVuNnXljbvkEzJ+NLWJ6C1rACFWrMszgPdh5tCrlRY9PpmYll4JbCgb8BtxEIUmR+xr50/ZElEK5iml7Q00KUekCcDt+36PsyGFTXBzNOrkCDQRhg8AEARAAzOZ2tLHlI4rrhG411h6cdCFjBZxuljaFCxFyHn3m6wbGLqwBUWC5k8UrRqjHMz88KcTSaNO7XGAmCqPdWd2SeflPZRnNTbjsVpw7mLdffsBm4JX7kki2Pvk5h0NtYeidXT1PSpc2ri4DutYXuT9uD8RAm1wUDCE5HQNUihT/WH6opt+hskHW21uHao0+y822tG0QQcGMqdQR5Vxdxj89wiEPdqW+HpU/oOZIhrf2E7prduAppxixjHy/o1rcnoznnJvc8D3+YgI9O0LrBMij89dM55pRGbLovTR1oGR3U74sX774+0xmSzeIKwZfiMUz7Atlvfk5SHOsRUFPN2Ux9kaXiiBibQpHFxt7b lDrT4wxdLJ/XCdbPPAyl+lZtOLsaHEEZvYNyTXwZc35dVf3R4/oz20HoG6s7ct8e1 AQygj43XAERzty9SkWgxs8+grp1PrGx6FHVSYRqBM8dS/ZR6yRVwOwJXPyaSSqfIF21DkE4j1y4n+ItSewPGoRp8K/yWCikt6qlkVkO2ASNIiX04fAbtzwVOaNn8ZMRNqyvLc1fED4sr49onE4cAIcBLjcC3KL+w9DUGRQCdziROj5H2Yl/sXGPdMciUHo/Uz2rggc+2th3bQiMhrHWSsBpUkDQp0yWewemstPpPgBL3h2fHKaX8B9oH5Qu/H1IgrOuX8AEQEAAYkCNgQYAQgAIBYhBHQKqFtkYYAGqhpJt2LxuFcDYR2YBQJhg8AEAhsMAAoJEGLxuFcDYR2YuPwQAMkpGtR80pQ1gVsONhdkqj0H2eU66efP/gO3CoyaoIcvrpKYj7C2HipVSmkt1gpByL0X4AMQ/vKuknUz3wd28Ba+G1dCfbVs/Xiusq+SmpUj5rTwmYqdSjWMuCo1R6oS5hdJMdUUJYGMT0QkVlm1KnW8jkmCTl9GzjDxOAsN9O6/6lPzaGFtk9XF+34Bry/N4HKiJkqpC4+UTd0AprPfzJ2jdT64e1F0+W88X8y1bTTgNrHwK4mDiLnlE4SKRuEm54lNhJz//ar86Or5BErzNpM6TL7lk44QS06hwsMrEdKIy8J/SYJPjfzR8tIUnKscclVpOgjKaBqC+0iFiVaRqAgfOlIEiezX6kMh5Q2FIUfqs46qWhhXjRrdKOEoStYAaikdLu5ZXr7vfb0ZaDh+ZwTQtbSMFolyOkecwI81MCdbMfT/1TqIGTOdAj5as9fAakk0jb2pXgUYQ8X1DVTR8ahSDVEaw9VTmWiSvTxvguVJ1Mb7gG4Gmh6aviDTJhfXtH4rPUNXhDLqrTH8JkJjyKROOMakIF68Hjse5vUfUxreBEOtb5r1Coa2Fe7ncJayaSE7ryrDbFqpZ 36UMAx4ulWMyqJajLNGY0DdG8qIsR5nxRhrnK/mrCidZ8F9/D3bWAl4rjtHlsztN59 +AnW5l0HsQcY9ntFL/zEBOaonjdJf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.50.4 (3.50.4-1.fc39) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2024-02-28 at 20:30 +0100, Dimitrios Apostolou wrote: > Lucky you.=C2=A0 It should have been "relfilenode" rather than "oid", > > and some catalog tables don't have their files listed in the catalog, > > because they are needed *before* the database can access tables. >=20 > I actually double checked that the filenames don't appear anywhere in > SELECT * FROM pg_class > and that the files were multi-GB in size including all the > 1GB-pieces. But luck was definitely a part of the equation, I didn't know > that the files might be accessed before tables (at db startup?) or that > "relfilenode" would be more appropriate. Why is that, where can I read > more? I see that many (but not all) rows in pg_class have oid=3Drelfileno= de > but for many rows relfilenode=3D0 which is meaningless as filename. If you are curious about such things, start reading the source. The object ID is immutable, and initially the filenode is the save, but it changes whenever the table is rewritten (TRUNCATE, ALTER TABLE, VACUUM (FULL), ...). Yours, Laurenz Albe