From: =?iso-8859-2?Q?Pecs=F6k_J=E1n?= <jan.pecsok@profinit.eu>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Error:could not extend file " with FileFallocate(): No space left on
 device 
Thread-Topic: Error:could not extend file " with FileFallocate(): No space
 left on device 
Thread-Index: AdsDgSy1R7raIIj9SWWBOWJ7ln7E5A==
Date: Tue, 10 Sep 2024 13:11:16 +0000
Message-ID:
 <AS1PR05MB91059AC8B525910A5FCD6E699F9A2@AS1PR05MB9105.eurprd05.prod.outlook.com>
Accept-Language: cs-CZ, en-US
Content-Language: cs-CZ
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?iso-8859-2?Q?BI9fMwJGPx5m4pqYvAsLG3zbEUtnxn0cl5mXKOOKBt7qSp1yBTcc+Mw4lu?=
 =?iso-8859-2?Q?EeH7au0CXiMnLSBDT0YneaXaGo79U1rjeKqhCaFMOFeJM1jpYvt0NXHo/6?=
 =?iso-8859-2?Q?wqLSWRinj0dobRqlHjJjyXsY0bNOh1bD74NYZn3CWhfU+BPZpPJQx6S859?=
 =?iso-8859-2?Q?gSN9o1S2XXtDkpKDyAn3DyjK1dGYDOZCL2F1QrkH+XaSf3niao6+ZQwOWu?=
 =?iso-8859-2?Q?MHarNUCbFWPoIFImT+qrwnq00xf+2hLbLzIWfCFLHxriGrjTwSjs1idarf?=
 =?iso-8859-2?Q?e4zczr4KtmoxEFNs8mEYiKkGbsABEygob5uqZWcLkkKYAunDxYXj2buEsR?=
 =?iso-8859-2?Q?RS/7GhZU0MLohbWm4Yt1aphscHLAKVHy4tHQRXmkXCC+MaVZVekuldIEwp?=
 =?iso-8859-2?Q?QNM7VEygAVVOUruBjGW1IuyMgCvCjc1Ynqhbben/9LQp/kKRJHNR/Mol2i?=
 =?iso-8859-2?Q?TUwvEtj10EtrjJsLUlnluJTPolrKONR4Z2vTP7LlVeupLPraIv2mlveW00?=
 =?iso-8859-2?Q?Sk9ENtqCrZ0hvLAuUFR3IibEU5Ir+RextKNqmSldLzR8tiKYBUldYjHq0b?=
 =?iso-8859-2?Q?7AX9YLEp/X5Mp5nP1sANkLyV2ZIwiSjSXsF6GkQkfQy8f9W6+NZvKZl+su?=
 =?iso-8859-2?Q?24maphn/0AmzIrGxP0shjumv6zjRfOf4ze5Kz0fkxWlxCphCxzVG7QD7Cw?=
 =?iso-8859-2?Q?gDBxWnZh3xB5gLUbMbvHtQpTipHlfbBh1TDLC3OMYwEX2ylzCqdz0JCPQ3?=
 =?iso-8859-2?Q?x6mmgytOrk//T/6soCDrJDaP4LCi6a+FVyX8z/rOn4nZMf3Vd6QkKxH4Eq?=
 =?iso-8859-2?Q?bjf+nw8a/lNZtUbYcUrYdA58KOIcGdDuyDrE9Jm6exREu+RS2J+ZfXHmUh?=
 =?iso-8859-2?Q?bIDYDjuDhS8LYcx9rc18fUVF/Zp3z4oXG9Cud1SfaMeHD6E9LjtZbnUSoc?=
 =?iso-8859-2?Q?YZiGOoEYQaWcvv4Ri4mK1hDIme7xNrd7Cn2XT5JYkx3PeE39znqyYxzKvm?=
 =?iso-8859-2?Q?uYK4IRUCCRQv3kTibrlxrovqqsS3s1cmVw5hXM4IubMjEdLkNv7lt3oPky?=
 =?iso-8859-2?Q?MGfMag4rlWo07aMZ6pfDMu4LjqWvzV9lRFlJxvIAOPm2tqF2ajKY9KMQry?=
 =?iso-8859-2?Q?7zCKBkkOwza68FnAusy71PfIxFZ6FeLn7YBun0YbL4oHcai8aPqRi2p8G6?=
 =?iso-8859-2?Q?H8ORZhFt766nRy4SIs1ZEgqZv8XiMZ+gH7oeO3a9t6CcZoFEM0iOUfO2Da?=
 =?iso-8859-2?Q?F6mG2RABkodJgiZREfyx3cRCgl5nL2LyFbzohVUWKQWDSpjtAHKkVuKBMb?=
 =?iso-8859-2?Q?5iDWMv6YAjEoT6GLpsZXKUInx6hcAdVUUHEluXryTUMMtgUPasSqLwZeCe?=
 =?iso-8859-2?Q?jWjCQWg8J3yROKqtB4LLiyk/LssRBC5vHi2hH3rqojlBA/87T0ebm4NJCc?=
 =?iso-8859-2?Q?KGy2y6Z3LaZg/j4VOx5asA02CJpa4O013k0Ue7WGEz7ytG6+Z4spa9l5uh?=
 =?iso-8859-2?Q?77aewJDsHUHufuxh5lXCcxN20ilW3jmAhi/hVrPLD/vscQgKl+nS5s+OI9?=
 =?iso-8859-2?Q?ml+HCe/1eZnopI3NJzi2MF0bW5+D//zwQgNDSzwISqp6T8QZFwfZ22SxZj?=
 =?iso-8859-2?Q?zRKbVxy9kz5HpMoPu5n3c0FckjdAEEfE8XGBtd0ds0WfOuEpW6GHF3p6i4?=
 =?iso-8859-2?Q?4Ws7PFBE9kYhNGT9E5w32PYqZWBY4/AD/Br560BU?=
Content-Type: multipart/alternative;
	boundary="_000_AS1PR05MB91059AC8B525910A5FCD6E699F9A2AS1PR05MB9105eurp_"
MIME-Version: 1.0
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0:
	vsdTau3T44xVuoq9UnwqIeeQIjSJig2PcdAO4iRUrqAM1WYth9AwoH32oHHtkj/cYfcCPzo7xqjA8Dh5zfWTmpjrB7keAnQhyUdSKOuYH48vrgcdUxiMRa5sLE6eIiYYCZn3FWIJVsuPSWfVDLHG+bmTqgUWa1N5BcPwefQ3k5KvJylKuqPdfSyMK842w/t6Hrt68NCjp5YhtvqMBIMacQs9WI6DmDmeSFPk4ygQLIWhM6dTCzaQHLxDq8tRbghI/ETsYUw1XqPFbkVTzCeqPw/UZN65i1e6ZbkZRdUjcPLYau/4a/mC+Zzolf/ioi2b1jSCsDcb24rLZxm0YWUEzllORNuD+FzjjhLSz430WrCPkEVuG4fW63Fyoj15/+Z1O4geaKKtx0DuLUqOxlJ1cUh1BzZZHE59IQazGv9oPfq7NYEP2c0i1IRruMCGgwFrJ1ubyBhyWh4ynLhVgkIyOxtuGtNxdpEJ3TaGmcnCuMhw2QDOp4LIbT1WL7RH2GjzFQf+0GeokSjTJL+2Hp0eV5wMxaA4h2CiPiCWD7c0R/6dZLDedJclGUkNG/38QVChl3VjkknfU+uXnRl/hPnsmQ==
X-OriginatorOrg: profinit.eu
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: AS1PR05MB9105.eurprd05.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 99895d2d-6af9-478e-a2b7-08dcd19a0daf
X-MS-Exchange-CrossTenant-originalarrivaltime: 10 Sep 2024 13:11:16.4188
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: f6184fee-665e-4653-8922-8200a1e77b76
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 4zJQ86M1Y/xI/MhtQgehm+vFxahC2YeAvDdkqPyxBMs20dAGYzpHJshVfEd9IbelU9F+zssjHsttOOsfMvNjbg==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM9PR05MB8500
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/AS1PR05MB91059AC8B525910A5FCD6E699F9A2%40AS1PR05MB9105.eurprd05.prod.outlook.com>
Precedence: bulk

--_000_AS1PR05MB91059AC8B525910A5FCD6E699F9A2AS1PR05MB9105eurp_
Content-Type: text/plain; charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

Dear community,

After upgrade of Posgres from version 13.5 to 16.2 we experience following =
error:
could not extend file "pg_tblspc/16401/PG_16_202307071/17820/3968302971" wi=
th FileFallocate(): No space left on device

We cannot easily replicate problem. It happens at randomly every 1-2 weeks =
of intensive query computation.
Was there some changes in space allocation from Posgres 13.5  to Posgres  1=
6.2?

Database has  size 91TB and has 27TB more space available.


--_000_AS1PR05MB91059AC8B525910A5FCD6E699F9A2AS1PR05MB9105eurp_
Content-Type: text/html; charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
2">
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Aptos;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	font-size:11.0pt;
	font-family:"Aptos",sans-serif;
	mso-ligatures:standardcontextual;
	mso-fareast-language:EN-US;}
span.StylE-mailovZprvy17
	{mso-style-type:personal-compose;
	font-family:"Aptos",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:11.0pt;
	mso-fareast-language:EN-US;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"CS" link=3D"#467886" vlink=3D"#96607D" style=3D"word-wrap:bre=
ak-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Dear community, <o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">After upgrade of Posgres from version 13.5 to 16.2 w=
e experience following error:<o:p></o:p></p>
<p class=3D"MsoNormal">could not extend file &quot;pg_tblspc/16401/PG_16_20=
2307071/17820/3968302971&quot; with FileFallocate(): No space left on devic=
e<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">We cannot easily replicate problem. It happens at ra=
ndomly every 1-2 weeks of intensive query computation.
<o:p></o:p></p>
<p class=3D"MsoNormal">Was there some changes in space allocation from Posg=
res 13.5 &nbsp;to Posgres&nbsp; 16.2?<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Database has &nbsp;size 91TB and has 27TB more space=
 available. <o:p>
</o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
</body>
</html>

--_000_AS1PR05MB91059AC8B525910A5FCD6E699F9A2AS1PR05MB9105eurp_--