dbTalk Databases Forums  

[BUGS] BUG #1207: retrieve error

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #1207: retrieve error in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
PostgreSQL Bugs List
 
Posts: n/a

Default [BUGS] BUG #1207: retrieve error - 08-07-2004 , 03:51 AM







The following bug has been logged online:

Bug reference: 1207
Logged by: SWU

Email address: rojaine2003 (AT) yahoo (DOT) 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?



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Reply With Quote
  #2  
Old   
Tom Lane
 
Posts: n/a

Default Re: [BUGS] BUG #1207: retrieve error - 08-07-2004 , 11:59 AM






"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org> writes:
Quote:
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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.