BUG #1207: retrieve error

Started by PostgreSQL Bugs Listover 21 years ago2 messagesbugs
Jump to latest
#1PostgreSQL Bugs List
pgsql-bugs@postgresql.org

The following bug has been logged online:

Bug reference: 1207
Logged by: SWU

Email address: rojaine2003@yahoo.com

PostgreSQL version: 7.3.3

Operating system: RedHat 7.0

Description: retrieve error

Details:

Just recently I've met this error while retrieving a almost 15 thousand rows
of records and I'm unable to find a workaround on this. If any body out
there could help me with these error. Please share me with your knowledge.

Here's the following error:

A database error has occured.

Database error code: 7

Database error message:
Select error: SQLSTATE = HY000
ERROR: ItsWriteBlock: failed to write block 603 of
temporary file Perhaps out of disk space?

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PostgreSQL Bugs List (#1)
Re: BUG #1207: retrieve error

"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:

Just recently I've met this error while retrieving a almost 15 thousand rows
of records and I'm unable to find a workaround on this.

ERROR: ItsWriteBlock: failed to write block 603 of
temporary file Perhaps out of disk space?

You've run out of disk space.

regards, tom lane