org.postgresql.util.PSQLException: ERROR: could not extend file "base/12407/18990.223": No space left on device Hint: Check free disk space.


Samebug tips1

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>


7 months ago
Expert tip

Solutions on the web1812

Solution icon of stackoverflow
ERROR: could not extend file "base/12407/18990.223": No space left on device Hint: Check free disk space.

Solution icon of stackexchange-serverfault
ERROR: could not write block 3478284 of temporary file: No space left on device

Solution icon of github
ERROR: could not write to hash-join temporary file: No space left on device

Solution icon of stackexchange-serverfault
via Server Fault by pstanton
, 1 year ago
ERROR: could not write block 31840050 of temporary file: No space left on device

Solution icon of stackoverflow
ERROR: could not write 3124 bytes to temporary file: No space left on device (buffile.c:408) (seg33 adnpivhdwapda04.gphd.local:40003 pid=544124) (cdbdisp.c:1571)

Solution icon of googlegroups
via Google Groups by sajeev sahadevan, 2 months ago
ERROR: could not open file "base/1459687/1467687": Permission denied; State=42501; ErrorCode=0

Solution icon of spring
via Spring JIRA by Hendy Irawan, 1 year ago
ERROR: could not serialize access due to read/write dependencies among transactions Detail: Reason code: Canceled on commit attempt with conflict in from prepared pivot. Hint: The transaction might succeed if retried.

Solution icon of spring
via Spring JIRA by Hendy Irawan, 1 year ago
ERROR: could not serialize access due to read/write dependencies among transactions Detail: Reason code: Canceled on commit attempt with conflict in from prepared pivot. Hint: The transaction might succeed if retried.

Solution icon of stackoverflow
ERROR: could not serialize access due to read/write dependencies among transactions Detail: Reason code: Canceled on identification as a pivot, during write. Hint: The transaction might succeed if retried.

Solution icon of github
ERROR: could not access file "$libdir/postgis-2.2": No such file or directory

Stack trace

org.postgresql.util.PSQLException: ERROR: could not extend file "base/12407/18990.223": No space left on device
  Hint: Check free disk space.
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)
	at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:116)
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
	at dbAnalysis.config.NamedParamStatement.executeQuery(NamedParamStatement.java:31)
	at dbAnalysis.dao.DbAccess.profile(DbAccess.java:61)
	at dbAnalysis.Benchmark.perform(Benchmark.java:63)
	at dbAnalysis.controller.ConsoleApplication.main(ConsoleApplication.java:95)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Once, 4 months ago
11 times, 1 week ago
2 times, 4 months ago
4 times, 10 months ago
6 times, 1 year ago
98 more bugmates