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 1qiv7o-008OFJ-9y for pgsql-general@arkaria.postgresql.org; Wed, 20 Sep 2023 11:12:08 +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 1qiv7m-00GUan-TT for pgsql-general@arkaria.postgresql.org; Wed, 20 Sep 2023 11:12:06 +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 1qiv7m-00GUaY-E0 for pgsql-general@lists.postgresql.org; Wed, 20 Sep 2023 11:12:06 +0000 Received: from mail-ed1-x52e.google.com ([2a00:1450:4864:20::52e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qiv7i-006Iw6-GC for pgsql-general@lists.postgresql.org; Wed, 20 Sep 2023 11:12:05 +0000 Received: by mail-ed1-x52e.google.com with SMTP id 4fb4d7f45d1cf-532eb2a1bf8so992815a12.0 for ; Wed, 20 Sep 2023 04:12:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1695208320; x=1695813120; 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=q7FZXPn8SOYgb4Cn59582k/qA2B7GQgxw/rnD6+njcc=; b=Uq0UE+G4OUPE1plkQWqIYU1aLHVp0QW7MEBzhXVPqdGjITtGCrGOhmhhE3EBpRs8Ln NREN2n74RciVTbTVeuFniOJMaeaXiIGqc5ydw+pUvwoqepkgWjByR5/pxJZ8vgYUHh7/ /0fB6aZGUECXIRR4RrOq82QvkVFINvVH/JOrjKErLJFuGdRVodbeWG7w1BzXW6dC3mlC SGL11ewFUa+h20GvLgiSVT4Gw4RnQdy+H/E2BU8q+y5JVEcnCpYNU5depzR4Tx2wbuNo 4uIgsmBgSVSa4IP02dm+9M4q5CzhpNnZVK1ybylDT2MASIpk/a9uSsbNrlkpMbDiEOkR I4Dw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1695208320; x=1695813120; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=q7FZXPn8SOYgb4Cn59582k/qA2B7GQgxw/rnD6+njcc=; b=qxcXekmoP68p2vmflZV8n+NYjnIE8Cvpl5dV0jXvq6BS7Xjf7QuEzUyFfnisYaS9yL Y1zUey4yooOSa1KDs0eMK/N0j73DMouW5x08LXfnMzlbisSkwyHHPePzVAhaJcYRtMh9 njrSHFM6BolVg3fY4r8nql+RaqqhxlnJRU6bboSuvQB0WgkivXC9CI1KQxRcdSSskIvs 7aSIimeDogDMPl3GSdjhj7ji3ksluUvTSRZRar6ntpzuJ6gCSQexdYXPnMq+6zpj1v2t Pli+ISf/Jk/0UsoMQYLC2VoRczRwHjpWbh08hwnb6W0qVZm4eSDcQQE9YsDLE2A3blUk g0Jw== X-Gm-Message-State: AOJu0YwNYpzX2mcT1+trzEBAX5/w/XFO7fwF6wj5O4ifSL/hgZ+4Zqvf svGsVvMiiBUluozL453mYe3HjA== X-Google-Smtp-Source: AGHT+IFIatsFf3VG5f9zjnIMI8L/0P3k1S4WGtWm11LOcGqrHnfqxM0qDlllz/7auzF3sGEf8dsFeQ== X-Received: by 2002:aa7:d398:0:b0:530:7abf:3a84 with SMTP id x24-20020aa7d398000000b005307abf3a84mr1848798edq.25.1695208320094; Wed, 20 Sep 2023 04:12:00 -0700 (PDT) Received: from localhost.localdomain (178-190-171-65.adsl.highway.telekom.at. [178.190.171.65]) by smtp.gmail.com with ESMTPSA id b92-20020a509f65000000b00532c84e6997sm1961712edf.23.2023.09.20.04.11.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 20 Sep 2023 04:11:59 -0700 (PDT) Message-ID: <4c859b7d424698b54d617bd888e30ca37d19304b.camel@cybertec.at> Subject: Re: could not open file "base/XX/XX": Interrupted system call From: Laurenz Albe To: krah.tm@gmail.com, pgsql-general@lists.postgresql.org Date: Wed, 20 Sep 2023 13:11:59 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2023-09-20 at 10:49 +0200, Torsten Krah wrote: > I am running the postgres docker image with that version: >=20 > 2023-09-20 10:36:32.478 CEST [1] LOG:=C2=A0 starting PostgreSQL 13.12 (De= bian 13.12-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.= 2.0-14) 12.2.0, 64-bit > 2023-09-20 10:36:32.564 CEST [1] LOG:=C2=A0 listening on IPv4 address "0.= 0.0.0", port 5432 > 2023-09-20 10:36:32.564 CEST [1] LOG:=C2=A0 listening on IPv6 address "::= ", port 5432 >=20 > And this is happening for some queries: >=20 > 2023-09-20 10:38:25.076 CEST [47] ERROR:=C2=A0 could not open file "base/= 16386/17328": Interrupted system call > 2023-09-20 10:38:41.897 CEST [49] ERROR:=C2=A0 could not open file "base/= 16386/68359": Interrupted system call Is that an NFS mount? What are the mount options? Yours, Laurenz Albe