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>

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.


Solutions on the web3564

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 googlegroups
via Google Groups by Venkatesh Babu, 2 weeks ago
ERROR: could not write to hash-join temporary file: No space left on device However, I have lot of disk space free (around 65 GB of disk space is free)... The exception stack trace is shown below:

Solution icon of googlegroups
via Google Groups by Venkatesh Babu, 2 weeks ago
ERROR: could not write to hash-join temporary file: No space left on device However, I have lot of disk space free (around 65 GB of disk space is free)... The exception stack trace is shown below:

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 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 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 weeks 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.

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, 2 months ago
2 times, 2 months ago
4 times, 8 months ago
6 times, 11 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
92 more bugmates