From: TJ O'Donnell <tjo@acm.org>
To: pgsql-sql@postgresql.org
Subject: ERROR: could not write block 196261 of temporary file: No space left
Date: Wed, 20 Sep 2006 15:00:32 -0700
Message-ID: <4511BA00.6070001@acm.org> (raw)
I got the following error during a psql session of a big transaction
filling a temporary table, then selecting distinct values from it
for insertion into a permanent table.
CREATE TABLE
CREATE TABLE
ERROR: could not write block 196261 of temporary file: No space left
on device
HINT: Perhaps out of disk space?
UPDATE 0
I can't tell if this was because I ran out of real disk space,
or because of some disk space limit set in pg config files.
The log file contains no extra information.
After this failure the real disk space was not full,
of course because the transaction died and apparently any used disk
space got cleaned up.
I also can't tell if the error came from the Copy or the Insert.
Can someone help me figure this out?
Here is the SQL.
Create Table fragment_table (smarts character varying, frequency
integer);
Create Temporary Table temp_table (smarts character varying);
Copy temp_table (smarts) from stdin;
(millions of strings here generated programatically)
\.
Insert into fragment_table (smarts) Select distinct smarts from
temp_table
where gnova.oe_valid(smarts) and
gnova.matches(gnova.cansmiles(smarts),smarts);
Update fragment_table set frequency =
(select count(smiles) from input_set
where smiles is not null and gnova.matches(smiles,smarts)
group by smarts);
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tjo@acm.org
Subject: Re: ERROR: could not write block 196261 of temporary file: No space left
In-Reply-To: <4511BA00.6070001@acm.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox