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 1soVjK-00Bo7o-Be for pgsql-general@arkaria.postgresql.org; Wed, 11 Sep 2024 22:22:31 +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 1soVjJ-009LRF-3Z for pgsql-general@arkaria.postgresql.org; Wed, 11 Sep 2024 22:22:29 +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 1soVjI-009LR7-OP for pgsql-general@lists.postgresql.org; Wed, 11 Sep 2024 22:22:28 +0000 Received: from mail-ed1-x52b.google.com ([2a00:1450:4864:20::52b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1soVjE-000iRg-Me for pgsql-general@lists.postgresql.org; Wed, 11 Sep 2024 22:22:28 +0000 Received: by mail-ed1-x52b.google.com with SMTP id 4fb4d7f45d1cf-5c3fa6a5415so42978a12.0 for ; Wed, 11 Sep 2024 15:22:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726093344; x=1726698144; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=BES/2kdmBprgocQFj4VBeq6UZcnWPNR+i/Y4Op9AJbQ=; b=Mj/2iqZCBhUG59XsLjn6VNUKCmnYoOWZ5LXbOV0Wooo3wOUSJhmlu2cWETPUnNOl7Y LMP5jNopeoeSebH7G/ta75X1C2lP1ANBpXdMTeBibJKltduy3JT6TD/9B7TuOEJ6FijU Dcn1fkFU8hFqURV03o4UkOVon5I96n+ujHNybx2KiXidMR4YLCbsycs/KhMz0f9uNKiQ /wuosoQGkAzJnbJ530zyrVTk1m73VsVfeiZaExCaSvcLYAQqStHQbb9lL0kYfAwfKGdT MYHs07FYfovEz78Acriai2Yb7qqG5JfGRHGxFUGy0vkqRjrq01VJ3cyAo0F2pdPeM/1A XDHA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726093344; x=1726698144; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=BES/2kdmBprgocQFj4VBeq6UZcnWPNR+i/Y4Op9AJbQ=; b=Tyd+Kiv9jZlr8V0Ca+bk81gTa4FjmTSAx+lPfVSy8GjNkRWeGsxaj8I9sRxEgXvum2 REisLshkeVcoBuRisLvSHtUr/E0JLHFHgR/8Ql7uPAdFgmZS2xypXWCIVahxxNYTg+aM 6BsVivFgD+HvvMOYAqyTmJ6FX+SnccKI9XKqb4wCFJ5klQDj42jsJV1s/W096xwEBSG8 ZiedLLQa4VU7kAECcLjldHwVcGaV7gsUjsiSKs7qmgfC3TZhoEQP7Mb4ymhTnCAyUlNh wgcF7Ku+y84fDmCnbAkrUETIVNiVPGVp/2pfGcPi9bDPPStx31SIxR06Ttw/5Pid81l6 u0Sw== X-Forwarded-Encrypted: i=1; AJvYcCW8L6k2IvcA/BjrUYG0EyvPKoRhhMEBakXBots/ooBoAZPOm44gWMu0OhIdOpPeRjyMkgs1iMroBW2a4w7H@lists.postgresql.org X-Gm-Message-State: AOJu0Yy2aIUEpoPsjzr3ZLgq1fZQ0CO1Ojs876jVf6ZwZC+98n/Q5pyS Wxl5GkdDZ404Xhwlg7eRNHa/AAnPPUmbgJtEdAt44jhVhhfhZGXeMcsfyfRe0tCb57VljpV54lv 0Z3LgqFyGjlntYmEZTDZEWMbKk6A= X-Google-Smtp-Source: AGHT+IF0R8d3QZPtZvCdF9afrVaW6MUqNC93UsvBci7fQ1/Z3LIhtuZqeDZUwDBerRfPAHJZ2MnQ7J74mLeuTiBv3r8= X-Received: by 2002:a05:6402:2115:b0:5c2:5cf5:c344 with SMTP id 4fb4d7f45d1cf-5c413e583e3mr278130a12.5.1726093343965; Wed, 11 Sep 2024 15:22:23 -0700 (PDT) MIME-Version: 1.0 References: <202409111239.n2dybum5hcwj@alvherre.pgsql> In-Reply-To: From: Thomas Munro Date: Thu, 12 Sep 2024 10:21:47 +1200 Message-ID: Subject: Re: Error:could not extend file " with FileFallocate(): No space left on device To: Alvaro Herrera Cc: =?UTF-8?B?UGVjc8O2ayBKw6Fu?= , "pgsql-general@lists.postgresql.org" , Andres Freund Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I don't understand what ENOSPC has to do with the file descriptor limits, but this person reported: # touch test touch: cannot touch =E2=80=98test=E2=80=99: No space left on device https://serverfault.com/questions/746032/rsync-and-scp-failing-with-no-spac= e-left-on-xfs-device ... with plenty of free space, and it went away with ulimit -Hn and -Sn changes. Huh? Could this have failed in FileAcces() when trying to re-open a vfd?