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 1rfJZ8-00GsUV-7r for pgsql-general@arkaria.postgresql.org; Wed, 28 Feb 2024 13:01:42 +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 1rfJZ6-00AT6V-Mq for pgsql-general@arkaria.postgresql.org; Wed, 28 Feb 2024 13:01:41 +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 1rfJPN-00ALlN-NJ for pgsql-general@lists.postgresql.org; Wed, 28 Feb 2024 12:51:38 +0000 Received: from mout.gmx.net ([212.227.17.22]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfJPL-001lOJ-Fi for pgsql-general@lists.postgresql.org; Wed, 28 Feb 2024 12:51:37 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1709124692; x=1709729492; i=jimis@gmx.net; bh=74EjQRdNiCpQzWecGqPX5j/Y++SYn+EewADrfmukw58=; h=X-UI-Sender-Class:Date:From:To:cc:Subject:In-Reply-To: References; b=EavsNUTHLgskR+n6R9nBePVjMZh79sldw7WLVP83BWGlwKHtkSxUZwIXjY+FqSNv knQvpJEN8aOy9N/NCTGnUtLImFFdRBqMepKtR07/IoHk2erGjoVgC7MUhoEu/Cxzz pVZjiJLelv0Jm/F84IUIbAbx1FJvt8V6qbyIyest9UNsOo/FmBGikVkneAoEzLV1t j+8oJqpr50qce+bhGJKUGi+sAhG1XcXQgEgI9QqBiQncuNqMvHa2aIvb4DZq+lqnC AD+HioZ6+EGwHIGaejhUOhxJdwO/+bMEmi06VrLAuUqmOhJLwzXApEqNLyMak9A9a Twjv+Umex6RAhwHMSQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [192.168.0.96] ([178.232.0.21]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1M3UZG-1relRW1JNi-000aQ4; Wed, 28 Feb 2024 13:51:32 +0100 Date: Wed, 28 Feb 2024 13:51:31 +0100 (CET) From: Dimitrios Apostolou To: Sergey Fukanchik cc: pgsql-general@lists.postgresql.org Subject: Re: Orphan files filling root partition after crash In-Reply-To: Message-ID: <07f2e362-24a2-f382-decb-c90025ce2d87@gmx.net> References: MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed X-Provags-ID: V03:K1:9KxPi3Gi4+6aoofbKMINIIlYzrHAlD8vSQVgy/1A8fPhTEoiudi mCSXGxsa3n/JNMzITcgbGP4nVhozC9MimBMvAF+C5ykOJsS3zKb+pkHx0x964EnApOW94PD liTMexyBGf3w2yTKL6+vlStJ6ssM6/YFZCWFh2ob+RXKxE06ippTem1rJvZzyiRljoy134p H/bTGiLmTEcAQcQAST2Yw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:23VIysSx6fw=;B+g2NoUDwWyJV4/7kclgdGSVH7s DFvPcaTbKCPDirACCvNFwcdF1ZkELyfyqFERPagM9R8jZpzEpqkXKdJkU+/kOWSbTj4+cqnRO 1sIzAZPcZI6CYFfBV3Zx1+tnd4QUCQqMjwWZJsa05pL4mZozy+d58rGLsCw4f1/3yEkP9BO3m W7WyUZbgisiOAGJvVGSO7iAtuPdiNNhVQUuXrY4TT1BHgKfX12Jbu7dGXLAbS8CrxsxVXC+yw P4YPhwpJLdo97JCrBomeNiUvuXxAyl7sgVpZQKIsPkI80XW3hJ0uVfjtAfQUMU4BOvz4BM8dz gj6p8nLVTEXc7t3P1IXE/9OQO07dSqCv5vFzTd03zZDrxOhAXMYKlPf4K3epnm8/6Nyip2LL+ dXNG4RrC7ya4eeDiMCRmRxAgJP0H4a26JGuvROMifmBR5SSbxe5WAFiEjviaxymV2aJbXHPPv pTE6x7YDFoA0SdQPlIPxXf/DtTAmR020ZemT6bEhPEEnVMiW5gUiaoqC9iQ2SFoDTtEvW/6ec M0ppd20N9GvenrLiSP888lAJ3tGlWwOF7WR8RTGHgsK8hQGgfeF1DwzzOGU1cVzG6jemVnI/t AoIvA3A16h5PmDkhgCa4ImYSlu1sPHlxEpRU8UYxboEsUyZ84VZq0WIqmGDiK7/z0Esij43Re j/9uADceTqc19bws7uUYdh6vH46ccBbJIVoX8U21jH1hpy/c6ul2lGIb9EtlSpXKFjFH1tEBt I4KtUy/a0//nPau2ndU6EfPvs6m6Fb1goQOiRFa/rAR1oRyZ5RNWO4PchHT2HKbWqZ1pNnAyW XfTm3AKzVudr09a3ktnEq2KR4bsuyxBxnJ9YGBu41sqhc= Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Sergey, On Wed, 28 Feb 2024, Sergey Fukanchik wrote: > Hi Dimitrios, > Do you have wal archiving enabled? > $PGDATA/pg_wal/ is a bit different from tablespaces (including > "default" one). It stores transaction journal. I don't think I have WAL archiving enabled. Here are the relevant WAL options in my config: wal_compression =3D zstd max_wal_size =3D 8GB min_wal_size =3D 1GB track_wal_io_timing =3D on wal_writer_flush_after =3D 8MB The issue happens because the WAL directory is by default in the same filesystem with the default tablespace (root partition for Ubuntu). So when the default tablespace filled up because of my ALTER TABLE operation, there was no space for WAL either. Thanks, Dimitris