Re: clog problem + version info

From: Bob Parkinson <rwp(at)biome(dot)ac(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: clog problem + version info
Date: 2002-09-04 10:43:35
Message-ID: Pine.BSF.4.44.0209041133200.28255-100000@gw7200.nottingham.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Doh, postgres-7.2.1 on freebsd4.3

On Wed, 4 Sep 2002, Bob Parkinson wrote:

> I've got this:
>
> FATAL 2: open of /usr/local/pgsql/data/pg_clog/02B6 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
>
> This was when the nightly vacuum was running.
>
> I had this problem a few weeks ago and had to restore from a backup. Whats
> is causing this? I've seen some refs. to clog problems relating to
> 7.2.beta somethin, but not found any resoloution.
>
> Cheers,
>
> Bob
>
> Bob Parkinson
> rwp(at)biome(dot)ac(dot)uk
> ------------------------------------------------------------------
> Technical Manager: Biome http://biome.ac.uk/
>
> Greenfield Medical Library,
> Queens Medical Centre,
> Nottingham. 0115 9249924 x 42059
> ------------------------------------------------------------------
> We are stardust
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

Bob Parkinson
rwp(at)biome(dot)ac(dot)uk
------------------------------------------------------------------
Technical Manager: Biome http://biome.ac.uk/

Greenfield Medical Library,
Queens Medical Centre,
Nottingham. 0115 9249924 x 42059
------------------------------------------------------------------
We are stardust

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2002-09-04 10:52:22 Re: Screwy behavior with SUM and multiple joins to same
Previous Message Oliver Elphick 2002-09-04 10:23:41 Re: Screwy behavior with SUM and multiple joins to same