From: David M. Richter <D.Richter@DKFZ-heidelberg.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Richard Huxton <dev@archonet.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Plsql Function with error: No space left on device.
Date: Wed, 27 Jun 2001 13:51:29 +0200
Message-ID: <3B39C8C1.96EE543C@DKFZ-heidelberg.de> (raw)
References: <3B36FB6E.1039F0D4@DKFZ-heidelberg.de>
<005601c0fd60$db576740$1001a8c0@archonet.com>
<3B388D05.C3919F0F@DKFZ-heidelberg.de>
<3122.993567296@sss.pgh.pa.us>
Hello!
It works right. And the speed is acceptable. Great!!!!
I used that Query on several table with a little smaller size. It
worked.
Thank You very much!
But in the Query at the big table the following error occured:
UPDATE image SET seriesoid = r.parentoid
FROM relseries_image000 r WHERE image.chilioid = r.childoid;
psql:restructure_join.sql:16: FATAL 2:
ZeroFill(/usr/local/pgsql/data/pg_xl
og/xlogtemp.22940) failed: No such file or directory
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
psql:restructure_join.sql:16: connection to server was lost
The file /usr/local/pgsql/data/pg_xl
og/xlogtemp.22940 doesn't exist on the disk.
The same query on the other table works well.
Why not at the bigger table?
What wants the error announcment say?
Do You know that kind of error?
I did not found any hint in the Archiv of the mailing lists?
I would be very gratful if anybody could give me a hint to clear the
obstacle.!
Thanks a lot
David
Attachments:D.Richter.vcf (text/x-vcard, 467B) download
begin:vcard
url;quoted-printable:http://mbi.DKFZ-Heidelberg.de/=0D=0A
n:M. Richter;David
x-mozilla-html:FALSE
org:Deutsches Krebsforschungszentrum;Division Medizinische und Biologische Informatik
version:2.1
email;internet:d.richter@dkfz-heidelberg.de
adr;quoted-printable:;;Im Neuenheimer Feld 280 url: http://mbi.DKFZ-Heidelberg.de/=0D=0AD-69120 Heidelberg, Germany ;Heidelberg;Germany;;
x-mozilla-cpt:;-15296
fn:David M. Richter
end:vcard
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: D.Richter@DKFZ-heidelberg.de, tgl@sss.pgh.pa.us, dev@archonet.com
Subject: Re: Plsql Function with error: No space left on device.
In-Reply-To: <3B39C8C1.96EE543C@DKFZ-heidelberg.de>
* 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