MIME-Version: 1.0
Date: Mon, 22 May 2023 09:49:11 -0300
From: Wilson Coelho <wilson.coelho@tecnisys.com.br>
To: Wells Oliver <wells.oliver@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: RDS No free space
In-Reply-To: 
 <CAOC+FBU-1aB8+ivHe+nttSiM08QsaJH=t7_rDHb7YNTwhmkf9Q@mail.gmail.com>
References: 
 <CAOC+FBU-1aB8+ivHe+nttSiM08QsaJH=t7_rDHb7YNTwhmkf9Q@mail.gmail.com>
Return-Receipt-To: Wilson Coelho <wilson.coelho@tecnisys.com.br>
Disposition-Notification-To: Wilson Coelho <wilson.coelho@tecnisys.com.br>
Message-ID: <d2d7a8b5d8dcf6491b9e1d51d7b9229d@tecnisys.com.br>
User-Agent: Roundcube Webmail/1.4.11
Content-Type: multipart/alternative;
 boundary="=_86a5bb1fa3112f952ab807b2d53e1bc6"
Archived-At: 
 <https://www.postgresql.org/message-id/d2d7a8b5d8dcf6491b9e1d51d7b9229d%40tecnisys.com.br>
Precedence: bulk

--=_86a5bb1fa3112f952ab807b2d53e1bc6
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=UTF-8

Hi Oliver 

You need to check where are the postgres data directory and verify if
there is enough available space on it to the operation you trying to do
over the database.
It seems to be a problem related with a partition scheme and not the DB
per se.
Also take a look at the distribution of your data over the partitions.
If that file is on a partition with no space, try to resize or, move to
other partition 

Regards 

Wilson Coelho

---

Wilson Moraes Coelho 
Especialista

Sia Trecho 08, lotes 245 / 255 / 265 || 

Tel.:+55 (61) 3039-9700 - (61) 99989-8932 

71205-080 || Guará || Brasília, DF 0800-6020097 

www.tecnisys.com.br [1] 

Em 21/05/2023 14:15, Wells Oliver escreveu:

> I am seeing a lot of this morning: 
> 
> ERROR: could not extend file "base/16411/616989679.62": No space left on devi2023-05-21 17:11:45 UTC::@:[386]:LOG: all server processes terminated; reinitializing 
> 
> 2023-05-21 17:04:02 UTC:172.31.21.22(55060):woliver@db:[31430]:ERROR: could not extend file "base/16411/616989585.45": No space left on device 
> 
> Etc 
> 
> However, when I can connect, the DB is well below the provisioned space. 
> 
> I am trying to figure this out but not sure where to turn yet.
> -- 
> 
> Wells Oliver
> wells.oliver@gmail.com
 

Links:
------
[1] http://www.tecnisys.com.br
--=_86a5bb1fa3112f952ab807b2d53e1bc6
Content-Type: multipart/related;
 boundary="=_68f0d591f46d4cb98b0e84977ff669d7"

--=_68f0d591f46d4cb98b0e84977ff669d7
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset=UTF-8

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html; charset=
=3DUTF-8" /></head><body style=3D'font-size: 10pt; font-family: Verdana,Gen=
eva,sans-serif'>
<p>Hi Oliver</p>
<p>You need to check where are the postgres data directory and verify if th=
ere is enough available space on it to the operation you trying to do over =
the database.<br />It seems to be a problem related with a partition scheme=
 and not the DB per se.<br />Also take a look at the distribution of your d=
ata over the partitions. If that file is on a partition with no space, try =
to resize or, move to other partition</p>
<p>Regards</p>
<p>Wilson Coelho</p>
<div>---<br />
<table style=3D"margin-left: 0; width: 550px; color: #003087; font-family: =
Calibri,Helvetica,Verdana; font-size: 10pt; letter-spacing: 0.1px;">
<tbody>
<tr>
<td><img style=3D"width: 5px; height: 225px;" src=3D"cid:f62593aa02f7ca1140=
303fb9eff147bc@tecnisys.com.br" /></td>
<td style=3D"vertical-align: middle; padding: 15px;">
<p><strong>Wilson </strong>Moraes<strong> Coelho</strong> <br />Especialist=
a<br /><br /> <img style=3D"height: 35px;" src=3D"cid:04237a95e4ba3d087c622=
88085bb774d@tecnisys.com.br" alt=3D"Logo
Tecnisys" /><br /><br /> Sia Trecho 08, lotes 245 / 255 / 265 ||</p>
<p><span style=3D"font-size: inherit; letter-spacing: 0.1px;">Tel.:+55 (61)=
 3039-9700 - (61) 99989-8932</span></p>
<p>71205-080 || Guar&aacute; || Bras&iacute;lia, DF 0800-6020097 <br /><br =
/> <a style=3D"text-decoration: none;" title=3D"Tecnisys" href=3D"http://ww=
w.tecnisys.com.br">www.tecnisys.com.br</a></p>
</td>
</tr>
</tbody>
</table>
</div>
<p><br /></p>
<p>Em 21/05/2023 14:15, Wells Oliver escreveu:</p>
<blockquote type=3D"cite" style=3D"padding: 0 0.4em; border-left: #1010ff 2=
px solid; margin: 0"><!-- html ignored --><!-- head ignored --><!-- meta ig=
nored -->
<div dir=3D"ltr">I am seeing a lot of this morning:
<div>&nbsp;</div>
<div>ERROR: could not extend file "base/16411/616989679.62": No space left =
on devi2023-05-21 17:11:45 UTC::@:[386]:LOG: all server processes terminate=
d; reinitializing</div>
<div>&nbsp;</div>
<div>2023-05-21 17:04:02 UTC:172.31.21.22(55060):woliver@db:[31430]:ERROR: =
could not extend file "base/16411/616989585.45": No space left on device</d=
iv>
<div>&nbsp;</div>
<div>Etc</div>
<div>&nbsp;</div>
<div>However, when I can connect, the DB is well below the provisioned spac=
e.</div>
<div>&nbsp;</div>
<div>I am trying to figure this out but not sure where to turn yet.<br clea=
r=3D"all" />
<div>&nbsp;</div>
<span class=3D"gmail_signature_prefix">-- </span><br />
<div class=3D"gmail_signature" dir=3D"ltr">
<div dir=3D"ltr">
<div>Wells Oliver<br /><a href=3D"mailto:wellsoliver@gmail.com">wells.olive=
r@gmail.com</a></div>
</div>
</div>
</div>
</div>
</blockquote>
</body></html>

--=_68f0d591f46d4cb98b0e84977ff669d7
Content-Transfer-Encoding: base64
Content-ID: <f62593aa02f7ca1140303fb9eff147bc@tecnisys.com.br>
Content-Type: image/gif;
 name=f62593aa.gif
Content-Disposition: inline;
 filename=f62593aa.gif;
 size=43

R0lGODlhAQABAJEAAAEuhwAAAAAAAAAAACwAAAAAAQABAAAIBAABBAQAOw==
--=_68f0d591f46d4cb98b0e84977ff669d7
Content-Transfer-Encoding: base64
Content-ID: <04237a95e4ba3d087c62288085bb774d@tecnisys.com.br>
Content-Type: image/gif;
 name=04237a95.gif
Content-Disposition: inline;
 filename=04237a95.gif;
 size=3169

R0lGODlh/AAnAPcAAP////7+//39/vz8/vv7/fr7/fn6/Pj5/Pf4+/b3+/X2+vT2+vP1+fL0+fHz
+PDy+O/y9+7x9+3w9+zv9uvu9urt9ent9ejs9Ofr9Obq8+Xp8+To8uPo8uLn8eHm8eDl8N/k8N7k
793j79zi7tvh7trg7tnf7djf7dfe7Nbd7NXc69Tb69Pa6tLa6tDY6c/X6M7W6M3W58zV58vU5srT
5snS5sjR5cfR5cbQ5MXP5MTO48PN48LM4sHM4sDL4b/K4b7J4L3I4LzI37vH37rG3rnF3rjE3bfD
3bbD3bXC3LTB3LPA27K/27G+2rC+2q+92a682a272Ky62Ku616q516m41qi31qe21aa11aW11aS0
1KOz1KKy06Gx06Cx0p+w0p6v0Z2u0Zyt0Jus0Jqsz5mrz5iqzpaozZWnzZSnzJOmzJKlzJGky5Cj
y4+jyo6iyo2hyYygyYufyIqeyImex4idx4ecxoabxoWaxYSZxYOZxIKYxICWw3+Vw36Vwn2UwnyT
wXuSwXqRwHmQwHiQv3ePv3aOvnWNvnSMvXOLvXKLvHGKvHCJu2+Iu26Hu22HumuFuWqEuWmDuGiC
uGeCt2WAtmR/tmN+tWJ9tWF9tGB8tF97s156s115slx5slt4sll2sVh1sFd0sFZ0r1Vzr1RyrlNx
rlJwrVFwrVBvrE9urE5tq01sq0xrqktrqkpqqklpqUdnqEZmqEVmp0Rlp0NkpkJjpkFipUBipT9h
pD5gpD1fozxeoztdojpdojlcoThboTdaoTZZoDVYoDRYnzNXnzJWnjFVnjBUnS9UnS5TnC1SnCxR
mytQmypPmilPmihOmSdNmSZMmSVLmCRKmCNKlyJJlyFIliBHlh9GlR1FlBxElBtDkxpCkxlBkhhB
khdAkRY/kRU+kBQ9kBM8kBI8jxE7jxA6jg85jg44jQ04jQw3jAs2jAo1iwk0iwgzigczigYyiQUx
iQQwiAMviAIviAEuhwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAkAAPcALAAAAAD8ACcA
AAj+AO8JHEiwIMESBhMqXMiwocOHECNKnEixosWLGB/6UpCxo8ePIEOKHEkyITlKJVOqXMmypcuC
5Ow1eUmzps2bLgPg4FNFYMxxhooQwEm0qNGjChvYyWbPnrsY92I2tReOUAWkWLNqTanl29Sm1iJI
/aoujoCtaNOqfYjg01d76VoFsjFmjyemX21RWMu3b9oGvL4Ok1LAIIAboehNlbbBr+PHOAvcmqqO
DICBDFCguDqwRrSp0CJAHk1a5aGp21gIhEAHWT3Uk1TfYxBrqqvLpR0CiNDhxIkPFc6mPZChRIoT
ITg0wDqggogUKUZ0iBAA4o7X9sYhvMeF3DJ7tHT+pCBET5m7RwbuHcA1VQzDGofiy59Pvz79HQPN
2N9vH8dCATjgkcoy67xlzzzeBIOJGSEUtIN8aQwVEQ7y3TGQCvIVYtgPiOgCDnZvvdNNMJ3AIUN1
98hQ3xMTCYAGfYM0JhAKeriizTwGHihOMqfwYQQCCQEQTFP1GCEQIuEsAYksEt6zxjUvANPLchR0
01Q4CyxERo5cdtlUGwNN5uWYZyREQiPgjGmgME4M1MZXyNAQ0RlTYTNQE1PFU9ANyqhpoDZ7nNWE
N2918gBEIgQGpwsCYYAKiH7as04lGBSUxFScCESHNiOAkE4QToBhxhY8NEOHAa7EUl0VU7GhZaT/
aoIpkJiwvlUmQQ9QIk+tX5ni5lv0PLKcQ3Q2ZadAeDal50A4vMPrVxzdI4FbX2Xzg0NkqPNVPH0U
dg8E1Tw71UwEpdKUPCDc0wI7MNiQC5fhUNHAM2ncA0Cf9iyzkBbe9Ovvv2PZU86/BHszRphTrVPw
wgR7QVAL2BiojiyMqEFFEkpIIQYem0jT669/ttlQsfYce0+y9iwrkKJgVQKHF08ggcQTXcSRyCjN
7DpVtAJB4dVU9CwCZEIXsPIWMowOxMdX5pCShxhTKHFEE1qkEcgmwRQ4LkEJuNOUKwKp8oglahoj
CDgJ3JPGVNtNlMNXQ0BE6yEYpVDOV/SgckST/gqREEcx9vgq0JtcpiKjQiSbjLLKAuDYlCkoMpSA
EH8MQw/PAk0gylvMwGBQFOJs221BskyljQMOBeBCG7C4Q65AQUxlxj0YzBOuPe/0kcQYTfWBgxjO
KFZPPT11MBUXFb09VdwPzX0RAcl8tQxUErEgBcj2qGPOW+msIZxBid+Z50ABwDNVM0lDhEHkBE0R
zrZ5DCCQA5m8pYznBsEyFTtPyA+RAocSyA64MZUX3AML9qiHJtDQDIEMoSloEEgiHhEFK2VCIIRa
BN8iorymMM8htNpFHkZIwhKaED8EucJXjDGsixDOHtGwwCYgZY9gpI8g4UPW+AbyireE4xeq/vgE
JRTxhzuwgQtHSEF6HEKBUbzlFyT4QcTyNLqEvOEt7CjGK0RxiUYMYg9vCAMTYIC6ggBgDjprCgTu
8Qd7OOwLshAIESAoEDeM4h4e4IYwBDILK1ykg/b4YENoVas9FCQUX5lBR14YDYH0oBlvkcchMHeP
HJ5shwIpwftgFY9h7IEDDqFC6KbSDsVM5X4MOUAvalWPaUBCTgJJwyxmSUv5MQIZAjHDKgTyg6aQ
QSBnUIVA9iANXgrhmMcMwgYZAkhBMoSQsDIkQX6xP48wciAEqAM73mINIw3EkosrCAc+4axawYMO
DrGAKXLELW8xBAF+GGWtREFJe8VhOX7I/4b84CgQGzRlC3W84z0icQyBrHIq5mCCRJopt6nMwx0Q
jahEJ2ohgvSQSBdY5FQaSRAPqMJAoMhoJeskPmUlxAFSKAQqipENc7iDhgZyj0OwMI6vKIN6ECEA
EPAAil9UYxzqcFyXQlGQCKzCHi3gjj0mQYAkJEMgKmgKFARCCEjcowryEOg2poKMEbgNbg1tCt0s
QoevVEKjTeFoQZZwjbeUQwwAACcmG7BEhQDgABHYgAl0AIZRgAgaECnCV8rIxIYQ4AEZGIENqtAI
bRGpAwMRAV7CgMd6cIMYaHhHYTTQFCAIpBWR+EQ41DE7zjZFFUNbKFibN5WxVoQC5/iKI/7qChEO
HAF7ai1IAgJhvq/owhEk1aFJBSIDZOAvIp2Yijwg4oOvpO0h1LjCRLrwFR8MZARTOYVAaGEILkDD
HpnYghGaEgYn9AEd77CEFNZxqC015bYUYShrxYqRLEBKGlugrUIesAVYzENw97jmQk5Qiy4pDpMy
OFAnaoCbhiQAcE3xBnOdC5Ht7cIJ7mwIcKeyAoJMQ1kZuMcN2MECAYRiG7vgxmvEUYxibEMCBkhG
HgQijKaw47lfXV5Y7YEMSfj4x0AO8o97QJA1mBKhoUCDDzrgrQJ4QAhxgEVvA4fbmVrJQAceboqq
lYkz+GAEDRAOAB5QAiMAoq1TwcSEp/6C44ZsrynoSAUdlICCCLgzAR/YwRt88RVssG9pTYmEQARR
DQ3Q4BwTuMdWgTQLPghAFLxIjxKm8gmLdLAcItjxs+ThWYIEYYpckkcaDQTgF1baIQ5ohFCNVdIa
DiTBXpIHPGDaFHFA9iHNbUo5MsyQN3OJHvA4MrBeJ5ALeO1AOrhHACqRjRyUAnLFWMc9xNANFMTC
GIl2AJrrIQNL67rbmq6VPHpikAO4wRriIurgmpIKXjMEBsDoc0mHsUaBGGANt+PVMVIQkVyXA9wP
ScIuaD2mcEQhIYVADSjjmg5a2GMUwfAGHeQhjHRsIksCMFpT1F0RGEyjGQB/iCemQf/ykpv85Ccn
t0ICwINDFGPKXGJHLxAxhCZ5YRqfWGZDAmCGZ5AcFwMRwjRoUW+CAIAGe5iFPLsEDlJEgX0OqcHH
Qw4REKzBFNcg+P5ssYYWFoQB6G6KNBp0Dwr04TNTSUcobmBvUkylHLfOjUIKMAIifGENdahDG8og
BR18AOpGeYALmBCGNMzhDnRIgxaAEIIG2wQBJyBCF84QBzzcoQ1fQMIK3G2QGxw7O9cbiAVu4AMU
+O8eKRjGVOpxcLm7/vUVocKoaSEEwN8DBZKAeR1gz/vePyQK2/yKNjYBBy2Y4AyNiB7e4OD75jvf
IC+AZI40YAwDcYMIz89+9gsgh6VENyUCILibjRMRQO2bv/kK8MIsPi+aJMQDGHFI9Pnn//wDROL7
AjkA/fe//SGJhv8A+HwfUA7/F4AG2HtNUH4HuIBYERAAOw==
--=_68f0d591f46d4cb98b0e84977ff669d7--

--=_86a5bb1fa3112f952ab807b2d53e1bc6--