Thread: org.postgresql.util.PSQLException: Error could not open file "base/":No such file or directory
org.postgresql.util.PSQLException: Error could not open file "base/":No such file or directory
From
Raghavendra Rao J S V
Date:
Hi,
Few of the tables and indexes are bloated though auto vacuum has enables.
Two reclaim the space vacuum, I have ran vacuum full on the larger tables and also performed reindex on the indexes which are in larger size. Now the size of the database is in control.
After perfoming the vacuum full and reindexing on larger tables, I am facing below error.
org.postgresql.util.PSQLException: Error could not open file "base/": No such file or directory
Please guide me how to resolve the above error and let me know does this has any relation with vacumm full or reindexing operation which are performed by me.
Regards,
Raghavendra Rao J S V
Raghavendra Rao J S V
RE: org.postgresql.util.PSQLException: Error could not open file"base/": No such file or directory
From
Alvaro Aguayo Garcia-Rada
Date:
What do you have on your postgresql logs, on the server?
Alvaro Aguayo
Jefe de Operaciones
Open Comb Systems E.I.R.L.
Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103 | RPC: (+51) 954183248
Website: www.ocs.pe
Sent from my Sony Xperia™ smartphone
---- Raghavendra Rao J S V wrote ----
Alvaro Aguayo
Jefe de Operaciones
Open Comb Systems E.I.R.L.
Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103 | RPC: (+51) 954183248
Website: www.ocs.pe
Sent from my Sony Xperia™ smartphone
---- Raghavendra Rao J S V wrote ----
Hi,
Few of the tables and indexes are bloated though auto vacuum has enables.
Two reclaim the space vacuum, I have ran vacuum full on the larger tables and also performed reindex on the indexes which are in larger size. Now the size of the database is in control.
After perfoming the vacuum full and reindexing on larger tables, I am facing below error.
org.postgresql.util.PSQLException: Error could not open file "base/": No such file or directory
Please guide me how to resolve the above error and let me know does this has any relation with vacumm full or reindexing operation which are performed by me.
Regards,
Raghavendra Rao J S V
Raghavendra Rao J S V
Re: org.postgresql.util.PSQLException: Error could not open file"base/": No such file or directory
From
Adrian Klaver
Date:
On 03/05/2018 05:54 PM, Raghavendra Rao J S V wrote: > Hi, > > Few of the tables and indexes are bloated though auto vacuum has enables. > > Two reclaim the space vacuum, I have ran vacuum full on the larger > tables and also performed reindex on the indexes which are in larger > size. Now the size of the database is in control. > > After perfoming the vacuum full and reindexing on larger tables, I am > facing below error. > > *org.postgresql.util.PSQLException: Error could not open file "base/": > No such file or directory* Assuming the database is up and running then base/ is actually there: https://www.postgresql.org/docs/10/static/storage-file-layout.html When I know a file or directory exists and I see an error like: 'Error could not open file "base/": No such file or directory ' then I generally check permissions on said file/directory. In particular does the app throwing the error having the permissions to 'see' the file/directory? > > Please guide me how to resolve the above error and let me know does this > has any relation with vacumm full or reindexing operation which are > performed by me. > > -- > Regards, > Raghavendra Rao J S V > -- Adrian Klaver adrian.klaver@aklaver.com