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 1tQmMh-0058bz-8b for pgsql-general@arkaria.postgresql.org; Thu, 26 Dec 2024 11:49:19 +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 1tQmMg-001zYF-Kd for pgsql-general@arkaria.postgresql.org; Thu, 26 Dec 2024 11:49:18 +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 1tQmMg-001zY5-5D for pgsql-general@lists.postgresql.org; Thu, 26 Dec 2024 11:49:18 +0000 Received: from mail-vk1-xa2d.google.com ([2607:f8b0:4864:20::a2d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tQmMe-000dyY-0b for pgsql-general@lists.postgresql.org; Thu, 26 Dec 2024 11:49:16 +0000 Received: by mail-vk1-xa2d.google.com with SMTP id 71dfb90a1353d-51619b06a1cso3712518e0c.3 for ; Thu, 26 Dec 2024 03:49:16 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=tactilemobility.com; s=google; t=1735213755; x=1735818555; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=z4v3t2xQJXo64QJUm6Y2Z9dX8au3weLKO7Wxg0kf5TA=; b=kOmIo5PD3r3LAAFdimM2XWNKcCqVROyi1kd53kh2lvKRLghbyb+TrNdhYHzaNWRKQ+ XvvugKS+WUaTiAoqXwwVJhWwCPURFwymjv9FB/KlREtYx+TZTxjFfh367B+wK+28YH8r D+vzbTUommfuHE7LbJIg+WqJno8iwzABxwmow= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1735213755; x=1735818555; h=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=z4v3t2xQJXo64QJUm6Y2Z9dX8au3weLKO7Wxg0kf5TA=; b=JTdoSh2tZOLaxtL70VCupWQKbXkwVQl3H8Hdo2e0ArXGjQHd1TuttbkYfHku7EAR6G mftK7nxg4ox8kt7vKbFWaigIJYvrLNbrMTRwiLZ0TBwZngd+JKgstfXuwhZFWuJQy5Gf gN2bPj7Xl89rFpO/XmdmVhnxhSLKXrQ58ZSNZfc1M312BiALgWOUAQaaXdlB0WEInb9J yfm9IHE6+eU6dyQP7G6jmYF7I8S5dfUy+81V5K2QWQZpI0d5IJ+FUARHtlGCe40HN1Fc zxL7Vo4t62AgIyiaGP65hADPW/RKqzVF/xrAx5z4pxM/dJlaIgJ2ER/MiXeP84gXmYXE umYw== X-Gm-Message-State: AOJu0YyboEmLoBifxqOnwiZtV3rcXttQ6O7IqrDB6nmxO5WOFnjj62dm pffxnNlSsrnuqt6tucje7BJAhrTMhuz8Q88iZb0hnWaUSKa3q1r/r6fsMMa5Z8zJV2ykC3307rW zwhchyYxF0xIVPzeh7PMgfaKDJy81lLnDPSEttg== X-Gm-Gg: ASbGncu88mNVH/Rq6HMvzR5iqzwaVz2zVVfebi6i6UNed7H6FqHJ4ENJiuAgpOt6vkD 64SphoBg5XoN/p4Y259SWYlzUGOxKv3mVSrLd4w== X-Google-Smtp-Source: AGHT+IEFAbZe9VCdyJN+fqvkys/Zag3jee85IqXB0u+8SsxC5kz52/pg4YHEi27uZ/QUfxb9iY2t34wbZLvQkJ2a8v0= X-Received: by 2002:a05:6122:8c15:b0:518:9582:dba2 with SMTP id 71dfb90a1353d-51b75d67f88mr16462379e0c.10.1735213755448; Thu, 26 Dec 2024 03:49:15 -0800 (PST) MIME-Version: 1.0 References: <4c859b7d424698b54d617bd888e30ca37d19304b.camel@cybertec.at> <2159f2f698521b0be92ef44e3656edaf72a380f3.camel@gmail.com> In-Reply-To: <2159f2f698521b0be92ef44e3656edaf72a380f3.camel@gmail.com> From: Slava Shpitalny Date: Thu, 26 Dec 2024 13:48:59 +0200 Message-ID: Subject: Re: could not open file "base/XX/XX": Interrupted system call To: krah.tm@gmail.com Cc: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000080d87d062a2aef6c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000080d87d062a2aef6c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, We are facing a similar problem using a docker from https://hub.docker.com/_/postgres on AWS EC2 machine. The version we are using is 17 (docker image "postgres:17") The issue happens on our CI server, and it happens consistently. The table is a big one (related to https://www.postgresql.org/message-id/16832-943d33fd58eb26e4%40postgresql.o= rg ) Do you happen to have any updates on this issue? *Slava Shpitalny* Software Development Team Lead Tactile Mobility E-mail: slava.shpitalny@tactilemobility.com On Thu, Dec 26, 2024 at 1:43=E2=80=AFPM Torsten Krah wr= ote: > Am Mittwoch, dem 20.09.2023 um 13:11 +0200 schrieb Laurenz Albe: > > Is that an NFS mount? What are the mount options? > > > > Yours, > > Laurenz Albe > > No mount at all. > > Just the docker container filesystem using the overlay2 storage driver, > there is nothing externally mounted in that container, the data is > already in the image (via docker COPY) from which the container gets > created (and that data directory was created in the image build process > via pg_restore from the dump file). > > The whole container / image just involves overlay2 fs which itself is > sitting on ext4. > > Torsten > > > > > > --00000000000080d87d062a2aef6c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,
We are facing a similar=C2=A0problem us= ing a docker from=C2=A0https:= //hub.docker.com/_/postgres on AWS EC2 machine.
The version we are u= sing is 17 (docker image "postgres:17")
The issue happe= ns on our CI server, and it happens consistently.

Do= you happen to have any updates on this issue?

=

Slava Shpitalny<= /p>

Software Development Team Lead

Tactile Mobility

= E-= mail:=C2=A0slava.shpitalny@tactilemob= ility.com




On Thu, Dec 26, 2024 at 1:43=E2=80= =AFPM Torsten Krah <krah.tm@gmail.c= om> wrote: