Re: select failure

From: Gunther Schadow <gunther(at)aurora(dot)regenstrief(dot)org>
To: Ian Cass <ian(dot)cass(at)mblox(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: select failure
Date: 2002-06-09 18:10:52
Message-ID: 3D039A2C.5000906@aurora.regenstrief.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Ian Cass wrote:

> Ideas where I should look for the answer to this problem & how I should fix
> it?
>
> observer=# select host, current_route, count(current_route)
> observer-# from messages_200205
> observer-# group by host, current_route;
> FATAL 2: open of /var/lib/postgres/data/pg_clog/0534 failed: No such file
> or directory

OUCH! that looks quite bad. It's a postgresql internal error.
What version of PostgreSQL do you run? Is this some beta version?
Or do you have someone deleting files randomly?

regards,
-Gunther

--
Gunther Schadow, M.D., Ph.D. gschadow(at)regenstrief(dot)org
Medical Information Scientist Regenstrief Institute for Health Care
Adjunct Assistant Professor Indiana University School of Medicine
tel:1(317)630-7960 http://aurora.regenstrief.org

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-06-09 18:57:06 Re: Q: will GROUP BY make use of an index to return tuples early?
Previous Message Gunther Schadow 2002-06-09 17:43:44 Support for distributed queries with semijoins could be possible, if ...