Received: from newmail.DKFZ-Heidelberg.DE (newmail.inet.dkfz-heidelberg.de [193.174.53.39]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5RD8Va73141 for ; Wed, 27 Jun 2001 09:08:31 -0400 (EDT) (envelope-from D.Richter@DKFZ-heidelberg.de) Received: from perkeo.inet.dkfz-heidelberg.de (perkeo.inet.dkfz-heidelberg.de [193.174.61.66]) by newmail.DKFZ-Heidelberg.DE (8.9.3/8.9.3/DKFZ-8.9.3) with ESMTP id PAA21240; Wed, 27 Jun 2001 15:08:25 +0200 (MET DST) Received: from DKFZ-heidelberg.de (perkeo.inet.dkfz-heidelberg.de [193.174.61.66]) by perkeo.inet.dkfz-heidelberg.de (980427.SGI.8.8.8/DKFZ-8.6.4) with ESMTP id PAA14708; Wed, 27 Jun 2001 15:06:36 +0200 (MDT) Message-ID: <3B39DA5C.FBC63A7B@DKFZ-heidelberg.de> Date: Wed, 27 Jun 2001 15:06:36 +0200 From: "David M. Richter" Organization: German Cancer Research Center X-Mailer: Mozilla 4.7 [en] (X11; I; IRIX64 6.4 IP27) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane CC: Richard Huxton , pgsql-sql@postgresql.org Subject: Re: Plsql Function with error: No space left on device. References: <3B36FB6E.1039F0D4@DKFZ-heidelberg.de> <005601c0fd60$db576740$1001a8c0@archonet.com> <3B388D05.C3919F0F@DKFZ-heidelberg.de> <3122.993567296@sss.pgh.pa.us> Content-Type: multipart/mixed; boundary="------------FE9AF7DEB308F859CE0D2B52" X-Archive-Number: 200106/431 X-Sequence-Number: 3728 This is a multi-part message in MIME format. --------------FE9AF7DEB308F859CE0D2B52 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hallo! Another try -- another kind of error pacs=> UPDATE image SET seriesoid = r.parentoid pacs-> FROM relseries_image000 r WHERE image.chilioid = r.childoid; FATAL 2: ZeroFill(/usr/local/pgsql/data/pg_xlog/xlogtemp.30164) 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. The connection to the server was lost. Attempting reset: NOTICE: Message from PostgreSQL backend: The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory. I have rolled back the current transaction and am going to terminate your database system connection and exit. Please reconnect to the database system and repeat your query. Failed. ????????? ??????? I will try ipcclean. And look for postmaster options! Any ideas? Thanks a lot David --------------FE9AF7DEB308F859CE0D2B52 Content-Type: text/x-vcard; charset=us-ascii; name="D.Richter.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for David M. Richter Content-Disposition: attachment; filename="D.Richter.vcf" 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 --------------FE9AF7DEB308F859CE0D2B52--