Re: Could not create relation: File exists error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jesse Cleary <jcleary(at)email(dot)unc(dot)edu>
Cc: PGSQL-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Could not create relation: File exists error
Date: 2007-03-27 04:37:08
Message-ID: 11673.1174970228@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jesse Cleary <jcleary(at)email(dot)unc(dot)edu> writes:
> This script has been running successfully for several months (70-90 min each night). Out of the blue I'm now getting the following error message after each psql command, except the last vacuum full analyze command:

> ERROR: could not create relation 1663/835021/4294967254: File exists

Hm, it seems suggestive that the last number is only a few counts short
of UINT_MAX. Not sure what to make of it though. Do you in fact have
files under $PGDATA/base/835021/ with names in that range?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2007-03-27 04:54:10 Re: pg_dump without psql rights
Previous Message Michael Fuhr 2007-03-27 04:10:09 Re: How can I select a comment on a column?