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 1qisuk-008AyD-9H for pgsql-general@arkaria.postgresql.org; Wed, 20 Sep 2023 08:50:30 +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 1qistk-00Fb8I-LV for pgsql-general@arkaria.postgresql.org; Wed, 20 Sep 2023 08:49:28 +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 1qistk-00Fb86-8i for pgsql-general@lists.postgresql.org; Wed, 20 Sep 2023 08:49:28 +0000 Received: from mail-wr1-x434.google.com ([2a00:1450:4864:20::434]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qisth-006Hmo-KU for pgsql-general@lists.postgresql.org; Wed, 20 Sep 2023 08:49:27 +0000 Received: by mail-wr1-x434.google.com with SMTP id ffacd0b85a97d-32003aae100so423852f8f.0 for ; Wed, 20 Sep 2023 01:49:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1695199764; x=1695804564; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:date:to:reply-to :from:subject:message-id:from:to:cc:subject:date:message-id:reply-to; bh=OUgGJp76eFI/KeVWnqJYwAxoVOf6OZhLwyLvptFiQ2Y=; b=ALycoJ0lkunA1rXYDGK9wyrwi5Mi6kOH4FOwPk0lsXeY2DljL3AMVdhGRK9oezBimB Zy3eostNcN5yxQ/9QAUd/9uG00e9dO+u0a/OTA6haPP3kmvubL7/SDUm9mjL6HnUWT9N 7qyUVbcUHnpbxP9m2yjYkDr+h0YTEEv94XqxOn2cbSzD7wIzypgGQ5ieKFZjcrKc47yP zARXBOCuaSGUP9vO73JL+OLH0HPy/mCPatdWnIW7gR9A+qAku9xFy/n8+RdXaZRFi+zU WabP4rMdJeZ5wRJEskT+4fB+RYowZpV5wgldRKW8d1Qj109VSKO8zTKXb8rOTdjjzghz x9zQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1695199764; x=1695804564; h=mime-version:user-agent:content-transfer-encoding:date:to:reply-to :from:subject:message-id:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=OUgGJp76eFI/KeVWnqJYwAxoVOf6OZhLwyLvptFiQ2Y=; b=vi28NoBZ5CbThgzRT8VSTALPQxhmO43AxiO+H3J/pGdr8gh1fgxM+SlRp4QHxJVobw 5H1OuABjxrCBJoL7Vp5bYRNczSQsxIA3VnMacZ/mWmXDnvKb1Nnoqadly6DioKeLjo0I zHS2Q4V5E/I9FE8QPz6mJ9guvgS3TkIQyxYqQxdFl/pWyWGjvI8C7qYOLommdK3Ik/Ci MWxsqmsvEN00EtAX3GdOYik0lJJbuDbdnoTaZ47SKQ2vny/xLg1ZDcvFeI/7rz9UKHd0 VASvGnfn/OZccsPtDbjpMDVL4+qNtd7ntKjpy4M04fNxmcUOsdx7SK8lRFrJakHtbfau xFDg== X-Gm-Message-State: AOJu0YxD0na7urJdLe15l+vmZQhAnr7DSbom06/iwTxNUWpKTL0O5pHR YInsxTQ/YA4S3iCjeuSkB8TEfJtBZjBjzw== X-Google-Smtp-Source: AGHT+IFdbjWiAwXU7f4FDm/71s37j26VB0oxicCeslmsuqBklw0jTZ0ThtTC6spGVApe/Fw79M7aIw== X-Received: by 2002:a5d:4947:0:b0:31c:2f95:8056 with SMTP id r7-20020a5d4947000000b0031c2f958056mr1700586wrs.23.1695199763410; Wed, 20 Sep 2023 01:49:23 -0700 (PDT) Received: from TORSTENKNBL2.fritz.box ([2a02:810a:14bf:d7a4:857:c0b9:3be8:2329]) by smtp.gmail.com with ESMTPSA id j3-20020a056000124300b0031f34a395e7sm17955206wrx.45.2023.09.20.01.49.22 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 20 Sep 2023 01:49:23 -0700 (PDT) Message-ID: Subject: could not open file "base/XX/XX": Interrupted system call From: Torsten Krah Reply-To: krah.tm@gmail.com To: pgsql-general@lists.postgresql.org Date: Wed, 20 Sep 2023 10:49:22 +0200 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, I am running the postgres docker image with that version: 2023-09-20 10:36:32.478 CEST [1] LOG: starting PostgreSQL 13.12 (Debian 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: listening on IPv4 address "0.0.0.0",= port 5432 2023-09-20 10:36:32.564 CEST [1] LOG: listening on IPv6 address "::", port= 5432 And this is happening for some queries: 2023-09-20 10:38:25.076 CEST [47] ERROR: could not open file "base/16386/1= 7328": Interrupted system call 2023-09-20 10:38:41.897 CEST [49] ERROR: could not open file "base/16386/6= 8359": Interrupted system call I can enter the container and view the files above with e.g. strings $file | less and I can create a md5sum from that file without an error. What can I do about that EINTR on open, how to fix it? The host (6.1.53-060153-generic #202309130436 SMP PREEMPT_DYNAMIC) and the docker daemon (Version: 24.0.6) do have nothing suspicious in there dmesg / logs. Anyone an idea how to debug / progress with that one? Torsten