| From: | Mauri Sahlberg <Mauri(dot)Sahlberg(at)claymountain(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | A nightmare |
| Date: | 2005-05-02 06:19:28 |
| Message-ID: | 1115014768.8003.9.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
I'm starting to become desperate. On saturday I dumped all databases,
wiped whole postgresql installation. Installed newest rpms for Fedora 1,
restored databases. Recompiled client libraries and binaries. Restarted
and after five hours of operation:
May 1 21:34:19 claymountain postgres[6337]: [2-1] ERROR: could not
access status of transaction 4250811410
May 1 21:34:19 claymountain postgres[6337]: [2-2] DETAIL: could not
open file
"/var/lib/pgsql/data/pg_clog/0FD5": No such file or directory
Is there anything else I could do than dump, wipe, restore again? Isn't
there anything I could do to try to get more detailed meaningful
information on why this is happening?
All that the log shows before this happening are a few unexpected client
disconnections.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lentes, Bernd | 2005-05-02 07:40:17 | Re: Suse 9.2 stops booting while starting the postgres-server |
| Previous Message | Gourish Singbal | 2005-05-02 05:11:52 | Re: measuring most-expensive queries |