Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 45A1D476052 for ; Tue, 3 Sep 2002 23:51:39 -0400 (EDT) Received: from smtp.mana.pf (mail.mana.pf [202.3.225.22]) by postgresql.org (Postfix) with ESMTP id 1F5F9475B57 for ; Tue, 3 Sep 2002 23:51:35 -0400 (EDT) Received: from hina.esoft.pf (mwc.sl.mana.pf [202.3.226.49]) by smtp.mana.pf (Mirapoint Messaging Server MOS 3.1.0.36-EA) with ESMTP id AGC36383 for ; Tue, 3 Sep 2002 17:44:49 -1000 (TAHT) Received: from esoft.pf (hina.esoft.pf [192.168.10.2]) by hina.esoft.pf (Postfix) with ESMTP id 758838D8CC for ; Tue, 3 Sep 2002 17:44:13 -1000 (TAHT) Message-ID: <3D75818D.9020909@esoft.pf> Date: Tue, 03 Sep 2002 17:44:13 -1000 From: Jean-Denis Girard Organization: Essential Software User-Agent: Mozilla/5.0 (X11; U; Linux i586; en-US; rv:1.0rc1) Gecko/00200203 X-Accept-Language: fr-fr, fr, en-us MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: Fatal error Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/25 X-Sequence-Number: 3086 Hi, Last tuesday I upgraded a production DB from 7.1 to 7.2. Everything seemed fine till saturday, nightly vacuum exited with: Debut: Sat Aug 31 04:00:01 TAHT 2002 FATAL 2: open of /var/lib/pgsql/data/pg_clog/0323 failed: No such file or directory server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. connection to server was lost Fin: Sat Aug 31 04:01:03 TAHT 2002 -*-*-*- Debut: Sun Sep 1 04:00:00 TAHT 2002 FATAL 2: open of /var/lib/pgsql/data/pg_clog/027E failed: No such file or directory server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. connection to server was lost Fin: Sun Sep 1 04:00:32 TAHT 2002 The files actually do not exist. After "truncating" (not "dropping") the offending table and reloading it, the error disappeared. This is a Linux system, with stock 2.4.18 kernel; no other problem on the system (public web server). /var/lib/pgsql is on its on Reiserfs partition, with plenty of room left. Database is mainly accessed trough Perl-DBI + DBD-Pg-1.13. No other component except Postgres and DBD-Pg were updated last week. Don't know what to do and any help will be welcome. I can also provide more specific information if needed. -- Jean-Denis Girard ==================================================== Essential Software - Ingénierie Informatique Solutions Linux & Open Source en Polynésie française ---------------------------------------------------- http://www.esoft.pf/ Tél: (689) 50 82 89 ====================================================